CODEWITHSUNDEEP
javaexcel
Julik
Julik

Reputation: 71

apache poi so slow to read an xlsx file

I am trying to read in java(using Apache POI) an xlsx file, but it takes so much time... I don't know why it happens, I have already tried to increase a JVM heap but it doesn't work... The excel file has 28000 rows, but i don't read a sheet, It begins to be slow when I just create a workbook like that: 

file = new FileInputStream(xlsxPath);
XSSFWorkbook workbook = new XSSFWorkbook(file);

What is the meter of this strange behaviour of Apache POI, maybe someone has already had this problem, what is the solution, thank you all for your help!!!

Upvotes: 4

Views: 3161

Answers (1)

user3526455
user3526455

Reputation: 31

Have you try to use

  BufferedInputStream bfs = new BufferedInputStream
  XSSFWorkbook workbook = new XSSFWorkbook(bfs);

Upvotes: 1

Related Questions