All threads / Handling large-ish Excel files with Apache POI

Ask A Question

Notifications

You’re not receiving notifications from this thread.

Handling large-ish Excel files with Apache POI

Tonnystark asked in 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

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

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

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

    logo Created with Sketch.

    Ruby on Rails tutorials, guides, and screencasts for web developers learning Ruby, Rails, Javascript, Turbolinks, Stimulus.js, Vue.js, and more. Icons by Icons8

    © 2020 GoRails, LLC. All rights reserved.