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

org.apache.poi.xssf.usermodel.XSSFWorkbook
High level representation of a SpreadsheetML workbook. This is the first object most users will construct whether they are reading or writing a workbook. It is also the top level object for creating new sheets/etc.

  
  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

        File.separator + "WithVariousData.xlsx"
    );
    assertTrue(xml.exists());
      
    OPCPackage pkg = OPCPackage.open(xml.toString());
    XSSFWorkbook wb = new XSSFWorkbook(pkg);
        List<POIXMLDocumentPart> rels = wb.getSheetAt(0).getRelations();
        CommentsTable ct = null;
        for(POIXMLDocumentPart p : rels) {
            if(p instanceof CommentsTable){
                ct = (CommentsTable)p;
                break;
            }
        }
        assertNotNull(ct);
    assertEquals(2, ct.getNumberOfComments());
    assertEquals(1, ct.getNumberOfAuthors());


    XSSFComment comment = ct.findCellComment("C5");
    
    assertEquals("Nick Burch", comment.getAuthor());
    assertEquals("Nick Burch:\nThis is a comment", comment.getString().getString());


        wb = XSSFTestDataSamples.writeOutAndReadBack(wb);
        rels = wb.getSheetAt(0).getRelations();
        ct = null;
        for(POIXMLDocumentPart p : rels) {
            if(p instanceof CommentsTable){
                ct = (CommentsTable)p;
                break;

View Full Code Here

        System.getProperty("HSSF.testdata.path") +
        File.separator + "WithVariousData.xlsx"
    );
    assertTrue(xml.exists());
      
    XSSFWorkbook workbook = new XSSFWorkbook(xml.toString());
    Sheet sheet1 = workbook.getSheetAt(0);
    Sheet sheet2 = workbook.getSheetAt(1);
    
    assertTrue( ((XSSFSheet)sheet1).hasComments() );
    assertFalse( ((XSSFSheet)sheet2).hasComments() );
    
    // Comments should be in C5 and C7

View Full Code Here

        System.getProperty("HSSF.testdata.path") +
        File.separator + "WithVariousData.xlsx"
    );
    assertTrue(xml.exists());
      
    XSSFWorkbook workbook = new XSSFWorkbook(xml.toString());
    Sheet sheet1 = workbook.getSheetAt(0);
    XSSFSheet sheet2 = (XSSFSheet)workbook.getSheetAt(1);
    
    assertTrue( ((XSSFSheet)sheet1).hasComments() );
    assertFalse( ((XSSFSheet)sheet2).hasComments() );
    
    // Change on comment on sheet 1, and add another into
    //  sheet 2
    Row r5 = sheet1.getRow(4);
    Comment cc5 = r5.getCell(2).getCellComment();
    cc5.setAuthor("Apache POI");
    cc5.setString(new XSSFRichTextString("Hello!"));
    
    Row r2s2 = sheet2.createRow(2);
    Cell c1r2s2 = r2s2.createCell(1);
    assertNull(c1r2s2.getCellComment());
    
    Comment cc2 = sheet2.createComment();
    cc2.setAuthor("Also POI");
    cc2.setString(new XSSFRichTextString("A new comment"));
    c1r2s2.setCellComment(cc2);
    
    
    // Save, and re-load the file
        workbook = XSSFTestDataSamples.writeOutAndReadBack(workbook);


    // Check we still have comments where we should do
    sheet1 = workbook.getSheetAt(0);
    sheet2 = (XSSFSheet)workbook.getSheetAt(1);
    assertNotNull(sheet1.getRow(4).getCell(2).getCellComment());
    assertNotNull(sheet1.getRow(6).getCell(2).getCellComment());
    assertNotNull(sheet2.getRow(2).getCell(1).getCellComment());
    
    // And check they still have the contents they should do

View Full Code Here

        System.getProperty("HSSF.testdata.path") +
        File.separator + "WithMoreVariousData.xlsx"
    );
    assertTrue(xml.exists());
      
    XSSFWorkbook workbook = new XSSFWorkbook(xml.toString());
    Sheet sheet1 = workbook.getSheetAt(0);
    XSSFSheet sheet2 = (XSSFSheet)workbook.getSheetAt(1);
    
    assertTrue( ((XSSFSheet)sheet1).hasComments() );
    assertFalse( ((XSSFSheet)sheet2).hasComments() );
    
    assertEquals("Nick Burch", 
        sheet1.getRow(4).getCell(2).getCellComment().getAuthor());
    assertEquals("Nick Burch", 
        sheet1.getRow(6).getCell(2).getCellComment().getAuthor());
    assertEquals("Torchbox", 
        sheet1.getRow(12).getCell(2).getCellComment().getAuthor());
    
    // Save, and re-load the file
        workbook = XSSFTestDataSamples.writeOutAndReadBack(workbook);


    // Check we still have comments where we should do
    sheet1 = workbook.getSheetAt(0);
    assertNotNull(sheet1.getRow(4).getCell(2).getCellComment());
    assertNotNull(sheet1.getRow(6).getCell(2).getCellComment());
    assertNotNull(sheet1.getRow(12).getCell(2).getCellComment());
    
    // And check they still have the contents they should do

View Full Code Here

     * @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

            public void extract(Metadata metadata) throws TikaException {
                super.extract(metadata);


                metadata.set(TikaMetadataKeys.PROTECTED, "false");


                XSSFWorkbook document = (XSSFWorkbook) extractor.getDocument();


                for (int i = 0; i < document.getNumberOfSheets(); i++) {
                    XSSFSheet sheet = document.getSheetAt(i);


                    if (sheet.getProtect()) {
                        metadata.set(TikaMetadataKeys.PROTECTED, "true");
                    }
                }

View Full Code Here

    public void testCellMerge() throws Exception {
        ExcelParser parser = new ExcelParser((Map<String, List<DataListener>>) null);


        CellRangeAddress[] ranges = new CellRangeAddress[1];


        Workbook workbook = new XSSFWorkbook();
        Sheet sheet = workbook.createSheet();
        Cell cell = sheet.createRow(2).createCell(2);
        ranges[0] = new CellRangeAddress(2, 7, 2, 5);
        cell.setCellValue(FIRST_CELL_CONTENT);


        cell = sheet.createRow(7).createCell(5);

View Full Code Here

         if (is.available() == 0)
         {
            return "";
         }


         XSSFWorkbook wb;
         try
         {
            wb = new XSSFWorkbook(is);
         }
         catch (IOException e)
         {
            throw new DocumentReadException("Can't open spreadsheet.", e);
         }
         catch (OpenXML4JRuntimeException e)
         {
            return builder.toString();
         }
         for (int sheetNum = 0; sheetNum < wb.getNumberOfSheets(); sheetNum++)
         {
            XSSFSheet sheet = wb.getSheetAt(sheetNum);
            if (sheet != null)
            {
               for (int rowNum = sheet.getFirstRowNum(); rowNum <= sheet.getLastRowNum(); rowNum++)
               {
                  XSSFRow row = sheet.getRow(rowNum);

View Full Code Here

    *      InputStream)
    */
   public Properties getProperties(InputStream is) throws IOException, DocumentReadException
   {
      POIPropertiesReader reader = new POIPropertiesReader();
      reader.readDCProperties(new XSSFWorkbook(is));
      return reader.getProperties();
   }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

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

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.