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 <andr...@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-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
