Exception

[SimonCoghlan]

EPPlus usage

Commercial use (I have a commercial license)

Environment

Windows - service
32 Cores
128GB of Mem
NVMe drives

Epplus version

7.2.0 (But it also happens in the latest 8.5.4)

Spreadsheet application

Excel 365

Description

When opening a large XLSX file which has a single sheet of 2.6GB (Might not be the case due to this..)
I get the following exception when trying to assign the workbook (Nothing else has happened since the open!)
i.e. the last line of the following in a .Net8 application:

        #region hack to bypass https://github.com/EPPlusSoftware/EPPlus/issues/2120
        await Task.Run(async () => await _ep.LoadAsync(filePath, ct).ConfigureAwait(false),
                ct)
            .ConfigureAwait(false);
        ct.ThrowIfCancellationRequested();
        #endregion
        _wb = _ep.Workbook;

For 7.2.0:

   at Microsoft.IO.RecyclableMemoryStream.ThrowDisposedException()
   at Microsoft.IO.RecyclableMemoryStream.Seek(Int64 offset, SeekOrigin loc)
   at OfficeOpenXml.Packaging.Ionic.Zip.ZipInputStream.Seek(Int64 offset, SeekOrigin origin)
   at OfficeOpenXml.Packaging.Ionic.Zip.ZipInputStream.set_Position(Int64 value)
   at OfficeOpenXml.ExcelWorksheet.MoveEntry(ZipInputStream zip, ZipEntry entry)
   at OfficeOpenXml.ExcelWorksheet.CreateXml()
   at OfficeOpenXml.ExcelWorksheet..ctor(XmlNamespaceManager ns, ExcelPackage excelPackage, String relID, Uri uriWorksheet, String sheetName, Int32 sheetID, Int32 positionID, Nullable`1 hide)
   at OfficeOpenXml.ExcelWorksheets..ctor(ExcelPackage pck, XmlNamespaceManager nsm, XmlNode topNode)
   at OfficeOpenXml.ExcelWorkbook.get_Worksheets()
   at OfficeOpenXml.ExcelWorkbook.GetDefinedNames()
   at OfficeOpenXml.ExcelPackage.get_Workbook()

For 8.5.4:

   at System.ThrowHelper.ThrowObjectDisposedException_StreamClosed(String objectName)
   at System.IO.MemoryStream.Seek(Int64 offset, SeekOrigin loc)
   at OfficeOpenXml.Packaging.Ionic.Zip.ZipInputStream.Seek(Int64 offset, SeekOrigin origin)
   at OfficeOpenXml.Packaging.Ionic.Zip.ZipInputStream.set_Position(Int64 value)
   at OfficeOpenXml.ExcelWorksheet.MoveEntry(ZipInputStream zip, ZipEntry entry)
   at OfficeOpenXml.ExcelWorksheet.CreateXml()
   at OfficeOpenXml.ExcelWorksheet..ctor(XmlNamespaceManager ns, ExcelPackage excelPackage, String relID, Uri uriWorksheet, String sheetName, Int32 sheetID, Int32 positionID, Nullable`1 hide)
   at OfficeOpenXml.ExcelWorksheets..ctor(ExcelPackage pck, XmlNamespaceManager nsm, XmlNode topNode)
   at OfficeOpenXml.ExcelWorkbook.get_Worksheets()
   at OfficeOpenXml.ExcelWorkbook.GetDefinedNames()
   at OfficeOpenXml.ExcelPackage.get_Workbook()

[SimonCoghlan]

Before anyone says: "Oh is the cancellationToken being cancelled, well that does not fire!
AND
if I change the code to the following:
_ep.Load(File.OpenRead(filePath));
It will work as expected (Via the sequential call) in the latest 8.5.4 & 7.3.0
but still fails with the same exception for 7.2.0 -> 7.2.2

[SimonCoghlan]

Ok, the above comment was for the 2.6GB (Unzipped) Sheet file
Now with the 4.4GB (Unzipped) sheet it fails with the Same exception in ALL versions

[JanKallman]

Hard to tell why you get this exception. If you compile your application for x64 and don't have the prefer x32 flag set, a 2.6GB should not be a problem with your hardware spec.
Can you add link to your workbook or create a support case in our support portal with a link where we can download it? Then we can have a look at the issue.