can't load a workbook
Created originally on Bitbucket by aymeric75 (aymeric)
Hi everyone,
I'm trying to use the function load_workbook('exemples.xlsx'), but i have the following error:
#!python
Traceback (most recent call last):
File "C:\Users\aymericB\Desktop\Stage_2.py", line 95, in <module>
wb2 = load_workbook('exemples.xlsx')
File "C:\Python27\lib\site-packages\openpyxl-2.3.0_b1-py2.7.egg\openpyxl\reader\excel.py", line 150, in load_workbook
archive = _validate_archive(filename)
File "C:\Python27\lib\site-packages\openpyxl-2.3.0_b1-py2.7.egg\openpyxl\reader\excel.py", line 114, in _validate_archive
archive = ZipFile(filename, 'r', ZIP_DEFLATED)
File "C:\Python27\lib\zipfile.py", line 701, in __init__
self.fp = open(file, modeDict[mode])
IOError: [Errno 2] No such file or directory: 'exemples.xlsx'
Yet, i put the exemples.xlsx in the Python27 folder, which seems to be logic as when i do a "wb.save('aezeae') it saves the workbook in this folder...
Cheers
Aymeric