#读取excel,将每行数据放入一个列表,将所有列表放入一个列表形成二维列表,返回该二维列表import xlrd
class ReadExcel:
def read_excel(self,path):
book = xlrd.open_workbook(path)
sheet = book.sheets()[0]
li = []
for i in range(1, sheet.nrows):
li.append(sheet.row_values(i))
return li
posted on
2019-11-28 19:42badbadboy
阅读(196)
评论(0)
收藏举报