Swapnadip  Saha

Swapnadip Saha

  • NA
  • 49
  • 520

Data Table or Dataset to .xlsx

May 15 2023 11:17 AM

I have a data table for Oracle stored procedure. It is generating more than 1 million rows. While converting into .xls, the size is almost 36 mb and it is showing an "out-of-memory" exception.

I am using C# and Crystal Reports libraries.

Is there any better way to create a .xlsx file (with all the data and smaller size)?


Answers (2)