在学习Python 处理Excel 表格时候,首先要打开文件,但在打开文件运行时候,出现错误内容如下:
Traceback (most recent call last):
File “D:\python\pythonProject\2020-11-26学习内容.py”, line 4, in
sheet = xlrd.open_workbook(work, encoding_override=“utf-8”)
File “C:\Users\ThinkPad\AppData\Local\Programs\Python\Python39\lib\site-packages\xlrd_init_.py”, line 111, in open_workbook
with open(filename, “rb”) as f:
OSError: [Errno 22] Invalid argument: ‘d:\python\pythonProject\test.xlsx’
源文件如下
mport xlrd
work = "d:\python\pythonProject\test.xlsx"
sheet = xlrd.open_workbook(work, encoding_override="utf-8")
tts1 = sheet.sheets()
sheet_name = [] # 获取表格名称
sheet_row = [] # 获取表格多少行
sheet_col = [] # 获取表格多少列
for sheet in tts1: # 这个命令的意思是从sheet这个表格搜寻到tts1这个表格。
sheet_name.append(sheet.name)
sheet_row.append(sheet.nrows)
sheet_col.append(sheet.ncols)
print("该Excel共有{0}个sheet,