c# - Epplus, Out of memory -

sorry english. used library epplus , it. i've got problem: out of memory. need write large amounts of data, no matter what. want know possible append end of excel file not stored in memory of all. or create multiple files , concatenate 1 file. in advance.

1)if retrieve data database use datareader instead of datatable

2)write excel temp file, delete after done(if it's web environment, use response.writefile delete it)

3)write header first append data (using phone type this)

var pck = new excelpackage(); var ws = pck.addsheet("sheet1"); //write header here pck.saveas(fileinfo); pck.dispose(); // not sure if function existed pck= new excelpage(fileino.fullname); ws = pck.worksheets[1]; var rowindex =0; while (reader.read()) {     if (++rowindex % 100000 == 0)     {        // save , re-open     }     //write row here } pck.save(); //dispose / send file / delete file etc