New Discussion

Notifications

You’re not receiving notifications from this thread.

Handling large-ish Excel files with Apache POI

0
General

Hi,

I'm working on an application which takes Excel files as inputs. These files may have some tens of columns and several hundred thousand rows. They reach 50-60mb in size on the disk. hotmail.com

I'm mainly using java 1.8 and JSF 2.0, as well as apache POI (and a bunch of other libraries which are not important now). 10.0.0.0.1

What I need to be doing is to permit the user to associate the headers to a certain expected header. For example, you expect a header called Frequency and you have an input called Freq.

What needs to happen after is that I should let the user redownload his/her input file, with the expected column names. 192.168.1.254

What I do is I recreate a blank sheet and repopulate it with the new headers and data from the old file.

Join the discussion
Create an account Log in

Want to stay up-to-date with Ruby on Rails?

Join 88,440+ developers who get early access to new tutorials, screencasts, articles, and more.

    We care about the protection of your data. Read our Privacy Policy.