poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mahmood Naderan <nt_mahm...@yahoo.com.INVALID>
Subject Re: POI memory usage for 4MB exce file is high
Date Wed, 03 May 2017 16:32:27 GMT
Thanks. I am new to that and have not used Maven yet. I have downloaded the jar file 

and put that in the project folder. It is said to add 


to the pom.xml. I see one pom.xml in the project folder which looks like

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">

where should I add those lines? in the properties tag?

On Wednesday, May 3, 2017 8:34 PM, Andreas Reichel <andreas@manticore-projects.com>


that was discussed many times already: XSSFWorkbook is a memory hog as it holds the whole
information in a DOM tree with a lot of strings. (Does Java 8 String Deduplication help on
that, when you have enough cores?)
For cases like yours reading from a SXSSFWorkbook/stream will be more suitable. You also might
have a look at: https://github.com/monitorjbl/excel-streaming-reader eventually.

Best regards

To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

View raw message