Click here to Skip to main content
15,880,299 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:

Workbook workbook = WorkbookFactory.create(file);
Updated 24-Oct-23 12:25pm

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