fastest way to read data from a huge excel file in java

Question

I have an excel file downloaded from SAP. I want to read particular columns from that file, create a json object from it and then render it on a jsp. what would be the fastest way to do it?

Does this answer your question? [How to open a huge excel file efficiently](https://stackoverflow.com/questions/46373895/how-to-open-a-huge-excel-file-efficiently) - check the Java Answers, it is fantastic. — Jeremy Thompson, Dec 05 '22 at 05:04

score 1 · Answer 1 · answered May 28 '13 at 03:15

I'm fond of JExcel for it's simplicity, but it loads the entire spreadsheet into memory. If you have enough memory for this, I'd use it.

If you don't have sufficient memory to read the entire file into memory, then you'll probably want to use the streaming capabilities of POI-XSSF

score 0 · Answer 2 · answered May 28 '13 at 02:32

0

i'am oftenly use talend http://www.talend.com/products/talend-open-studio. as far as i try it, you can generate a web service that meets your needs, from excel convert to json and certain data.

answered May 28 '13 at 02:32

Arif Setyawan

187
1
6

fastest way to read data from a huge excel file in java

2 Answers2