50 Experience
0 Lessons Completed
0 Questions Solved


Posted in Handling large-ish Excel files with Apache POI


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.

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).

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.

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

logo Created with Sketch.

Screencast tutorials to help you learn Ruby on Rails, Javascript, Hotwire, Turbo, Stimulus.js, PostgreSQL, MySQL, Ubuntu, and more. Icons by Icons8

© 2022 GoRails, LLC. All rights reserved.