c# - 如何使用 Epplus 在 C# (WPF) 中将批量数据导出到 Excel？

Question

批量导出300000行以上数据时出现Memory out Exception

using (var p = new ExcelPackage())
 {

            ExcelWorksheet ws = CreateSheet(p, _workbookProperties.WorksheetName);



            ws.Cells[1, 1, 1, dt.Columns.Count].Style.Font.Bold = true;
            ws.Cells[1, 1, 1, dt.Columns.Count].Style.HorizontalAlignment = ExcelHorizontalAlignment.Center;

            int rowIndex = 1;

            CreateHeader(ws, ref rowIndex, dt);
            CreateData(ws, ref rowIndex, dt);
            //CreateFooter(ws, ref rowIndex, dt);




            Byte[] bin = p.GetAsByteArray();

            var tempFolder = Environment.ExpandEnvironmentVariables("%TEMP%");
            string file = String.Format("{0}\\{1}-{2}.xlsx", tempFolder, _workbookProperties.WorkbookName, DateTime.Now.ToString("MMddyyyymmss"));
            File.WriteAllBytes(file, bin);


            //These lines will open it in Excel
            var pi = new ProcessStartInfo(file);
            Process.Start(pi);
        }

Answer 1

将应用程序更改为 64 位，您将解决内存问题。