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.
.xls
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)?
.xlsx