一、模块安装
pip install xlrd
二、操作excel封装
代码如下(示例):
import xlrd
class OperateExcel():
def __init__(self,filname=None,sheetid=None):
self.filename = filname
self.sheetid = sheetid
self.data = self.get_data()
def get_data(self):
"获取sheet内容"
data = xlrd.open_workbook(self.filename)
tables = data.sheets()[self.sheetid]
return tables
def get_lines(self):
"获取单元格行数"
tables = self.data
return tables.nrows
def get_cell_value(self,row,col):
"获取某个单元格内容"
return self.data.cell_value(row,col)
if __name__ == '__main__':
filename = r".\hello.xls"
sheetid = 0
print(filename)
obj = OperateExcel(filename,sheetid)
print(obj.get_data().nrows)
print(obj.get_cell_value(0,0))
hello.xls