I got an error when I put in the code below after deploying Anaconda.
The Anaconda file seems to be insufficient, but I can't consider it because it's the default installation.Could you tell me how to solve this problem?
import openpyxl
wb=openpyxl.load_workbook('example.xlsx')
>>import openpyxl
>>>wb=openpyxl.load_workbook('example.xlsx')
Traceback (most recent call last):
File "<pyshell#1>", line 1, in <module>
wb=openpyxl.load_workbook('example.xlsx')
File "C:\Users\user\Anaconda3_2\lib\site-packages\openpyxl\reader\excel.py", line 312, inload_workbook
reader.read()
File "C:\Users\user\Anaconda3_2\lib\site-packages\openpyxl\reader\excel.py", line 268, in read
self.read_manifest()
File "C:\Users\user\Anaconda3_2\lib\site-packages\openpyxl\reader\excel.py", line 136, read_manifest
src=self.archive.read(ARC_CONTENT_TYPES)
File "C:\Users\user\Anaconda3_2\lib\zipfile.py", line 1428, in read
with self.open(name, "r", pwd) asfp:
File "C:\Users\user\Anaconda3_2\lib\zipfile.py", line 1467, in open
zinfo=self.getinfo(name)
File "C:\Users\user\Anaconda3_2\lib\zipfile.py", line 1395, ingetinfo
'There is no item named %rin the archive' %name)
KeyError: "There is no item named '[Content_Types].xml 'in the archive"
Download from Anaconda
https://www.anaconda.com/distribution/
Anaconda 2019.03 for Windows Installer
Download the Python 3.7 version of 64-Bit Graphical Installer (662MB)
Windows 10
python python3 anaconda
Thank you, everyone.
I was able to solve myself.
The reason was that I was using OpenOffice.I introduced a different free software and it worked.
© 2024 OneMinuteCode. All rights reserved.