ListObject
Overview
ListObject is a class in Aspose.Cells FOSS for Java.
Represents an Excel table (structured reference / ListObject).
This class provides 29 methods for working with ListObject objects in Java programs.
Available methods include: convertToRange, getComment, getDisplayName, getEndColumn, getEndRow, getListColumns, getStartColumn, getStartRow, getTableStyleName, getTableStyleType, isShowHeaderRow, isShowTableStyleColumnStripes, and 17 additional methods.
All exported members are accessible to any Java application after installing the Aspose.Cells FOSS for Java package.
Properties: comment, displayName, endColumn, endRow, listColumns, showHeaderRow, and 9 more.
Description
ListObject is a class in the Aspose.Cells FOSS library for Java that exposes 29 methods and 15 properties for programmatic use.
Core capabilities include: string; string; boolean. These operations enable developers to integrate listobject functionality directly into Java applications.
The class also provides the displayName property (gets the display name), the comment property (gets the comment), the startRow property (gets the start row).
Properties
| Name | Type | Access | Description |
|---|---|---|---|
displayName | String | Read | Gets the display name. |
comment | String | Read | Gets the comment. |
startRow | int | Read | Gets the start row. |
startColumn | int | Read | Gets the start column. |
endRow | int | Read | Gets the end row. |
endColumn | int | Read | Gets the end column. |
showHeaderRow | boolean | Read | Gets the show header row. |
showTotals | boolean | Read | Gets the show totals. |
tableStyleType | TableStyleType | Read | Gets the table style type. |
tableStyleName | String | Read | Gets the table style name. |
showTableStyleFirstColumn | boolean | Read | Gets the show table style first column. |
showTableStyleLastColumn | boolean | Read | Gets the show table style last column. |
showTableStyleRowStripes | boolean | Read | Gets the show table style row stripes. |
showTableStyleColumnStripes | boolean | Read | Gets the show table style column stripes. |
listColumns | ListColumnCollection | Read | Gets the list columns. |
Methods
| Signature | Description |
|---|---|
getDisplayName() → String | Returns the display name. |
setDisplayName(name: String) | Sets the display name value. |
getComment() → String | Returns the comment. |
setComment(comment: String) | Sets the comment value. |
getStartRow() → int | Returns the start row. |
getStartColumn() → int | Returns the start column. |
getEndRow() → int | Returns the end row. |
getEndColumn() → int | Returns the end column. |
isShowHeaderRow() → boolean | Returns true if show header row is set. |
setShowHeaderRow(show: boolean) | Sets the show header row value. |
isShowTotals() → boolean | Returns true if show totals is set. |
setShowTotals(show: boolean) | Sets the show totals value. |
getTableStyleType() → TableStyleType | Returns the table style type. |
setTableStyleType(type: TableStyleType) | Sets the table style type value. |
getTableStyleName() → String | Returns the table style name. |
setTableStyleName(name: String) | Sets the table style name value. |
isShowTableStyleFirstColumn() → boolean | Returns true if show table style first column is set. |
setShowTableStyleFirstColumn(v: boolean) | Sets the show table style first column value. |
isShowTableStyleLastColumn() → boolean | Returns true if show table style last column is set. |
setShowTableStyleLastColumn(v: boolean) | Sets the show table style last column value. |
isShowTableStyleRowStripes() → boolean | Returns true if show table style row stripes is set. |
setShowTableStyleRowStripes(v: boolean) | Sets the show table style row stripes value. |
isShowTableStyleColumnStripes() → boolean | Returns true if show table style column stripes is set. |
setShowTableStyleColumnStripes(v: boolean) | Sets the show table style column stripes value. |
getListColumns() → ListColumnCollection | Returns the list columns. |
resize(startRow: int, startColumn: int, endRow: int, endColumn: int, hasHeaders: boolean) | Resizes the table to a new range, optionally preserving/removing header row. |
showAutoFilter() | |
removeAutoFilter() | |
convertToRange() | Removes the table structure, leaving cell data in place, and removes it from the collection. |