io = ExcelFile(io, engine=engine) File "C:\Users\Public\Continuum\Anaconda35\lib\site-packages\pandas\io\excel.py", line 206, in __init__ self.book = xlrd.open_workbook(io) File "C:\Users\Public\Continuum\Anaconda35\lib\site-packages\xlrd__init__.py", line 394, in open_workbook ...
(1)将写入文件后缀名.xlsx改成.xls,否则进行写入操作很可能会出现:对excel文件操作并保存后(save函数),文件被破坏无法打开的情况 (2)要代码操作的文件不要打开,否则可能会有权限被拒报错:PermissionError: [Errno 13] Permission denied (3)若对一个单元格重复操作,会引发returns error:Exception: Attempt to ove...
也许与共享驱动器权限和read_excel函数有关。您可以设定engine = 'xlrd'，然后在Excel开启档案时执行程式...
in main blend = plStream(rootDir); File "C:\Users\Public\workspace\a.py", line 20, in plStream df = pd.read_excel(fPath, sheetname="linear strategy", index_col="date", parse_dates=True) File "C:\Users\Public\Continuum