Excel can't work because of too much data(Excel_Export_GenerateFile)

Excel can't work because of too much data(Excel_Export_GenerateFile)

  


I want to use this method (Excel_Export_GenerateFile) to produce Excel files, but when the amount of data exceeds 100,000, it will not work, or it will take a lot of time. 


Solution

Hi Yangyi, 

From my experience, when exporting large amount of data, you may want to export as a csv instead of excel (the overheads is alot lower). The csv can still be opened and converted to excel format by the end user. 


Solution