|

楼主 |
发表于 2023-7-25 21:13:15
|
显示全部楼层
报了很多错误信息,参考如下,把俺都搞糊涂了:
wb=openpyxl.load_workbook(r'C:\Users\86188\Desktop\daishan\原始数据')
Traceback (most recent call last):
File "<pyshell#13>", line 1, in <module>
wb=openpyxl.load_workbook(r'C:\Users\86188\Desktop\daishan\原始数据')
File "D:\Python\Lib\site-packages\openpyxl\reader\excel.py", line 344, in load_workbook
reader = ExcelReader(filename, read_only, keep_vba,
File "D:\Python\Lib\site-packages\openpyxl\reader\excel.py", line 123, in __init__
self.archive = _validate_archive(fn)
File "D:\Python\Lib\site-packages\openpyxl\reader\excel.py", line 93, in _validate_archive
raise InvalidFileException(msg)
openpyxl.utils.exceptions.InvalidFileException: openpyxl does not support file format, please check you can open it with Excel first. Supported formats are: .xlsx,.xlsm,.xltx,.xltm |
|