Examples of XSSFSingleXmlCell

org.apache.poi.xssf.usermodel.helpers.XSSFSingleXmlCell
This class is a wrapper around the CTSingleXmlCell (Open Office XML Part 4: chapter 3.5.2.1) @author Roberto Manicardi

Examples of org.apache.poi.xssf.usermodel.helpers.XSSFSingleXmlCell


        Collections.sort(xpaths,this);


        for(String xpath : xpaths) {


            XSSFSingleXmlCell simpleXmlCell = singleXmlCellsMappings.get(xpath);
            XSSFTable table = tableMappings.get(xpath);


            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);
                        
                        //remove nodes which are empty in order to keep the output xml valid
                        if("".equals(currentNode.getTextContent()) && currentNode.getParentNode() != null) {
                          currentNode.getParentNode().removeChild(currentNode);

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.helpers.XSSFSingleXmlCell


        Collections.sort(xpaths,this);


        for(String xpath : xpaths) {


            XSSFSingleXmlCell simpleXmlCell = singleXmlCellsMappings.get(xpath);
            XSSFTable table = tableMappings.get(xpath);


            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

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.helpers.XSSFSingleXmlCell


        Collections.sort(xpaths,this);


        for(String xpath : xpaths) {


            XSSFSingleXmlCell simpleXmlCell = singleXmlCellsMappings.get(xpath);
            XSSFTable table = tableMappings.get(xpath);


            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

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.helpers.XSSFSingleXmlCell


        Collections.sort(xpaths,this);


        for(String xpath : xpaths) {


            XSSFSingleXmlCell simpleXmlCell = singleXmlCellsMappings.get(xpath);
            XSSFTable table = tableMappings.get(xpath);


            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);
                        
                        //remove nodes which are empty in order to keep the output xml valid
                        if("".equals(currentNode.getTextContent()) && currentNode.getParentNode() != null) {
                          currentNode.getParentNode().removeChild(currentNode);

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.helpers.XSSFSingleXmlCell

  public List<XSSFSingleXmlCell> getAllSimpleXmlCell(){
    List<XSSFSingleXmlCell> list = new Vector<XSSFSingleXmlCell>();
    CTSingleXmlCell[] singleXMLCellArray = singleXMLCells.getSingleXmlCellArray();
    
    for(CTSingleXmlCell singleXmlCell: singleXMLCellArray){      
      list.add(new XSSFSingleXmlCell(singleXmlCell,this));
    }    
    return list;
  }

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.helpers.XSSFSingleXmlCell

          
          Collections.sort(xpaths,this);
          
          for(String xpath : xpaths){
            
              XSSFSingleXmlCell simpleXmlCell = singleXmlCellsMappings.get(xpath);
              Table table = tableMappings.get(xpath);    
              
              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

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.helpers.XSSFSingleXmlCell


        Collections.sort(xpaths,this);


        for(String xpath : xpaths) {


            XSSFSingleXmlCell simpleXmlCell = singleXmlCellsMappings.get(xpath);
            Table table = tableMappings.get(xpath);


            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

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.helpers.XSSFSingleXmlCell


        Collections.sort(xpaths,this);


        for(String xpath : xpaths) {


            XSSFSingleXmlCell simpleXmlCell = singleXmlCellsMappings.get(xpath);
            Table table = tableMappings.get(xpath);


            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

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.helpers.XSSFSingleXmlCell


        Collections.sort(xpaths,this);


        for(String xpath : xpaths) {


            XSSFSingleXmlCell simpleXmlCell = singleXmlCellsMappings.get(xpath);
            Table table = tableMappings.get(xpath);


            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

View Full Code Here

Examples of org.apache.poi.xssf.usermodel.helpers.XSSFSingleXmlCell

   */
  public List<XSSFSingleXmlCell> getAllSimpleXmlCell(){
    List<XSSFSingleXmlCell> list = new Vector<XSSFSingleXmlCell>();
    
    for(CTSingleXmlCell singleXmlCell: singleXMLCells.getSingleXmlCellList()){      
      list.add(new XSSFSingleXmlCell(singleXmlCell,this));
    }    
    return list;
  }

View Full Code Here

0 1

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.