ListObject
Overview
ListObject is a class in Aspose.Cells FOSS for .NET.
Represents an Excel table (structured reference / ListObject).
Properties
| Name | Type | Access | Description |
|---|---|---|---|
DisplayName | string | Read/Write | Gets or sets the user‑defined name of the table |
Comment | string | Read/Write | Gets or sets a comment associated with the table |
StartRow | int | Read | Gets or sets the zero‑based index of the table’s first row |
StartColumn | int | Read | |
EndRow | int | Read | |
EndColumn | int | Read | Gets or sets the zero‑based index of the table’s last column |
ShowHeaderRow | bool | Read/Write | Gets or sets whether the table displays a header row |
ShowTotals | bool | Read/Write | |
TableStyleType | TableStyleType | Read/Write | Gets or sets the predefined style type applied to the table |
TableStyleName | string | Read/Write | Gets or sets the custom style name applied to the table |
ShowTableStyleFirstColumn | bool | Read/Write | Gets or sets whether the first column uses the table style |
ShowTableStyleLastColumn | bool | Read/Write | |
ShowTableStyleRowStripes | bool | Read/Write | Gets or sets whether row stripes are shown in the table style |
ShowTableStyleColumnStripes | bool | Read/Write | |
ListColumns | ListColumnCollection | Read | Gets the collection of columns defined in the table |
Methods
| Signature | Description |
|---|---|
Resize(startRow: int, startColumn: int, endRow: int, endColumn: int, hasHeaders: bool) | Resizes the table to the specified range, rebuilding columns from header cells. |
ShowAutoFilter() | Shows the autoFilter drop-down buttons on the table header row. |
RemoveAutoFilter() | Hides the autoFilter drop-down buttons from the table header row. |
ConvertToRange() | Removes the table structure, leaving the cell data in place. |