Examples of XSSFSheet

org.apache.poi.xssf.usermodel.XSSFSheet
High level representation of a SpreadsheetML worksheet.
Sheets are the central structures within a workbook, and are where a user does most of his spreadsheet work. The most common type of sheet is the worksheet, which is represented as a grid of cells. Worksheet cells can contain text, numbers, dates, and formulas. Cells can also be formatted.
org.zkoss.poi.xssf.usermodel.XSSFSheet

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

                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

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

         {
            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);


                  if (row != null)
                  {
                     int lastcell = row.getLastCellNum();
                     for (int k = 0; k < lastcell; k++)

View Full Code Here

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

        LinkedHashMap<String,LinkedHashMap> fields = null;
        
        try {
            
            XSSFWorkbook workbook = new XSSFWorkbook(inputFile);
            XSSFSheet sheet = workbook.getSheetAt( 0 );
            XSSFRow row = sheet.getRow(0);
            
            Iterator<Cell> cellIt = row.cellIterator();
            
            fields = new LinkedHashMap();

View Full Code Here

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

    assertEquals(2, cc7.getColumn());
  }


  public void testWriteRead() {
    XSSFWorkbook workbook = XSSFTestDataSamples.openSampleWorkbook("WithVariousData.xlsx");
    XSSFSheet sheet1 = workbook.getSheetAt(0);
    XSSFSheet sheet2 = workbook.getSheetAt(1);


    assertTrue( sheet1.hasComments() );
    assertFalse( 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 = 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
    assertEquals("Apache POI",
        sheet1.getRow(4).getCell(2).getCellComment().getAuthor());
    assertEquals("Nick Burch",
        sheet1.getRow(6).getCell(2).getCellComment().getAuthor());
    assertEquals("Also POI",
        sheet2.getRow(2).getCell(1).getCellComment().getAuthor());


    assertEquals("Hello!",
        sheet1.getRow(4).getCell(2).getCellComment().getString().getString());
  }

View Full Code Here

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

        sheet1.getRow(4).getCell(2).getCellComment().getString().getString());
  }


  public void testReadWriteMultipleAuthors() {
    XSSFWorkbook workbook = XSSFTestDataSamples.openSampleWorkbook("WithMoreVariousData.xlsx");
    XSSFSheet sheet1 = workbook.getSheetAt(0);
    XSSFSheet sheet2 = workbook.getSheetAt(1);


    assertTrue( sheet1.hasComments() );
    assertFalse( sheet2.hasComments() );


    assertEquals("Nick Burch",
        sheet1.getRow(4).getCell(2).getCellComment().getAuthor());
    assertEquals("Nick Burch",
        sheet1.getRow(6).getCell(2).getCellComment().getAuthor());

View Full Code Here

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

         {
            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);


                  if (row != null)
                  {
                     int lastcell = row.getLastCellNum();
                     for (int k = 0; k < lastcell; k++)

View Full Code Here

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

    }
    
    Sheet s = in.getSheet();
    
    if (s instanceof XSSFSheet) {
      XSSFSheet xssfSheet = (XSSFSheet) s;
      
      for (int i = 0; i < xssfSheet.getNumMergedRegions(); i++) {
        CellRangeAddress cra = xssfSheet.getMergedRegion(i);
        if (isPartOf(cra, in)) {
          return cra;
        }
      }
    }

View Full Code Here

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

      && (cra.getFirstRow() <= inRow)
      && (cra.getLastRow() >= inRow);
  }
  
  public static XSSFTable getTableForCell(Cell c) {
    XSSFSheet sheet = (XSSFSheet) c.getSheet();
    for (XSSFTable t : sheet.getTables()) {
      if (tableContainsCell(t, c)) {
        return t;
      }
    }

View Full Code Here

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

    boolean header = shouldOutputFirstRowAsHeader(table);
    int columnFrom = table.getStartCellReference().getCol();
    int columnTo = table.getEndCellReference().getCol();
    int rowFrom = table.getStartCellReference().getRow();
    int rowTo = table.getEndCellReference().getRow();
    XSSFSheet sheet = table.getXSSFSheet();
        
    result.startTag("table");
    for (int rowNum = rowFrom; rowNum <= rowTo; rowNum++) {
      Row r = sheet.getRow(rowNum);
      result.startTag("tr");
      for (int i = columnFrom; i <= columnTo; i++) {
        if (header) {
          headerCell.process(r.getCell(i), result);
        } else {

View Full Code Here

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

            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);


            xhtml.startElement("table");
            xhtml.startElement("tbody");


            // Rows and cells
            for (Object rawR : sheet) {
                xhtml.startElement("tr");
                Row row = (Row) rawR;
                for (Iterator<Cell> ri = row.cellIterator(); ri.hasNext();) {
                    xhtml.startElement("td");
                    Cell cell = ri.next();


                    if (cell.getCellType() == Cell.CELL_TYPE_FORMULA
                            || cell.getCellType() == Cell.CELL_TYPE_STRING) {
                        xhtml.characters(cell.getRichStringCellValue()
                                .getString());
                    } else {
                        XSSFCell xc = (XSSFCell) cell;
                        String rawValue = xc.getRawValue();
                        if (rawValue != null) {
                            xhtml.characters(rawValue);
                        }


                    }


                    // Output the comment in the same cell as the content
                    Comment comment = cell.getCellComment();
                    if (comment != null) {
                        xhtml.characters(comment.getString().getString());
                    }


                    xhtml.endElement("td");
                }
                xhtml.endElement("tr");
            }


            xhtml.endElement("tbody");
            xhtml.endElement("table");


            // Finally footer(s), if present
            extractHeaderFooter(sheet.getFirstFooter(), xhtml);
            extractHeaderFooter(sheet.getOddFooter(), xhtml);
            extractHeaderFooter(sheet.getEvenFooter(), xhtml);


            xhtml.endElement("div");
        }
    }

View Full Code Here

0 1 2 3 4 5

TOP

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.