aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorPJ Fanning <fanningpj@apache.org>2021-03-06 01:48:57 +0000
committerPJ Fanning <fanningpj@apache.org>2021-03-06 01:48:57 +0000
commit90e58b6a043d4dfb17816fb932c29222a1a97acc (patch)
tree6ec9d6a7eec4c53f76f8a762ee34c53f270628f9
parent86dec87499faaa91f64f17ad7c023f92244eaf24 (diff)
downloadpoi-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.java49
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();
+ }
+ }
+ }
+}