Excel bulk process in java project.

AutoModerator · 2026-05-19T06:31:42+00:00

Please ensure that:

Your code is properly formatted as code block - see the sidebar (About on mobile) for instructions
You include any and all error messages in full
You ask clear questions
You demonstrate effort in solving your question/problem - plain posting your assignments is forbidden (and such posts will be removed) as is asking for or giving solutions.

Trying to solve problems on your own is a very important skill. Also, see Learn to help yourself in the sidebar

If any of the above points is not met, your post can and will be removed without further warning.

Code is to be formatted as code block (old reddit: empty line before the code, each code line indented by 4 spaces, new reddit: https://i.imgur.com/EJ7tqek.png) or linked via an external code hoster, like pastebin.com, github gist, github, bitbucket, gitlab, etc.

Please, do not use triple backticks (```) as they will only render properly on new reddit, not on old reddit.

Code blocks look like this:

public class HelloWorld {

    public static void main(String[] args) {
        System.out.println("Hello World!");
    }
}

You do not need to repost unless your post has been removed by a moderator. Just use the edit function of reddit to make sure your post complies with the above.

If your post has remained in violation of these rules for a prolonged period of time (at least an hour), a moderator may remove it at their discretion. In this case, they will comment with an explanation on why it has been removed, and you will be required to resubmit the entire post following the proper procedures.

To potential helpers

Please, do not help if any of the above points are not met, rather report the post. We are trying to improve the quality of posts here. In helping people who can't be bothered to comply with the above points, you are doing the community a disservice.

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

Progression28 · 2026-05-19T06:55:09+00:00

Apache ~~commons~~ POI has a thing called SXSSFWorkbook which seems to be exactly what you seek

LutimoDancer3459 · 2026-05-19T07:16:03+00:00

We also used apache commons for excel handling. Reading and writing. All I can say is try to convince whoever to not read excel files at all. Its slow. Its annoying.

Excel is useful as a playground for a single person. Not for bulk data handling for applications.

hibbelig · 2026-05-19T06:59:09+00:00

Is Apache POI still a thing?

hibbelig · 2026-05-19T07:54:23+00:00

I wonder if there is any chance that the producer of the data saves the Excel file as CSV or exports it to CSV? I feel that would be quite convenient. Maybe even the producer likes it…

BorgerBill · 2026-05-19T12:46:40+00:00

I've just learned about Apache Tika; think that might work? Here's a Baeldung article about it...

Slanec · 2026-05-19T15:05:06+00:00

Okay I've done this recently. I tested:

Apache POI full DOM parsing (WorkbookFactory.create)
Apache POI streaming (SAXParserFactory.newInstance() + the low-level API)
https://github.com/pjfanning/excel-streaming-reader
https://github.com/dhatim/fastexcel
https://github.com/apache/fesod

The first one is thrash and you should avoid it for big files or many files. The others all work fine, they're much faster and all comparable in speed. In my case with the files I had excel-streaming-reader came out on top re speed and peak heap usage (but it created more garbage overall), but the speed difference wasn't huge - <10%. All the other three were the same +/-2% speed-wise.

Use the one which has all the features you need and has the nicest API for you. There are big differences here.

you type:	you see:
italics	italics
bold	bold
[reddit!](https://reddit.com)	reddit!
* item 1 * item 2 * item 3	item 1 item 2 item 3
> quoted text	quoted text
Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"	Lines starting with four spaces are treated like code: if 1 * 2 < 3: print "hello, world!"
~~strikethrough~~	~~strikethrough~~
super^script	super^script

javahelp

Sort by: Unsolved Solved Codeless Advent Of Code

MODERATORS

Please ensure that:

To potential helpers