1.在Python3.8环境中,输入以下代码:
import xlrd
workbook = xlrd.open_workbook(r'C:\Users\pc\Desktop\学习\测试代码\cesi.xls')
print(workbook.sheet_names())
[u'Sheet1', u'Sheet2', u'Sheet3']
2.提示以下错误:
C:\Users\pc\Desktop\学习\测试代码\venv\Scripts\python.exe C:/Users/pc/Desktop/学习/测试代码/测试.py
Traceback (most recent call last):
File "C:/Users/pc/Desktop/学习/测试代码/测试.py", line 2, in <module>
workbook = xlrd.open_workbook(r'C:\Users\pc\Desktop\学习\测试代码\cesi.xls')
File "C:\Users\pc\Desktop\学习\测试代码\venv\lib\site-packages\xlrd\__init__.py", line 111, in open_workbook
with open(filename, "rb") as f:
OSError: [Errno 22] Invalid argument: '\u202aC:\\Users\\pc\\Desktop\\学习\\测试代码\\cesi.xls'
Process finished with exit code 1
想请问是哪里出错了呢?