对于xlsx格式的表格文件可以安装调用xlrd
去读取表格内容,具体例子如下:
- 安装xlrd
pip install xlrd
- 读取xlsx文件内容
workbook = xlrd.open_workbook("filname.xlsx")
worksheet = workbook.sheet_by_index(0) # 读取excel表格的sheet
for i in range(worksheet
对于xlsx格式的表格文件可以安装调用xlrd
去读取表格内容,具体例子如下:
pip install xlrd
workbook = xlrd.open_workbook("filname.xlsx")
worksheet = workbook.sheet_by_index(0) # 读取excel表格的sheet
for i in range(worksheet