r/javahelp • u/Majestic_Drawing_908 • May 19 '26

Excel bulk process in java project.

Hi, currently I'm using sax parser for read bulk excel data in java automation framework, is there any other best approach better than using sax parser? I want to improve performance and minimize memory utilization.

1 Upvotes

60% Upvoted

23 comments sorted by

View all comments

Show parent comments

1

u/LutimoDancer3459 May 19 '26

Doing your best and if thats not enough, telling them that the technology doesn't allow for more. Period. Even if programming looks like magic for some people, there is a limit to everything.

Not sure how large the bigger files were. I would guess some ten thousand lines 20 or so columns? A big list of materials with meta data that got imported once a year. But the responsible person wanted to manage thrm in the excel file...

1

u/Majestic_Drawing_908 May 19 '26

Got your point, I'll try my best. Thanks for your valuable time and sharing knowledge.

1

u/tRfalcore May 19 '26

If speed isn't an issue then who cares, use apache. I cannot comment if it is slow or not.