Examples of XSSFCell

org.apache.poi.xssf.usermodel.XSSFCell
High level representation of a cell in a row of a spreadsheet.
Cells can be numeric, formula-based or string-based (text). The cell type specifies this. String cells cannot conatin numbers and numeric cells cannot contain strings (at least according to our model). Client apps should do the conversions themselves. Formula cells have the formula string, as well as the formula result, which can be numeric or string.

Cells should have their number (0 based) before being added to a row. Only cells that have values should be added.
org.zkoss.poi.xssf.usermodel.XSSFCell

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


            if (!xpath.matches(".*\\[.*")) {


                // Exports elements and attributes mapped with simpleXmlCell
                if (simpleXmlCell!=null) {
                    XSSFCell cell = simpleXmlCell.getReferencedCell();
                    if (cell!=null) {
                        Node currentNode = getNodeByXPath(xpath,doc.getFirstChild(),doc,false);
                        STXmlDataType.Enum dataType = simpleXmlCell.getXmlDataType();
                        mapCellOnNode(cell,currentNode,dataType);
                    }
                }


                // Exports elements and attributes mapped with tables
                if (table!=null) {


                    List<XSSFXmlColumnPr> tableColumns = table.getXmlColumnPrs();


                    XSSFSheet sheet = table.getXSSFSheet();


                    int startRow = table.getStartCellReference().getRow();
                    // In mappings created with Microsoft Excel the first row contains the table header and must be skipped
                    startRow +=1;


                    int endRow = table.getEndCellReference().getRow();


                    for(int i = startRow; i<= endRow; i++) {
                        XSSFRow row = sheet.getRow(i);


                        Node tableRootNode = getNodeByXPath(table.getCommonXpath(),doc.getFirstChild(),doc,true);


                        short startColumnIndex = table.getStartCellReference().getCol();
                        for(int j = startColumnIndex; j<= table.getEndCellReference().getCol();j++) {
                            XSSFCell cell = row.getCell(j);
                            if (cell!=null) {
                                XSSFXmlColumnPr pointer = tableColumns.get(j-startColumnIndex);
                                String localXPath = pointer.getLocalXPath();
                                Node currentNode = getNodeByXPath(localXPath,tableRootNode,doc,false);
                                STXmlDataType.Enum dataType = pointer.getXmlDataType();

View Full Code Here

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


            String xpathString = singleXmlCell.getXpath();
            Node result = (Node) xpath.evaluate(xpathString, doc, XPathConstants.NODE);
            String textContent = result.getTextContent();
            logger.log(POILogger.DEBUG, "Extracting with xpath " + xpathString + " : value is '" + textContent + "'");
            XSSFCell cell = singleXmlCell.getReferencedCell();
            logger.log(POILogger.DEBUG, "Setting '" + textContent + "' to cell " + cell.getColumnIndex() + "-" + cell.getRowIndex() + " in sheet "
                                            + cell.getSheet().getSheetName());
            cell.setCellValue(textContent);
        }


        for (Table table : tables) {


            String commonXPath = table.getCommonXpath();
            NodeList result = (NodeList) xpath.evaluate(commonXPath, doc, XPathConstants.NODESET);
            int rowOffset = table.getStartCellReference().getRow() + 1;// the first row contains the table header
            int columnOffset = table.getStartCellReference().getCol() - 1;


            for (int i = 0; i < result.getLength(); i++) {


                // TODO: implement support for denormalized XMLs (see
                // OpenOffice part 4: chapter 3.5.1.7)


                for (XSSFXmlColumnPr xmlColumnPr : table.getXmlColumnPrs()) {


                    int localColumnId = (int) xmlColumnPr.getId();
                    int rowId = rowOffset + i;
                    int columnId = columnOffset + localColumnId;
                    String localXPath = xmlColumnPr.getLocalXPath();
                    localXPath = localXPath.substring(localXPath.substring(1).indexOf('/') + 1);


                    // Build an XPath to select the right node (assuming
                    // that the commonXPath != "/")
                    String nodeXPath = commonXPath + "[" + (i + 1) + "]" + localXPath;


                    // TODO: convert the data to the cell format
                    String value = (String) xpath.evaluate(nodeXPath, result.item(i), XPathConstants.STRING);
                    logger.log(POILogger.DEBUG, "Extracting with xpath " + nodeXPath + " : value is '" + value + "'");
                    XSSFRow row = table.getXSSFSheet().getRow(rowId);
                    if (row == null) {
                        row = table.getXSSFSheet().createRow(rowId);
                    }


                    XSSFCell cell = row.getCell(columnId);
                    if (cell == null) {
                        cell = row.createCell(columnId);
                    }
                    logger.log(POILogger.DEBUG, "Setting '" + value + "' to cell " + cell.getColumnIndex() + "-" + cell.getRowIndex() + " in sheet "
                                                    + table.getXSSFSheet().getSheetName());
                    cell.setCellValue(value.trim());
                }
            }
        }
    }

View Full Code Here

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

          if(cell.getCellType() == Cell.CELL_TYPE_FORMULA && formulasNotResults) {
            text.append(cell.getCellFormula());
          } else if(cell.getCellType() == Cell.CELL_TYPE_STRING) {
            text.append(cell.getRichStringCellValue().getString());
          } else {
            XSSFCell xc = (XSSFCell)cell;
            text.append(xc.getRawValue());
          }


          // Output the comment, if requested and exists
            Comment comment = cell.getCellComment();
          if(includeCellComments && comment != null) {

View Full Code Here

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


            String xpathString = singleXmlCell.getXpath();
            Node result = (Node) xpath.evaluate(xpathString, doc, XPathConstants.NODE);
            String textContent = result.getTextContent();
            logger.log(POILogger.DEBUG, "Extracting with xpath " + xpathString + " : value is '" + textContent + "'");
            XSSFCell cell = singleXmlCell.getReferencedCell();
            logger.log(POILogger.DEBUG, "Setting '" + textContent + "' to cell " + cell.getColumnIndex() + "-" + cell.getRowIndex() + " in sheet "
                                            + cell.getSheet().getSheetName());
            cell.setCellValue(textContent);
        }


        for (XSSFTable table : tables) {


            String commonXPath = table.getCommonXpath();
            NodeList result = (NodeList) xpath.evaluate(commonXPath, doc, XPathConstants.NODESET);
            int rowOffset = table.getStartCellReference().getRow() + 1;// the first row contains the table header
            int columnOffset = table.getStartCellReference().getCol() - 1;


            for (int i = 0; i < result.getLength(); i++) {


                // TODO: implement support for denormalized XMLs (see
                // OpenOffice part 4: chapter 3.5.1.7)


                for (XSSFXmlColumnPr xmlColumnPr : table.getXmlColumnPrs()) {


                    int localColumnId = (int) xmlColumnPr.getId();
                    int rowId = rowOffset + i;
                    int columnId = columnOffset + localColumnId;
                    String localXPath = xmlColumnPr.getLocalXPath();
                    localXPath = localXPath.substring(localXPath.substring(1).indexOf('/') + 1);


                    // Build an XPath to select the right node (assuming
                    // that the commonXPath != "/")
                    String nodeXPath = commonXPath + "[" + (i + 1) + "]" + localXPath;


                    // TODO: convert the data to the cell format
                    String value = (String) xpath.evaluate(nodeXPath, result.item(i), XPathConstants.STRING);
                    logger.log(POILogger.DEBUG, "Extracting with xpath " + nodeXPath + " : value is '" + value + "'");
                    XSSFRow row = table.getXSSFSheet().getRow(rowId);
                    if (row == null) {
                        row = table.getXSSFSheet().createRow(rowId);
                    }


                    XSSFCell cell = row.getCell(columnId);
                    if (cell == null) {
                        cell = row.createCell(columnId);
                    }
                    logger.log(POILogger.DEBUG, "Setting '" + value + "' to cell " + cell.getColumnIndex() + "-" + cell.getRowIndex() + " in sheet "
                                                    + table.getXSSFSheet().getSheetName());
                    cell.setCellValue(value.trim());
                }
            }
        }
    }

View Full Code Here

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

            return;
         }
      }


      // No supported styling applies to this cell
      XSSFCell xcell = (XSSFCell)cell;
      text.append( xcell.getRawValue() );
   }

View Full Code Here

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


            if (!xpath.matches(".*\\[.*")) {


                // Exports elements and attributes mapped with simpleXmlCell
                if (simpleXmlCell!=null) {
                    XSSFCell cell = simpleXmlCell.getReferencedCell();
                    if (cell!=null) {
                        Node currentNode = getNodeByXPath(xpath,doc.getFirstChild(),doc,false);
                        STXmlDataType.Enum dataType = simpleXmlCell.getXmlDataType();
                        mapCellOnNode(cell,currentNode,dataType);
                    }
                }


                // Exports elements and attributes mapped with tables
                if (table!=null) {


                    List<XSSFXmlColumnPr> tableColumns = table.getXmlColumnPrs();


                    XSSFSheet sheet = table.getXSSFSheet();


                    int startRow = table.getStartCellReference().getRow();
                    // In mappings created with Microsoft Excel the first row contains the table header and must be skipped
                    startRow +=1;


                    int endRow = table.getEndCellReference().getRow();


                    for(int i = startRow; i<= endRow; i++) {
                        XSSFRow row = sheet.getRow(i);


                        Node tableRootNode = getNodeByXPath(table.getCommonXpath(),doc.getFirstChild(),doc,true);


                        short startColumnIndex = table.getStartCellReference().getCol();
                        for(int j = startColumnIndex; j<= table.getEndCellReference().getCol();j++) {
                            XSSFCell cell = row.getCell(j);
                            if (cell!=null) {
                                XSSFXmlColumnPr pointer = tableColumns.get(j-startColumnIndex);
                                String localXPath = pointer.getLocalXPath();
                                Node currentNode = getNodeByXPath(localXPath,tableRootNode,doc,false);
                                STXmlDataType.Enum dataType = pointer.getXmlDataType();

View Full Code Here

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

  /**
   * Gets the XSSFCell referenced by the R attribute or creates a new one if cell doesn't exists
   * @return the referenced XSSFCell, null if the cell reference is invalid
   */
  public XSSFCell getReferencedCell(){
    XSSFCell cell = null;
    
    
    CellReference cellReference =  new CellReference(singleXmlCell.getR()); 
    
    XSSFRow row = parent.getXSSFSheet().getRow(cellReference.getRow());

View Full Code Here

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

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


            // read back as XSSF and check that xml:spaces="preserve" is set
            XSSFWorkbook xwb = (XSSFWorkbook)SXSSFITestDataProvider.instance.writeOutAndReadBack(swb);
            XSSFCell xCell = xwb.getSheetAt(0).getRow(0).getCell(0);


            CTRst is = xCell.getCTCell().getIs();
            XmlCursor c = is.newCursor();
            c.toNextToken();
            String t = c.getAttributeText(new QName("http://www.w3.org/XML/1998/namespace", "space"));
            c.dispose();
            assertEquals("expected xml:spaces=\"preserve\" \"" + str + "\"", "preserve", t);

View Full Code Here

Examples of org.zkoss.poi.xssf.usermodel.XSSFCell

          } else {
            removeCells(row, lCol, rCol);
          }
          for(Entry<Integer, XSSFCell> cellentry : cells.entrySet()) {
            final int colnum = cellentry.getKey().intValue();
            final XSSFCell srcCell = cellentry.getValue();
            BookHelper.assignCell(srcCell, row.createCell(colnum));
          }
        }
        
        //handle inserted rows
        if (srcRow != null) {
          final int row2 = Math.min(startRow + n - 1, SpreadsheetVersion.EXCEL2007.getLastRowIndex());
          for ( int rownum = startRow; rownum <= row2; ++rownum) {
            XSSFRow row = getRow(rownum);
            if (row == null) {
              row = createRow(rownum); 
            }
            row.setHeight(srcHeight); //height
//            if (srcStyle != null) {
//              row.setRowStyle((HSSFCellStyle)copyFromStyleExceptBorder(srcStyle));//style
//            }
            if (srcCells != null) {
              for (Entry<Integer, Cell> cellEntry : srcCells.entrySet()) {
                final Cell srcCell = cellEntry.getValue();
                final CellStyle cellStyle = srcCell.getCellStyle();
                final int c = cellEntry.getKey().intValue();
                Cell cell = row.getCell(c);
                if (cell == null) {
                  cell = row.createCell(c);
                }

View Full Code Here

Examples of org.zkoss.poi.xssf.usermodel.XSSFCell

      }
        final List<int[]> removePairs = new ArrayList<int[]>(); //column spans to be removed 
        final Set<XSSFCell> rowCells = new HashSet<XSSFCell>();
        int expectColnum = startCol; //handle sparse columns which might override destination column
      for (Iterator<XSSFCell> it = row.getCells().subMap(startCol, endCol+1).values().iterator(); it.hasNext(); ) {
        XSSFCell cell = it.next();
        int colnum = cell.getColumnIndex();
        
        final int newColnum = colnum + n;
        if (colnum > expectColnum) { //sparse column between expectColnum(inclusive) and current column(exclusive), to be removed
          addRemovePair(removePairs, row, expectColnum + n, newColnum);
        }
        expectColnum = colnum + 1;
        
      it.remove(); //remove cell from this row
        final boolean inbound = 0 <= newColnum && newColnum <= maxcol;
        if (!inbound) {
          notifyCellShifting(cell);
          continue;
        }
        rowCells.add(cell);
      }
      
      addRemovePair(removePairs, row, expectColnum + n, endCol + 1 + n);
      
      //remove those not existing cells
      for(int[] pair : removePairs) {
        final int start = Math.max(0, pair[0]);
        final int end = Math.min(maxcol + 1, pair[1]);
        for(int j=start; j < end; ++j) {
          Cell cell = row.getCell(j);
          if (cell != null) {
            row.removeCell(cell);
          }
        }
      }
      
      //update the cells
      for(XSSFCell srcCell: rowCells) {
        BookHelper.assignCell(srcCell, row.createCell(srcCell.getColumnIndex()+n));
      }
      
        //special case1: endCol < startCol
        //special case2: (endCol - startCol + 1) < ABS(n)
        if (n < 0) {
          if (endCol < startCol) { //special case1
          final int replacedStartCol = startCol + n;
              for ( int colNum = replacedStartCol; colNum >= replacedStartCol && colNum <= endCol && colNum >= 0 && colNum <= maxcol; ++colNum) {
                final XSSFCell cell = row.getCell(colNum, Row.RETURN_NULL_AND_BLANK);
                if (cell != null) {
                  row.removeCell(cell);
                }
              }
            } else if (clearRest) { //special case 2
              final int replacedStartCol = endCol + n + 1;
              if (replacedStartCol <= startCol) {
                  for ( int colNum = replacedStartCol; colNum >= replacedStartCol && colNum <= startCol && colNum >= 0 && colNum <= maxcol; ++colNum) {
                    final XSSFCell cell = row.getCell(colNum, Row.RETURN_NULL_AND_BLANK);
                    if (cell != null) {
                      row.removeCell(cell);
                    }
                  }
              }

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.