Free Support Forum -

LightCellsDataProvider Example for a CSV

I’m just looking for a quick example of how to generate a very large excel file from a csv file. I’ve tried to generate an excel conventionally but I’ve run into memory errors. The best I’ve been able to do is to import 360,000 rows of 69 columns. I’d like to try the LightCellsDataProvider but am having problems understanding how to make it work. Can you help?


I have requested the development team to provide a code example for your needs if that’s possible. I have logged this issue in our database. We will update you once we get some update for it.

This issue has been logged as CELLSJAVA-29569.


Please see attached example which reads data from csv file and saves to excel file by LightCellsDataProvider.