import xlrd
data=https://bbs.csdn.net/topics/xlrd.open_workbook('作業簿4.xlsx?')
反饋是
Traceback (most recent call last):
File "<pyshell#5>", line 1, in <module>
x1 = xlrd.open_workbook("作業簿4.xlsx")
File "/Library/Frameworks/Python.framework/Versions/3.8/lib/python3.8/site-packages/xlrd/__init__.py", line 111, in open_workbook
with open(filename, "rb") as f:
FileNotFoundError: [Errno 2] No such file or directory: '作業簿4.xlsx'
已經將資料存入該檔案夾下了啊
>>> import os
>>> print (os.path.abspath('.'))
/Users/zhangning
uj5u.com熱心網友回復：
好像是xlrd不能處理xlsx格式的檔案吧uj5u.com熱心網友回復：
改成xls的檔案試試uj5u.com熱心網友回復：
找朋友試了下調通了：import xlrd
data=https://bbs.csdn.net/topics/xlrd.open_workbook("~/作業簿4.xlsx?")
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/46686.html
上一篇：爬蟲問題