Блог

Я использую Pandas v.1.2.2. Я получаю a zipfile.BadZipFile: File is not a zip file при попытке открыть вновь созданный test.xlsx файл с openpyxl помощью .

 import pandas as pd
from openpyxl import load_workbook

with pd.ExcelWriter("test.xlsx") as writer:
    load_workbook(writer)
 

Вот ‘обратная трассировка:

 Traceback (most recent call last):
  File "C:/Users/D292498/PycharmProjects/sov_rating/test.py", line 5, in <module>
    load_workbook(writer)
  File "C:UsersD292498AppDataLocalcondacondaenvssov_rating_py38libsite-packagesopenpyxlreaderexcel.py", line 315, in load_workbook
    reader = ExcelReader(filename, read_only, keep_vba,
  File "C:UsersD292498AppDataLocalcondacondaenvssov_rating_py38libsite-packagesopenpyxlreaderexcel.py", line 124, in __init__
    self.archive = _validate_archive(fn)
  File "C:UsersD292498AppDataLocalcondacondaenvssov_rating_py38libsite-packagesopenpyxlreaderexcel.py", line 96, in _validate_archive
    archive = ZipFile(filename, 'r')
  File "C:UsersD292498AppDataLocalcondacondaenvssov_rating_py38libzipfile.py", line 1269, in __init__
    self._RealGetContents()
  File "C:UsersD292498AppDataLocalcondacondaenvssov_rating_py38libzipfile.py", line 1336, in _RealGetContents
    raise BadZipFile("File is not a zip file")
zipfile.BadZipFile: File is not a zip file
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
  File "<input>", line 1, in <module>
  File "C:Program FilesJetBrainsPyCharm 2019.2.1helperspydev_pydev_bundlepydev_umd.py", line 197, in runfile
    pydev_imports.execfile(filename, global_vars, local_vars)  # execute the script
  File "C:Program FilesJetBrainsPyCharm 2019.2.1helperspydev_pydev_imps_pydev_execfile.py", line 18, in execfile
    exec(compile(contents "n", file, 'exec'), glob, loc)
  File "C:/Users/D292498/PycharmProjects/sov_rating/test.py", line 5, in <module>
    load_workbook(writer)
  File "C:UsersD292498AppDataLocalcondacondaenvssov_rating_py38libsite-packagespandasioexcel_base.py", line 894, in __exit__
    self.close()
  File "C:UsersD292498AppDataLocalcondacondaenvssov_rating_py38libsite-packagespandasioexcel_base.py", line 898, in close
    content = self.save()
  File "C:UsersD292498AppDataLocalcondacondaenvssov_rating_py38libsite-packagespandasioexcel_openpyxl.py", line 54, in save
    self.book.save(self.handles.handle)
  File "C:UsersD292498AppDataLocalcondacondaenvssov_rating_py38libsite-packagesopenpyxlworkbookworkbook.py", line 392, in save
    save_workbook(self, filename)
  File "C:UsersD292498AppDataLocalcondacondaenvssov_rating_py38libsite-packagesopenpyxlwriterexcel.py", line 293, in save_workbook
    writer.save()
  File "C:UsersD292498AppDataLocalcondacondaenvssov_rating_py38libsite-packagesopenpyxlwriterexcel.py", line 275, in save
    self.write_data()
  File "C:UsersD292498AppDataLocalcondacondaenvssov_rating_py38libsite-packagesopenpyxlwriterexcel.py", line 89, in write_data
    archive.writestr(ARC_WORKBOOK, writer.write())
  File "C:UsersD292498AppDataLocalcondacondaenvssov_rating_py38libsite-packagesopenpyxlworkbook_writer.py", line 148, in write
    self.write_views()
  File "C:UsersD292498AppDataLocalcondacondaenvssov_rating_py38libsite-packagesopenpyxlworkbook_writer.py", line 135, in write_views
    active = get_active_sheet(self.wb)
  File "C:UsersD292498AppDataLocalcondacondaenvssov_rating_py38libsite-packagesopenpyxlworkbook_writer.py", line 33, in get_active_sheet
    raise IndexError("At least one sheet must be visible")
IndexError: At least one sheet must be visible