title: "BadZipFile: File is not a zip file" - Error popped up all of a sudden
body: <p>One minute my script works multiple days in a row, next minute I get this error.</p>
  
  <pre><code>  File "&lt;ipython-input-196-abdb28a77366&gt;", line 1, in &lt;module&gt;
      runfile('F:/-/-/-/cleaner_games_appstore_babil.py', wdir='F:/-/-/-')
  
    File "C:\ProgramData\Anaconda3\lib\site-packages\spyder_kernels\customize\spydercustomize.py", line 827, in runfile
      execfile(filename, namespace)
  
    File "C:\ProgramData\Anaconda3\lib\site-packages\spyder_kernels\customize\spydercustomize.py", line 110, in execfile
      exec(compile(f.read(), filename, 'exec'), namespace)
  
    File "F:/-/-/-/cleaner_games_appstore_babil.py", line 112, in &lt;module&gt;
      append_df_to_excel("stillfront.xlsx", dff, sheet_name='Apple_Babil', startrow=None, truncate_sheet=False, engine='openpyxl', header = False)
  
    File "F:/-/-/-/cleaner_games_appstore_babil.py", line 84, in append_df_to_excel
      writer.book = load_workbook(filename)
  
    File "C:\ProgramData\Anaconda3\lib\site-packages\openpyxl\reader\excel.py", line 311, in load_workbook
      data_only, keep_links)
  
    File "C:\ProgramData\Anaconda3\lib\site-packages\openpyxl\reader\excel.py", line 126, in __init__
      self.archive = _validate_archive(fn)
  
    File "C:\ProgramData\Anaconda3\lib\site-packages\openpyxl\reader\excel.py", line 98, in _validate_archive
      archive = ZipFile(filename, 'r')
  
    File "C:\ProgramData\Anaconda3\lib\zipfile.py", line 1222, in __init__
      self._RealGetContents()
  
    File "C:\ProgramData\Anaconda3\lib\zipfile.py", line 1289, in _RealGetContents
      raise BadZipFile("File is not a zip file")
  
  BadZipFile: File is not a zip file
  </code></pre>
  
  <p>To clarify I do not use any zip files. I found the code on here, StackOverflow, and there were not mentioning about the code not working, or error happening.</p>
  
  <p>The script is supposed to write my pandas DataFrame to an excel sheet. 
  Here's the part of the code that creates the error:</p>
  
  <pre><code>def append_df_to_excel(filename, df, sheet_name='Apple_Babil', startrow=None,
                         truncate_sheet=False, 
                         **to_excel_kwargs):
  
      # ignore [engine] parameter if it was passed
      if 'engine' in to_excel_kwargs:
          to_excel_kwargs.pop('engine')
  
      writer = pd.ExcelWriter(filename, engine='openpyxl')
      try:
  
          # try to open an existing workbook
          writer.book = load_workbook(filename)
          # get the last row in the existing Excel sheet
          # if it was not specified explicitly
          if startrow is None and sheet_name in writer.book.sheetnames:
              startrow = writer.book[sheet_name].max_row
  
          # truncate sheet
          if truncate_sheet and sheet_name in writer.book.sheetnames:
              # index of [sheet_name] sheet
              idx = writer.book.sheetnames.index(sheet_name)
              # remove [sheet_name]
              writer.book.remove(writer.book.worksheets[idx])
              # create an empty sheet [sheet_name] using old index
              writer.book.create_sheet(sheet_name, idx)
          # copy existing sheets
          writer.sheets = {ws.title:ws for ws in writer.book.worksheets}
  
      except FileNotFoundError:
          # file does not exist yet, we will create it
          pass
  
      if startrow is None:
          startrow = 0
      # write out the new sheet
      df.to_excel(writer, sheet_name, startrow=startrow, **to_excel_kwargs)
      # save the workbook
      writer.save()
  
  append_df_to_excel("stillfront.xlsx", dff, sheet_name='Apple_Babil', startrow=None, truncate_sheet=False, engine='openpyxl', header = False)
  </code></pre>
  
  <p>Code was not edited or anything, just started not working. </p>