Examples of SXSSFWorkbook

Examples of org.apache.poi.xssf.streaming.SXSSFWorkbook

60
61
62
63
64
65
66
            throw new RuntimeException(e);
        }
        return result;
    }
    public SXSSFWorkbook createWorkbook(){
        return new SXSSFWorkbook();
    }
View Full Code Here

Examples of org.apache.poi.xssf.streaming.SXSSFWorkbook

130
131
132
133
134
135
136
137
138
139
140
     */
    public static Workbook readWorkbook(ExcelDataContext dataContext) {
        Resource resource = dataContext.getResource();
        if (!resource.isExists()) {
            if (isXlsxFile(resource)) {
                return new SXSSFWorkbook(1000);
            } else {
                return new HSSFWorkbook();
            }
        }
        return readWorkbook(resource);
View Full Code Here

Examples of org.apache.poi.xssf.streaming.SXSSFWorkbook

158
159
160
161
162
163
164
165
166
167
168
    Workbook retval = null;
   
    //
    if ( this.useXLSXFileFormat() )
    {
      retval = new SXSSFWorkbook();
    }
    else
    {
      retval = new HSSFWorkbook();
    }
View Full Code Here

Examples of org.apache.poi.xssf.streaming.SXSSFWorkbook

95
96
97
98
99
100
101
102
103
104
            if (_workbook != null) {
                ExcelUtils.writeWorkbook(_dataContext, _workbook);
            }
            _workbook = ExcelUtils.readWorkbook(_dataContext);
            if (streamingAllowed && _workbook instanceof XSSFWorkbook) {
                _workbook = new SXSSFWorkbook((XSSFWorkbook) _workbook);
            }
        }
        return _workbook;
    }
View Full Code Here

Examples of org.apache.poi.xssf.streaming.SXSSFWorkbook

1580
1581
1582
1583
1584
1585
1586
    @Ignore("Shifting rows is not yet implemented in SXSSFSheet")
    @Test
    public void testBug53798XLSXStream() throws IOException {
        XSSFWorkbook wb = XSSFTestDataSamples.openSampleWorkbook("53798_shiftNegative_TMPL.xlsx");
        File xlsOutput = TempFile.createTempFile("testBug53798", ".xlsx");
        bug53798Work(new SXSSFWorkbook(wb), xlsOutput);
    }
View Full Code Here

Examples of org.apache.poi.xssf.streaming.SXSSFWorkbook

1743
1744
1745
1746
1747
1748
1749
1750
1751
1752
1753
                if(wb instanceof XSSFWorkbook) {
                    newWB = new XSSFWorkbook(is);
                } else if(wb instanceof HSSFWorkbook) {
                    newWB = new HSSFWorkbook(is);
                } else if(wb instanceof SXSSFWorkbook) {
                    newWB = new SXSSFWorkbook(new XSSFWorkbook(is));
                } else {
                    throw new IllegalStateException("Unknown workbook: " + wb);
                }
                assertNotNull(newWB.getSheet("test"));
            } finally {
View Full Code Here

Examples of org.apache.poi.xssf.streaming.SXSSFWorkbook

64
65
66
67
68
69
70
71
        // now write the file and read it back in
        XSSFWorkbook wbWritten = XSSFTestDataSamples.writeOutAndReadBack(wb);
        verifyBug54084Unicode(wbWritten);

        // finally also write it out via the streaming interface and verify that we still can read it back in
        Workbook wbStreamingWritten = SXSSFITestDataProvider.instance.writeOutAndReadBack(new SXSSFWorkbook(wb));
        verifyBug54084Unicode(wbStreamingWritten);
    }
View Full Code Here

Examples of org.apache.poi.xssf.streaming.SXSSFWorkbook

113
114
115
116
117
118
119
  // Disabled because shift rows is not yet implemented for SXSSFWorkbook
  public void disabled_testBug53798XLSXStream() throws IOException {
      XSSFWorkbook wb = XSSFTestDataSamples.openSampleWorkbook("53798_shiftNegative_TMPL.xlsx");
        File xlsOutput = TempFile.createTempFile("testBug53798", ".xlsx");
        bug53798Work(new SXSSFWorkbook(wb), xlsOutput);
  }
View Full Code Here

Examples of org.apache.poi.xssf.streaming.SXSSFWorkbook

192
193
194
195
196
197
198
199
200
201
202
      if(wb instanceof XSSFWorkbook) {
        newWB = new XSSFWorkbook(is);
      } else if(wb instanceof HSSFWorkbook) {
        newWB = new HSSFWorkbook(is);
      } else if(wb instanceof SXSSFWorkbook) {
        newWB = new SXSSFWorkbook(new XSSFWorkbook(is));
      } else {
        throw new IllegalStateException("Unknown workbook: " + wb);
      }
      assertNotNull(newWB.getSheet("test"));
    } finally {
View Full Code Here

Examples of org.apache.poi.xssf.streaming.SXSSFWorkbook

1178
1179
1180
1181
1182
1183
1184
1185
1186
1187
1188
1189
1190
            assertEquals("Did not match for sheet " + si, topRows[si], sh.getTopRow());
        }

        // for XSSF also test with SXSSF
        if(isXSSF) {
            Workbook swb = new SXSSFWorkbook((XSSFWorkbook) wb);
            for (int si = 0; si < swb.getNumberOfSheets(); si++) {
                Sheet sh = swb.getSheetAt(si);
                assertNotNull(sh.getSheetName());
                assertEquals("Did not match for sheet " + si, topRows[si], sh.getTopRow());
            }
        }
    }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.