网问答>>Python 调用xlrd读取excel的时候报错?
问题
已解决

Python 调用xlrd读取excel的时候报错?

时间:2020-07-06 20:26:39
1.在Python3.8环境中,输入以下代码:import xlrdworkbook = xlrd.open_workbook(rC:UserspcDesktop学习测试代码cesi.xls)print(workbook.sheet_names())[uSheet1, uSheet2, uSheet3]2.提示以下错误:C:UserspcDesktop学习测试代码venvScriptspython.exe C:/Users/pc/Desktop/学习/测试代码/测试.pyTraceback (most recent call last): File "C:/Users/pc/Desktop/学习/测试代码/测试.py", line 2, in module workbook = xlrd.open_workbook(rC:UserspcDesktop学习测试代码cesi.xls) File "C:UserspcDesktop学习测试代码venvlibsite-packagesxlrd__init__.py", line 111, in open_workbook with open(filename, "rb") as f:OSError: [Errno 22] Invalid argument: u202aC:UserspcDesktop学习测试代码cesi.xlsProcess finished with exit code 1想请问是哪里出错了呢?
最佳回答
(rC这里c前面可能带有特殊字符最好重新手打一下,是不是你从别的地方复制来的
时间:2020-07-06 20:26:46
文件路径错了吧,
时间:2020-07-06 20:26:49
本类最有帮助
Copyright © 2008-2013 www.wangwenda.com All rights reserved.冀ICP备12000710号-1
投诉邮箱: