I am trying to read a large excel file and I already have a Java code which uses POI to do it. However, the code works only for a small file and if the file size is more that is if there are more than 10,000 rows I am getting out of memory error when deployed and tested in Websphere server.
So I need modification to attached java code to read excel file for at least 100,000 rows. The project is only to read the large excel file and I have rest of the code already in place. More details are in the attached requirement document.
HI, I can provide you the script in PHP to read large data file in excel.
Please let us know if it is okay with you.
We are looking forward for your response.
Thanks.
I read and understood your requirement. I have got good experience in Java and POI. I have done many applications with large files using POI. Let us connect and discuss this further to take it forward.