Out of memory exception

Jan 18, 2014 at 6:39 PM
I have 8 gb of RAM & 64 bit windows 7 OS.
I am trying to create an excel (XLSX) having 65K records & 125 columns. Whatever I do, ExcelPackage.save() to save as a physical file or get bytes, all giving me out of memory exception. I have to create 7 tabs in total in this workbook all may contains close to 65K records each with 6 sheets having 10-20 columns & 1 sheet contains 125 columns... I have even tried to create separate package for all sheets & then try to copy them in a single package but that also nt working...

Any help plzzz