Package org.apache.poi.xssf.usermodel

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

124
125
126
127
128
129
130
131
132
133
    static Workbook createEmptyWorkbookFor(String path) {
        if (isHssf(path)) {
            return new HSSFWorkbook();
        } else if (isXssf(path)) {
            return new XSSFWorkbook();
        } else {
            return new HSSFWorkbook();
        }
    }
View Full Code Here
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
     * @see org.apache.poi.xssf.extractor.XSSFExcelExtractor#getText()
     */
    @Override
    protected void buildXHTML(XHTMLContentHandler xhtml) throws SAXException,
            XmlException, IOException {
        XSSFWorkbook document = (XSSFWorkbook) extractor.getDocument();

        for (int i = 0; i < document.getNumberOfSheets(); i++) {
            xhtml.startElement("div");
            XSSFSheet sheet = (XSSFSheet) document.getSheetAt(i);
            xhtml.element("h1", document.getSheetName(i));

            // Header(s), if present
            extractHeaderFooter(sheet.getFirstHeader(), xhtml);
            extractHeaderFooter(sheet.getOddHeader(), xhtml);
            extractHeaderFooter(sheet.getEvenHeader(), xhtml);
View Full Code Here
45
46
47
48
49
50
51
52
  public void testExcel() throws Exception {
    File f = new File(dirname, "ExcelWithAttachments.xlsx");
    assertTrue(f.exists());
   
    POIXMLDocument doc = new XSSFWorkbook(OPCPackage.open(f.toString()));
    test(doc, 4);
  }
View Full Code Here
34
35
36
37
38
39
40
41
42
43
44
 
  public void testGetFromMainExtractor() throws Exception {
    OPCPackage pkg = OPCPackage.open(
        (new File(dirname, "ExcelWithAttachments.xlsx")).toString()
    );
    XSSFWorkbook wb = new XSSFWorkbook(pkg);

    XSSFExcelExtractor ext = new XSSFExcelExtractor(wb);
    POIXMLPropertiesTextExtractor textExt = ext.getMetadataTextExtractor();
   
    // Check basics
View Full Code Here
55
56
57
58
59
60
61
62
63
64
65
  public void testCore() throws Exception {
    OPCPackage pkg = OPCPackage.open(
        (new File(dirname, "ExcelWithAttachments.xlsx")).toString()
    );
    XSSFWorkbook wb = new XSSFWorkbook(pkg);
   
    POIXMLPropertiesTextExtractor ext = new POIXMLPropertiesTextExtractor(wb);
    ext.getText();
   
    // Now check
View Full Code Here
72
73
74
75
76
77
78
79
80
81
82
 
  public void testExtended() throws Exception {
    OPCPackage pkg = OPCPackage.open(
        (new File(dirname, "ExcelWithAttachments.xlsx")).toString()
    );
    XSSFWorkbook wb = new XSSFWorkbook(pkg);
   
    POIXMLPropertiesTextExtractor ext = new POIXMLPropertiesTextExtractor(wb);
    ext.getText();
   
    // Now check
View Full Code Here
39
40
41
42
43
44
45
46
47
48
49
public class XSSFTestDataSamples {
  public static final XSSFWorkbook openSampleWorkbook(String sampleName) {
    InputStream is = HSSFTestDataSamples.openSampleFileStream(sampleName);
    try {
      OPCPackage pkg = OPCPackage.open(is);
      return new XSSFWorkbook(pkg);
    } catch (InvalidFormatException e) {
      throw new RuntimeException(e);
    } catch (IOException e) {
      throw new RuntimeException(e);
    }
View Full Code Here
61
62
63
64
65
66
67
68
69
70
71
                tmp.deleteOnExit();
                FileOutputStream out = new FileOutputStream(tmp);
                wb.write(out);
                out.close();
                OPCPackage pkg = OPCPackage.open(tmp.getAbsolutePath());
          result = new XSSFWorkbook(pkg);
        } else {
          throw new RuntimeException("Unexpected workbook type ("
              + wb.getClass().getName() + ")");
        }
    } catch (InvalidFormatException e) {
View Full Code Here
39
40
41
42
43
44
45
        return XSSFTestDataSamples.writeOutAndReadBack((XSSFWorkbook)original);
    }

    public XSSFWorkbook createWorkbook(){
        return new XSSFWorkbook();
    }
View Full Code Here
41
42
43
44
45
46
47
  private boolean formulasNotResults = false;
  private boolean includeCellComments = false;
  private boolean includeHeadersFooters = true;
 
  public XSSFExcelExtractor(String path) throws XmlException, OpenXML4JException, IOException {
    this(new XSSFWorkbook(path));
  }
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.