ListObject

Overview

ListObject is a class in Aspose.Cells FOSS for Java.

Represents an Excel table (structured reference / ListObject).

Name	Type	Access
`displayName`	`String`	Read
`comment`	`String`	Read
`startRow`	`int`	Read
`startColumn`	`int`	Read
`endRow`	`int`	Read
`endColumn`	`int`	Read
`showHeaderRow`	`boolean`	Read
`showTotals`	`boolean`	Read
`tableStyleType`	`TableStyleType`	Read
`tableStyleName`	`String`	Read
`showTableStyleFirstColumn`	`boolean`	Read
`showTableStyleLastColumn`	`boolean`	Read
`showTableStyleRowStripes`	`boolean`	Read
`showTableStyleColumnStripes`	`boolean`	Read
`listColumns`	`ListColumnCollection`	Read

Signature	Description
`getDisplayName()` → `String`
`setDisplayName(name: String)`
`getComment()` → `String`
`setComment(comment: String)`
`getStartRow()` → `int`
`getStartColumn()` → `int`
`getEndRow()` → `int`
`getEndColumn()` → `int`
`isShowHeaderRow()` → `boolean`
`setShowHeaderRow(show: boolean)`
`isShowTotals()` → `boolean`
`setShowTotals(show: boolean)`
`getTableStyleType()` → `TableStyleType`
`setTableStyleType(type: TableStyleType)`
`getTableStyleName()` → `String`
`setTableStyleName(name: String)`
`isShowTableStyleFirstColumn()` → `boolean`
`setShowTableStyleFirstColumn(v: boolean)`
`isShowTableStyleLastColumn()` → `boolean`
`setShowTableStyleLastColumn(v: boolean)`
`isShowTableStyleRowStripes()` → `boolean`
`setShowTableStyleRowStripes(v: boolean)`
`isShowTableStyleColumnStripes()` → `boolean`
`setShowTableStyleColumnStripes(v: boolean)`
`getListColumns()` → `ListColumnCollection`
`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.