Error creating large Excel sheet

Aspose.Cells Product Family
1

Dear Aspose Tech Support,

I am trying to create a large Excel sheet with Aspose.Cell. The Save operation keeps failing with the following error:

“Compressed or Uncompressed size, or offset exceeds the maximum value consider setting the useZip64WhenSaving property on the ZipFile instance”

Can you please provide an update with the internal useZip64WhenSaving property set to true.

Thanks,

2

@InnovativeDiscovery

Thanks for using Aspose APIs.

The following sample code explains how to use EnableZip64 property. Please read the comment inside the code for more help.

C#

Workbook wb = new Workbook();

Worksheet ws = wb.Worksheets[0];

Cell cell = ws.Cells["B4"];
cell.PutValue("This is text.");

//How to use EnableZip64 property
OoxmlSaveOptions osp = new OoxmlSaveOptions();
osp.EnableZip64 = true;

wb.Save("output.xlsx", osp);