運行報錯提示
import?xlrd
d1?=?xlrd.open_workbook('dat1.xlsx')
print(d1.sheet_loaded(0))
d2?=?xlrd.open_workbook("C:\Users\wangming\Desktop\dat2.xlsx")
print(d2.sheet_loaded(0))運行結果
"F:\Program Files (x86)\python\python.exe" E:/python實操/index.py
? File "E:/python實操/index.py", line 4
? ? d2 = xlrd.open_workbook("C:\Users\wangming\Desktop\dat2.xlsx")
? ? ? ? ? ? ? ? ? ? ? ? ? ?^
SyntaxError: (unicode error) 'unicodeescape' codec can't decode bytes in position 2-3: truncated \UXXXXXXXX escape
2021-11-11
import?xlrd d1?=?xlrd.open_workbook('dat1.xlsx') print(d1.sheet_loaded(0)) d2?=?xlrd.open_workbook("C:\Users\wangming\Desktop\dat2.xlsx") print(d2.sheet_loaded(0))把第4行中的路徑，從反斜杠轉換成正斜杠。
還有就是xlrd開不了Excel xlsx 的文件