python读取excel全部数据

#coding=utf-8
import requests
import json
import xlrd
from lxml import html

#路径前加 r，读取的文件路径
file_path = r’C:/test.xls’
workbook = xlrd.open_workbook(file_path)

根据sheet索引或者名称获取sheet内容

Data_sheet = workbook.sheets()[0] # 通过索引获取

rowNum = Data_sheet.nrows # sheet行数
colNum = Data_sheet.ncols # sheet列数

获取所有单元格的内容

list = []
for i in range(rowNum):
rowlist = []
for j in range(colNum):
rowlist.append(Data_sheet.cell_value(i, j))
list.append(rowlist)