Examples of XSSFTable

org.apache.poi.xssf.usermodel.XSSFTable
This class implements the Table Part (Open Office XML Part 4: chapter 3.5.1) This implementation works under the assumption that a table contains mappings to a subtree of an XML. The root element of this subtree an occur multiple times (one for each row of the table). The child nodes of the root element can be only attributes or element with maxOccurs=1 property set @author Roberto Manicardi

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

  private Set<XSSFTable> processedTables = new HashSet<XSSFTable>();


  
  @Override
  protected boolean processCell(HTMLBuilder result, Cell cell, boolean firstCell) {
    XSSFTable tableForCell = ConversionHelpers.getTableForCell(cell);
    
    if (tableForCell == null) {
      return super.processCell(result, cell, firstCell);      
    } else if (!processedTables.contains(tableForCell)) {
      tableStrategy.process(tableForCell, result);

View Full Code Here

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

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


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

View Full Code Here

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

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

View Full Code Here

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

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

View Full Code Here

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

        
        Workbook wb = new XSSFWorkbook();
        XSSFSheet sheet = (XSSFSheet) wb.createSheet();
        
        //Create 
        XSSFTable table = sheet.createTable();
        table.setDisplayName("Test");       
        CTTable cttable = table.getCTTable();
        
        //Style configurations
        CTTableStyleInfo style = cttable.addNewTableStyleInfo();
        style.setName("TableStyleMedium2");
        style.setShowColumnStripes(false);

View Full Code Here

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

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


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

View Full Code Here

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

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

View Full Code Here

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

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


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

View Full Code Here

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.