This project has moved. For the latest updates, please go here.

Writing data in excel in batch's

Aug 29, 2012 at 6:30 AM

Hi All,

Is it possible to write data in excel in multiple batch's. Currently after writing 8 million cells into excel, I am getting memoery exception. I am thinking of writing first 4 million cells into excel and then save the file and then write the remaining cells in batch of 4 million cells.

Is it even possible? If not, do we have any work arounds?

Editor
Aug 29, 2012 at 11:06 AM

Yes and No. Yes, you can open an existing excel file, but when you loaded, it will copy entirely to memory.