org.apache.poi.xssf.usermodel
Class XSSFTable

java.lang.Object
  org.apache.poi.POIXMLDocumentPart
      org.apache.poi.xssf.usermodel.XSSFTable

public class XSSFTable
extends POIXMLDocumentPart

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

XSSFTable

public XSSFTable()

XSSFTable

public XSSFTable(PackagePart part,
                 PackageRelationship rel)
          throws java.io.IOException

Throws:

java.io.IOException

readFrom

public void readFrom(java.io.InputStream is)
              throws java.io.IOException

Throws:

java.io.IOException

getXSSFSheet

public XSSFSheet getXSSFSheet()

writeTo

public void writeTo(java.io.OutputStream out)
             throws java.io.IOException

Throws:

java.io.IOException

commit

protected void commit()
               throws java.io.IOException

Description copied from class: POIXMLDocumentPart

Save the content in the underlying package part. Default implementation is empty meaning that the package part is left unmodified. Sub-classes should override and add logic to marshal the "model" into Ooxml4J. For example, the code saving a generic XML entry may look as follows:

 protected void commit() throws IOException {
   PackagePart part = getPackagePart();
   OutputStream out = part.getOutputStream();
   XmlObject bean = getXmlBean(); //the "model" which holds changes in memory
   bean.save(out, DEFAULT_XML_OPTIONS);
   out.close();
 }
  

Overrides:

commit in class POIXMLDocumentPart

Throws:

java.io.IOException

getCTTable

public org.openxmlformats.schemas.spreadsheetml.x2006.main.CTTable getCTTable()

mapsTo

public boolean mapsTo(long id)

Checks if this Table element contains even a single mapping to the map identified by id

Parameters:

id - the XSSFMap ID

Returns:

true if the Table element contain mappings

getCommonXpath

public java.lang.String getCommonXpath()

Calculates the xpath of the root element for the table. This will be the common part of all the mapping's xpaths

Returns:

the xpath of the table's root element

getXmlColumnPrs

public java.util.List<XSSFXmlColumnPr> getXmlColumnPrs()

getName

public java.lang.String getName()

Returns:

the name of the Table, if set

setName

public void setName(java.lang.String name)

Changes the name of the Table

getDisplayName

public java.lang.String getDisplayName()

Returns:

the display name of the Table, if set

setDisplayName

public void setDisplayName(java.lang.String name)

Changes the display name of the Table

getNumerOfMappedColumns

public long getNumerOfMappedColumns()

Returns:

the number of mapped table columns (see Open Office XML Part 4: chapter 3.5.1.4)

getStartCellReference

public CellReference getStartCellReference()

Returns:

The reference for the cell in the top-left part of the table (see Open Office XML Part 4: chapter 3.5.1.2, attribute ref)

getEndCellReference

public CellReference getEndCellReference()

Returns:

The reference for the cell in the bottom-right part of the table (see Open Office XML Part 4: chapter 3.5.1.2, attribute ref)

getRowCount

public int getRowCount()

Returns:

the total number of rows in the selection. (Note: in this version autofiltering is ignored)

updateHeaders

public void updateHeaders()

Synchronize table headers with cell values in the parent sheet. Headers must be in sync, otherwise Excel will display a "Found unreadable content" message on startup.