diff options
author | PJ Fanning <fanningpj@apache.org> | 2021-03-06 01:48:57 +0000 |
---|---|---|
committer | PJ Fanning <fanningpj@apache.org> | 2021-03-06 01:48:57 +0000 |
commit | 90e58b6a043d4dfb17816fb932c29222a1a97acc (patch) | |
tree | 6ec9d6a7eec4c53f76f8a762ee34c53f270628f9 | |
parent | 86dec87499faaa91f64f17ad7c023f92244eaf24 (diff) | |
download | poi-90e58b6a043d4dfb17816fb932c29222a1a97acc.tar.gz poi-90e58b6a043d4dfb17816fb932c29222a1a97acc.zip |
add DeferredGeneration sample
git-svn-id: https://svn.apache.org/repos/asf/poi/trunk@1887238 13f79535-47bb-0310-9956-ffa450edef68
-rw-r--r-- | src/examples/src/org/apache/poi/examples/xssf/streaming/DeferredGeneration.java | 49 |
1 files changed, 49 insertions, 0 deletions
diff --git a/src/examples/src/org/apache/poi/examples/xssf/streaming/DeferredGeneration.java b/src/examples/src/org/apache/poi/examples/xssf/streaming/DeferredGeneration.java new file mode 100644 index 0000000000..1d07d32d65 --- /dev/null +++ b/src/examples/src/org/apache/poi/examples/xssf/streaming/DeferredGeneration.java @@ -0,0 +1,49 @@ +/* ==================================================================== + Licensed to the Apache Software Foundation (ASF) under one or more + contributor license agreements. See the NOTICE file distributed with + this work for additional information regarding copyright ownership. + The ASF licenses this file to You under the Apache License, Version 2.0 + (the "License"); you may not use this file except in compliance with + the License. You may obtain a copy of the License at + + http://www.apache.org/licenses/LICENSE-2.0 + + Unless required by applicable law or agreed to in writing, software + distributed under the License is distributed on an "AS IS" BASIS, + WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. + See the License for the specific language governing permissions and + limitations under the License. +==================================================================== */ + +package org.apache.poi.examples.xssf.streaming; + +import org.apache.poi.ss.usermodel.Cell; +import org.apache.poi.ss.usermodel.Row; +import org.apache.poi.xssf.streaming.DeferredSXSSFSheet; +import org.apache.poi.xssf.streaming.DeferredSXSSFWorkbook; + +import java.io.FileOutputStream; +import java.io.IOException; + +public class DeferredGeneration { + + public static void main(String[] args) throws IOException { + try (DeferredSXSSFWorkbook wb = new DeferredSXSSFWorkbook()) { + DeferredSXSSFSheet sheet1 = wb.createSheet("new sheet"); + + sheet1.setRowGenerator((ssxSheet) -> { + for (int i = 0; i < 10; i++) { + Row row = ssxSheet.createRow(i); + Cell cell = row.createCell(1); + cell.setCellValue("value " + i); + } + }); + + try (FileOutputStream fileOut = new FileOutputStream("DeferredGeneration.xlsx")) { + wb.write(fileOut); + } finally { + wb.dispose(); + } + } + } +} |