python-excel 读取

import xlrd

class ReadExcel:
def __init__(self,filename,sheetname):
self.workbook = xlrd.open_workbook(filename)
self.sheetname = self.workbook.sheet_by_name(sheetname)

def read_cell(self,rownum, colnum):
return self.sheetname.cell(rownum,colnum).value

print(ReadExcel('test.xlsx','Sheet1').read_cell(1,1))
posted @ 2020-07-04 21:51  静惜  阅读(139)  评论(0)    收藏  举报