Click here to Skip to main content
15,850,265 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
We are using poi library for reading Excel file in our code and it is taking 20secs to read the file. Is there any alternate library for reading xls and xlsx library using Java.

What I have tried:

Java
Workbook workbook = WorkbookFactory.create(file);
Posted
Updated 24-Oct-23 13:25pm
v2

1 solution

You said it's a LARGE Excel file. The problem isn't really going to be the library you use, but the size of the file you're doing work on.

Unless you reduce the size of the file, or import it into some other data structure, you're going to have performance problems no matter which library you use. Depending on what you're doing, that may not be possible.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900