asp.net-core - 在 aspnet core 2.1 中使用 OpenXML 读取 500 MB xlsx 文件导致流太大

Question

在 aspnet core 2.1 中使用 OpenXML 读取 500 MB xlsx 文件会导致流过大。

是否有任何其他方式可以在 openXML 中读取 1 gb excl 文件

下面是我的代码

using (Stream stream = new FileStream(importExport.FileLocation, FileMode.Open, FileAccess.Read, FileShare.ReadWrite))
{
    using (SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Open(stream, false))
    {
        WorkbookPart workbookPart = spreadsheetDocument.WorkbookPart;
        IEnumerable<Sheet> sheets = spreadsheetDocument.WorkbookPart.Workbook.GetFirstChild<Sheets>().Elements<Sheet>();
        string relationshipId = sheets.First().Id.Value;
        WorksheetPart worksheetPart = (WorksheetPart)spreadsheetDocument.WorkbookPart.GetPartById(relationshipId);
        Worksheet workSheet = worksheetPart.Worksheet;
        ....
    }
}

我得到以下错误

标签： asp.net-core.net-coreasp.net-core-mvcasp.net-core-2.0asp.net-core-2.1