public final class XSSFAutoFilter extends POIXMLDocumentPart implements AutoFilter
Modifier and Type | Class and Description |
---|---|
class |
XSSFAutoFilter.XSSFFilterColumn |
DEFAULT_XML_OPTIONS
FILTEROP_ABOVE_AVERAGE, FILTEROP_AND, FILTEROP_BELOW_AVERAGE, FILTEROP_BOTOOM10PERCENT, FILTEROP_BOTTOM10, FILTEROP_CELL_COLOR, FILTEROP_FONT_COLOR, FILTEROP_LAST_MONTH, FILTEROP_LAST_QUARTER, FILTEROP_LAST_WEEK, FILTEROP_LAST_YEAR, FILTEROP_M1, FILTEROP_M10, FILTEROP_M11, FILTEROP_M12, FILTEROP_M2, FILTEROP_M3, FILTEROP_M4, FILTEROP_M5, FILTEROP_M6, FILTEROP_M7, FILTEROP_M8, FILTEROP_M9, FILTEROP_NEXT_MONTH, FILTEROP_NEXT_QUARTER, FILTEROP_NEXT_WEEK, FILTEROP_NEXT_YEAR, FILTEROP_OR, FILTEROP_Q1, FILTEROP_Q2, FILTEROP_Q3, FILTEROP_Q4, FILTEROP_THIS_MONTH, FILTEROP_THIS_QUARTER, FILTEROP_THIS_WEEK, FILTEROP_THIS_YEAR, FILTEROP_TODAY, FILTEROP_TOMORROW, FILTEROP_TOP10, FILTEROP_TOP10PERCENT, FILTEROP_VALUES, FILTEROP_YEAR_TO_DATE, FILTEROP_YESTERDAY
Constructor and Description |
---|
XSSFAutoFilter(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTAutoFilter ctaf)
Deprecated.
|
XSSFAutoFilter(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTAutoFilter ctaf,
XSSFWorkbook book) |
XSSFAutoFilter(PackagePart part,
PackageRelationship rel) |
XSSFAutoFilter(XSSFSheet sheet,
org.openxmlformats.schemas.spreadsheetml.x2006.main.CTAutoFilter ctaf)
Deprecated.
|
Modifier and Type | Method and Description |
---|---|
protected void |
commit()
Save the content in the underlying package part.
|
FilterColumn |
getFilterColumn(int col)
Returns the column filter information of the specified column; null if the column is not filtered.
|
java.util.List<FilterColumn> |
getFilterColumns()
Return filter setting of each filtered column.
|
FilterColumn |
getOrCreateFilterColumn(int colId) |
CellRangeAddress |
getRangeAddress()
Returns the filtered Range.
|
void |
readFrom(java.io.InputStream is) |
void |
setRef(java.lang.String ref) |
void |
writeTo(java.io.OutputStream out) |
addRelation, clearMemoryPackagePart, createRelationship, createRelationship, createRelationship, getPackagePart, getPackageRelationship, getParent, getRelationById, getRelationCounter, getRelationId, getRelations, getTargetPart, onDocumentCreate, onDocumentRead, onDocumentRemove, onSave, read, rebase, removeRelation, removeRelation, toString
@Deprecated public XSSFAutoFilter(XSSFSheet sheet, org.openxmlformats.schemas.spreadsheetml.x2006.main.CTAutoFilter ctaf)
@Deprecated public XSSFAutoFilter(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTAutoFilter ctaf)
public XSSFAutoFilter(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTAutoFilter ctaf, XSSFWorkbook book)
public XSSFAutoFilter(PackagePart part, PackageRelationship rel) throws java.io.IOException
java.io.IOException
public FilterColumn getOrCreateFilterColumn(int colId)
public void readFrom(java.io.InputStream is) throws java.io.IOException
java.io.IOException
public void writeTo(java.io.OutputStream out) throws java.io.IOException
java.io.IOException
protected void commit() throws java.io.IOException
POIXMLDocumentPart
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();
}
commit
in class POIXMLDocumentPart
java.io.IOException
public CellRangeAddress getRangeAddress()
AutoFilter
getRangeAddress
in interface AutoFilter
public java.util.List<FilterColumn> getFilterColumns()
AutoFilter
getFilterColumns
in interface AutoFilter
public FilterColumn getFilterColumn(int col)
AutoFilter
getFilterColumn
in interface AutoFilter
col
- the nth column (1st column in the filter range is 0)public void setRef(java.lang.String ref)
Copyright © 2005-2010 Potix Corporation. All Rights Reserved.