Package org.apache.poi.xssf.usermodel

Examples of org.apache.poi.xssf.usermodel.XSSFWorkbook

17
18
19
20
21
22
23
24
    private Sheet sheet;
    private XSSFWorkbook wb;

    @BeforeMethod
    public void setup() {
        this.wb =  new XSSFWorkbook();
        this.sheet = this.wb.createSheet();
    }
View Full Code Here
77
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
106
        assertEquals("???<>\t\n\u00a0 &\"POI\'\u2122", wb.getSheetAt(0).getRow(0).getCell(0).getStringCellValue());

    }

    public void testEncodingbeloAscii(){
        Workbook xwb = new XSSFWorkbook();
        Cell xCell = xwb.createSheet().createRow(0).createCell(0);

        Workbook swb = new SXSSFWorkbook();
        Cell sCell = swb.createSheet().createRow(0).createCell(0);

        StringBuffer sb = new StringBuffer();
        // test all possible characters
        for(int i = 0; i < Character.MAX_VALUE; i++) sb.append((char)i) ;

        String str = sb.toString();

        xCell.setCellValue(str);
        assertEquals(str, xCell.getStringCellValue());
        sCell.setCellValue(str);
        assertEquals(str, sCell.getStringCellValue());

        xwb = XSSFITestDataProvider.instance.writeOutAndReadBack(xwb);
        swb = SXSSFITestDataProvider.instance.writeOutAndReadBack(swb);
        xCell = xwb.getSheetAt(0).createRow(0).createCell(0);
        sCell = swb.getSheetAt(0).createRow(0).createCell(0);

        assertEquals(xCell.getStringCellValue(), sCell.getStringCellValue());

    }
View Full Code Here
1974
1975
1976
1977
1978
1979
1980
1981
1982
1983
1984
    if (book == null) {
      return null;
    }
    Workbook newBook = null;
    if (isXSSF) {
      newBook = new XSSFWorkbook();
    } else {
      newBook = new HSSFWorkbook();
    }
    // for(short i=0;i<book.getNumCellStyles();i++){
    // CellStyle cells = book.getCellStyleAt(i);
View Full Code Here
59
60
61
62
63
64
65
    /**
     * @deprecated  Use {@link #XSSFExcelExtractor(org.apache.poi.openxml4j.opc.OPCPackage)} instead.
     */
    public XSSFExcelExtractor(String path) throws XmlException, OpenXML4JException, IOException {
        this(new XSSFWorkbook(path));
    }
View Full Code Here
62
63
64
65
66
67
68
     */
    public XSSFExcelExtractor(String path) throws XmlException, OpenXML4JException, IOException {
        this(new XSSFWorkbook(path));
    }
    public XSSFExcelExtractor(OPCPackage container) throws XmlException, OpenXML4JException, IOException {
        this(new XSSFWorkbook(container));
    }
View Full Code Here
53
54
55
56
57
58
59
   
    /**
     * Creates a XSSFWorkbook from the given OOXML Package
     */
    public static Workbook create(OPCPackage pkg) throws IOException {
        return new XSSFWorkbook(pkg);
    }
View Full Code Here
74
75
76
77
78
79
80
81
82
        if (POIFSFileSystem.hasPOIFSHeader(inp)) {
            return new HSSFWorkbook(inp);
        }
        if (POIXMLDocument.hasOOXMLHeader(inp)) {
            return new XSSFWorkbook(OPCPackage.open(inp));
        }
        throw new IllegalArgumentException("Your InputStream was neither an OLE2 stream, nor an OOXML stream");
    }
View Full Code Here
93
94
95
96
97
98
99
100
        try {
            NPOIFSFileSystem fs = new NPOIFSFileSystem(file);
            return new HSSFWorkbook(fs.getRoot(), true);
        } catch(OfficeXmlFileException e) {
            OPCPackage pkg = OPCPackage.open(file);
            return new XSSFWorkbook(pkg);
        }
    }
View Full Code Here
73
74
75
76
77
78
79
80
81
82
83
84
                    "Only XSSFCells can be evaluated.", e.getMessage());
        }
    }

    public void testExistingWorkbook() {
      XSSFWorkbook xssfWorkbook = new XSSFWorkbook();
      xssfWorkbook.createSheet("S1");
      SXSSFWorkbook wb = new SXSSFWorkbook(xssfWorkbook);
      xssfWorkbook = (XSSFWorkbook) SXSSFITestDataProvider.instance.writeOutAndReadBack(wb);
      wb.dispose();

        wb = new SXSSFWorkbook(xssfWorkbook);
View Full Code Here
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
        wb.dispose();

    }

    public void testAddToExistingWorkbook() {
      XSSFWorkbook xssfWorkbook = new XSSFWorkbook();
      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.dispose();

        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);
      assertEquals(3, xssfWorkbook.getNumberOfSheets());
      // Verify sheet 1
      sheet1 = xssfWorkbook.getSheetAt(0);
      assertEquals("S1", sheet1.getSheetName());
      assertEquals(1, sheet1.getPhysicalNumberOfRows());
      row1_1 = sheet1.getRow(1);
      assertNotNull(row1_1);
      cell1_1_1 = row1_1.getCell(1);
      assertNotNull(cell1_1_1);
      assertEquals("value 1_1_1", cell1_1_1.getStringCellValue());
      // Verify sheet 2
      sheet2 = xssfWorkbook.getSheetAt(1);
      assertEquals("S2", sheet2.getSheetName());
      assertEquals(2, sheet2.getPhysicalNumberOfRows());
      Row row2_1 = sheet2.getRow(1);
      assertNotNull(row2_1);
      Cell cell2_1_1 = row2_1.getCell(1);
      assertNotNull(cell2_1_1);
      assertEquals("value 2_1_1", cell2_1_1.getStringCellValue());
      row2_2 = sheet2.getRow(2);
      assertNotNull(row2_2);
      cell2_2_1 = row2_2.getCell(1);
      assertNotNull(cell2_2_1);
      assertEquals("value 2_2_1", cell2_2_1.getStringCellValue());
      // Verify sheet 3
      sheet3 = xssfWorkbook.getSheetAt(2);
      assertEquals("S3", sheet3.getSheetName());
      assertEquals(1, sheet3.getPhysicalNumberOfRows());
      row3_1 = sheet3.getRow(1);
      assertNotNull(row3_1);
      cell3_1_1 = row3_1.getCell(1);
View Full Code Here
TOP

Related Classes of org.apache.poi.xssf.usermodel.XSSFWorkbook

  • cn.baiweigang.qtaf.ift.util.ExportReportExcel
  • cn.baiweigang.qtaf.toolkit.util.ExcelUtil
  • com.asakusafw.testdriver.excel.Util
  • com.ebay.xcelite.Xcelite
  • com.google.refine.importers.ExcelImporter
  • com.hmkcode.poi.AppWrite
  • com.thinkgem.jeesite.common.utils.excel.ImportExcel
  • org.apache.poi.openxml4j.opc.OPCPackage
  • org.apache.poi.openxml4j.opc.PackagePart
  • org.apache.poi.openxml4j.opc.PackagePartName
    • 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.