EPPlus Large Dataset Issue with Out of Memory Exception

by

I had this problem, but I fixed it by switching the option of “Platform target“, from x86 to x64 or “Any CPU“. ( right click on the project, then select “Properties”, then the tab “Build”, then on “Platform target” select “x64” )

The problem is that for platform x86 you can use only about 1.8 GB of RAM. For platform x64, you do not have this limitation.

More Related Contents:

  1. Format excel column to decimal doing export from c#
  2. Export DataTable to Excel with EPPlus
  3. export to Excel from a list with EPPLUS
  4. Excel to DataTable using EPPlus – excel locked for editing
  5. C# create/modify/read .xlsx files
  6. EPPlus number format
  7. EPPlus – LoadFromCollection – Text converted to number
  8. How do I properly clean up Excel interop objects?
  9. How to export DataTable to Excel
  10. How to detect installed version of MS-Office?
  11. Reading Datetime value From Excel sheet
  12. How do I export to Excel?
  13. Reading excel file using OLEDB Data Provider
  14. How to get the range of occupied cells in excel sheet
  15. How to create CSV Excel file C#? [closed]
  16. How to open an Excel file in C#?
  17. How to read data from excel file using c# [duplicate]
  18. Excel interop: _Worksheet or Worksheet?
  19. Excel error HRESULT: 0x800A03EC while trying to get range with cell’s name
  20. How to add data table with legend keys to a MS Chart in C#?
  21. How to make correct date format when writing data to Excel
  22. OpenFileDialog can’t load CSV files but can load xls/xlsx Excel files [duplicate]
  23. Resources for learning c# Excel interop [closed]
  24. Read excel file from a stream
  25. open xml reading from excel file
  26. No definition found for GetActiveObject from System.Runtime.InteropServices.Marshal C#
  27. How can I programmatically create, read, write an excel without having office installed?
  28. Why appending AutoFilter corrupts my excel file in this example?
  29. Exporting to .xlsx using Microsoft.Office.Interop.Excel SaveAs Error
  30. Running an Excel Macro via C#: Run a macro from one workbook on another?

Leave a Comment