Reading a large excel file(.xlsx) using POI

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.

Skills: Java, Software Architecture

See more: apache poi streaming write, apache poi read large xlsx file, apache poi streaming api, how to read large xlsx file in java, sxssfworkbook read excel example, apache poi streaming read, reading large excel file in java using poi examples, apache poi write large excel files, convert large excel file database php, reading multiple excel file php, import excel file mysql using java, large excel file size, read excel file save using, reading data excel file using, reading numbers excel file, access large excel file, reading large csv file net, sending excel file outlook using, migration excel file database using cnet, reading data excel file

About the Employer:
( 3 reviews ) bangalore, India

Project ID: #15996108

3 freelancers are bidding on average ₹1517 for this job


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.

₹1750 INR in 1 day
(10 Reviews)

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.

₹1500 INR in 1 day
(20 Reviews)
₹1300 INR in 1 day
(0 Reviews)