" would require ZIP64 extensions" ) 大压缩文件：文件大小需要 ZIP64 扩展名

Question

你能帮我排序这个错误吗？当我试图写一个大文件时，我遇到了一个错误。有什么方法可以修复这个错误吗：

File "C:ProgramDataAnaconda3libzipfile.py", line 1696, in _writecheck
" would require ZIP64 extensions")
LargeZipFile: Filesize would require ZIP64 extensions

这是堆栈跟踪

File "<ipython-input-1-211b07c43cd8>", line 1, in <module>
runfile('C:/Users/Administrator/Desktop/new_paul.py', wdir='C:/Users/Administrator/Desktop')
File "C:ProgramDataAnaconda3libsite-packagesspyder_kernelscustomizespydercustomize.py", line 786, in runfile
execfile(filename, namespace)
File "C:ProgramDataAnaconda3libsite-packagesspyder_kernelscustomizespydercustomize.py", line 110, in execfile
exec(compile(f.read(), filename, 'exec'), namespace)
File "C:/Users/Administrator/Desktop/new_paul.py", line 106, in <module>
output_df = gen_stats()
File "C:/Users/Administrator/Desktop/new_paul.py", line 104, in gen_stats
return merge_main(all_users)
File "C:/Users/Administrator/Desktop/new_paul.py", line 99, in merge_main
all_users.to_excel('main_with_features_300win.xlsx', index=False)
File "C:ProgramDataAnaconda3libsite-packagespandascoregeneric.py", line 2127, in to_excel
engine=engine)
File "C:ProgramDataAnaconda3libsite-packagespandasioformatsexcel.py", line 664, in write
writer.save()
File "C:ProgramDataAnaconda3libsite-packagespandasioexcel.py", line 1952, in save
return self.book.close()
File "C:ProgramDataAnaconda3libsite-packagesxlsxwriterworkbook.py", line 306, in close
self._store_workbook()
File "C:ProgramDataAnaconda3libsite-packagesxlsxwriterworkbook.py", line 679, in _store_workbook
xlsx_file.write(os_filename, xml_filename)
File "C:ProgramDataAnaconda3libzipfile.py", line 1743, in write
with open(filename, "rb") as src, self.open(zinfo, 'w') as dest:
File "C:ProgramDataAnaconda3libzipfile.py", line 1470, in open
return self._open_to_write(zinfo, force_zip64=force_zip64)
File "C:ProgramDataAnaconda3libzipfile.py", line 1580, in _open_to_write
self._writecheck(zinfo)
File "C:ProgramDataAnaconda3libzipfile.py", line 1696, in _writecheck
" would require ZIP64 extensions")
LargeZipFile: Filesize would require ZIP64 extensions

Answer 1

初始化ZipFile时需要传递标志allowZip64=True，以允许其存储大于4GB的文件，或大于4GB本身。

假设这是需要在您使用的实现to_excel的任何库中修复的问题。你的问题中没有包括图书馆的身份，所以我们不能在这里与它交谈。

Answer 2

df=pandas.DataFrame(data)
with pandas.ExcelWriter(filename,engine='xlsxwriter') as writer:
writer.book.use_zip64()
df.to_excel(writer)
writer.save()

Answer 3

基于@Charles Duffy的分析，您可以使用xlsxwriter引擎启用ZIP64扩展，如下所示：

writer = pd.ExcelWriter('pandas.xlsx', engine='xlsxwriter')
df.to_excel(writer, sheet_name='Sheet1')
writer.book.use_zip64()

Answer 4

我在Python 2.7脚本中遇到了类似的错误，该脚本将空间表从Sql Server导出为shapefile格式，然后对其进行压缩。添加"allowZip64=True"作为参数有效：

zipObj = zipfile.ZipFile(nomZip, 'w', zipfile.ZIP_DEFLATED, allowZip64=True)