This project has moved and is read-only. For the latest updates, please go here.

Writing data in excel in batch's

Aug 29, 2012 at 7: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?

Aug 29, 2012 at 12:06 PM

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