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 
https://github.com/monitorjbl/excel-streaming-reader/releases/download/1.1.0/xlsx-streamer-1.1.0.jar

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


<dependencies>
<dependency>
<groupId>com.monitorjbl</groupId>
<artifactId>xlsx-streamer</artifactId>
<version>1.0.1</version>
</dependency>
</dependencies> 

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">
<modelVersion>4.0.0</modelVersion>
<groupId>com.scu</groupId>
<artifactId>testmaven</artifactId>
<version>1.0-SNAPSHOT</version>
<packaging>jar</packaging>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<maven.compiler.source>1.8</maven.compiler.source>
<maven.compiler.target>1.8</maven.compiler.target>
</properties>
</project>


where should I add those lines? in the properties tag?
Regards,
Mahmood





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



Mahmood,

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
Andreas

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


Mime
View raw message