troubleshooting Question

Apache POI

Avatar of allelopath
allelopath asked on
Java
16 Comments3 Solutions1702 ViewsLast Modified:
I have a memory issue using Apache POI. When creating a workbook (org.apache.poi.ss.usermodel.Workbook) like so:
Workbook workbook = WorkbookFactory.create( inputStream );

Open in new window


It takes much memory. For example, executing that line on an excel file that is 73mb causes memory usage to jump by about 1gb (according to the Windows Task Manager - PF Usage)

Two question
1. Why so much memory?
2. Is there a way to read an create/read row-by-row or column-by-column?

ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 3 Answers and 16 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 16 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros