Package org.apache.poi.xssf.streaming

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

50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
    protected Workbook createWorkbook(final InputStream templateInputStream) throws IOException, InvalidFormatException {
        if (templateInputStream != null) {
            final Workbook template = WorkbookFactory.create(templateInputStream);
            if (template instanceof XSSFWorkbook) {
                workbook = compressTempFiles == Boolean.TRUE ?
                        new SXSSFWorkbook((XSSFWorkbook) template, -1, compressTempFiles) :
                        new SXSSFWorkbook((XSSFWorkbook) template, -1);
                return template;
            } else {
                throw SupportMessages.MESSAGES.incompatibleExcelFileFormat(templateResource);
            }
        } else if (resource.endsWith("xlsx")) {
            final SXSSFWorkbook workbook1 = new SXSSFWorkbook(-1);
            if (compressTempFiles == Boolean.TRUE) {
                workbook1.setCompressTempFiles(true);
            }
            workbook = workbook1;
        } else {
            throw SupportMessages.MESSAGES.incompatibleExcelFileFormat(resource);
        }
View Full Code Here
62
63
64
65
66
67
68
69
70
71
72
73
74
    }
   
    public void testExistingWorkbook() {
      XSSFWorkbook xssfWorkbook = new XSSFWorkbook();
      xssfWorkbook.createSheet("S1");
      SXSSFWorkbook wb = new SXSSFWorkbook(xssfWorkbook);
      xssfWorkbook = (XSSFWorkbook) SXSSFITestDataProvider.instance.writeOutAndReadBack(wb);
      wb = new SXSSFWorkbook(xssfWorkbook);
      assertEquals(1, wb.getNumberOfSheets());
      Sheet sheet  = wb.getSheetAt(0);
      assertNotNull(sheet);
      assertEquals("S1", sheet.getSheetName());
    }
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
      xssfWorkbook.createSheet("S1");
      Sheet sheet = xssfWorkbook.createSheet("S2");
      Row row = sheet.createRow(1);
      Cell cell = row.createCell(1);
      cell.setCellValue("value 2_1_1");
      SXSSFWorkbook wb = new SXSSFWorkbook(xssfWorkbook);
      xssfWorkbook = (XSSFWorkbook) SXSSFITestDataProvider.instance.writeOutAndReadBack(wb);
      wb = new SXSSFWorkbook(xssfWorkbook);
     
      // Add a row to the existing empty sheet
      Sheet sheet1 = wb.getSheetAt(0);
      Row row1_1 = sheet1.createRow(1);
      Cell cell1_1_1 = row1_1.createCell(1);
      cell1_1_1.setCellValue("value 1_1_1");
     
      // Add a row to the existing non-empty sheet
      Sheet sheet2 = wb.getSheetAt(1);
      Row row2_2 = sheet2.createRow(2);
      Cell cell2_2_1 = row2_2.createCell(1);
      cell2_2_1.setCellValue("value 2_2_1");
     
      // Add a sheet with one row
      Sheet sheet3 = wb.createSheet("S3");
      Row row3_1 = sheet3.createRow(1);
      Cell cell3_1_1 = row3_1.createCell(1);
      cell3_1_1.setCellValue("value 3_1_1");
     
      xssfWorkbook = (XSSFWorkbook) SXSSFITestDataProvider.instance.writeOutAndReadBack(wb);
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
    protected Workbook createWorkbook(final InputStream templateInputStream) throws IOException, InvalidFormatException {
        if (templateInputStream != null) {
            final Workbook template = WorkbookFactory.create(templateInputStream);
            if (template instanceof XSSFWorkbook) {
                workbook = compressTempFiles == Boolean.TRUE ?
                        new SXSSFWorkbook((XSSFWorkbook) template, -1, compressTempFiles) :
                        new SXSSFWorkbook((XSSFWorkbook) template, -1);
                return template;
            } else {
                throw SupportMessages.MESSAGES.incompatibleExcelFileFormat(templateResource);
            }
        } else if (resource.endsWith("xlsx")) {
            final SXSSFWorkbook workbook1 = new SXSSFWorkbook(-1);
            if (compressTempFiles == Boolean.TRUE) {
                workbook1.setCompressTempFiles(true);
            }
            workbook = workbook1;
        } else {
            throw SupportMessages.MESSAGES.incompatibleExcelFileFormat(resource);
        }
View Full Code Here
187
188
189
190
191
192
193
194
195
196
197
   * 初始化函数
   * @param title 表格标题，传“空值”，表示无标题
   * @param headerList 表头列表
   */
  private void initialize(String title, List<String> headerList) {
    this.wb = new SXSSFWorkbook(500);
    this.sheet = wb.createSheet("Export");
    this.styles = createStyles(wb);
    // Create title
    if (StringUtils.isNotBlank(title)){
      Row titleRow = sheet.createRow(rownum++);
View Full Code Here
35
36
37
38
39
40
41
    /**
     * Returns a new SXSSFWorkbook workbook
     */
    @Override
    protected Workbook getNewWorkbook() {
        return new SXSSFWorkbook(1);
    }
View Full Code Here
1130
1131
1132
1133
1134
1135
1136
1137
1138
1139
1140
1141
1142
        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
1154
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
        assertEquals("Did not match for sheet " + si, topRows[si], sh.getLeftCol());
      }

      // 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.getLeftCol());
        }
      }
  }
View Full Code Here
1183
1184
1185
1186
1187
1188
1189
1190
1191
1192
1193
1194
        XSSFWorkbook wb = XSSFTestDataSamples.writeOutAndReadBack(workbook);
        checkRowCount(wb);
  }

    public void testShowInPaneManyRowsBug55248SXSSF() {
        SXSSFWorkbook workbook = new SXSSFWorkbook(new XSSFWorkbook());
        SXSSFSheet sheet = (SXSSFSheet) workbook.createSheet("Sheet 1");
       
        sheet.showInPane(0, 0);
       
        for(int i = ROW_COUNT/2;i < ROW_COUNT;i++) {
            sheet.createRow(i);
View Full Code Here
TOP

Related Classes of org.apache.poi.xssf.streaming.SXSSFWorkbook

  • com.sishuok.es.showcase.excel.service.ExcelDataService
  • com.thinkgem.jeesite.common.utils.excel.ExportExcel
  • org.apache.jena.examples.ExampleARQ_06
  • org.apache.metamodel.excel.ExcelUpdateCallback
  • org.apache.metamodel.excel.ExcelUtils
  • org.apache.poi.ss.examples.SSPerformanceTest
  • org.apache.poi.xssf.streaming.examples.Outlining
  • org.apache.poi.xssf.SXSSFITestDataProvider
  • org.apache.poi.xssf.usermodel.streaming.TestSXSSFWorkbook
  • org.apache.poi.xssf.usermodel.TestUnfixedBugs
    • Copyright © 2018 www.massapicom. 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.