ListObjectCollection
Contents
[
Hide
]ListObjectCollection class
Represents a collection of ListObject objects in the worksheet.
Methods
| Name | Description |
|---|---|
| add(startRow, startColumn, endRow, endColumn, hasHeaders) | Adds a ListObject to the worksheet. |
| add(startCell, endCell, hasHeaders) | Adds a ListObject to the worksheet. |
| add() | Reserved for internal use. |
| clear() | |
| contains() | Reserved for internal use. |
| get(index) | Gets the ListObject by index. |
| get(tableName) | Gets the ListObject by specified name. |
| get() | Reserved for internal use. |
| getCount() | |
| indexOf() | Reserved for internal use. |
| iterator() | |
| removeAt() | |
| updateColumnName() | Update all column name of the tables. |
add(startRow, startColumn, endRow, endColumn, hasHeaders)
Adds a ListObject to the worksheet.
| Parameter | Type | Description |
|---|---|---|
| startRow | Number | The start row of the list range. |
| startColumn | Number | The start row of the list range. |
| endRow | Number | The start row of the list range. |
| endColumn | Number | The start row of the list range. |
| hasHeaders | boolean | Whether the range has headers. |
Returns: Number — Number The index of the new ListObject
add(startCell, endCell, hasHeaders)
Adds a ListObject to the worksheet.
| Parameter | Type | Description |
|---|---|---|
| startCell | String | The start cell of the list range. |
| endCell | String | The end cell of the list range. |
| hasHeaders | boolean | Whether the range has headers. |
Returns: Number — Number The index of the new ListObject
add()
Reserved for internal use.
clear()
contains()
Reserved for internal use.
get(index)
Gets the ListObject by index.
| Parameter | Type | Description |
|---|---|---|
| index | Number | The index. |
Returns: ListObject — ListObject The ListObject
get(tableName)
Gets the ListObject by specified name.
| Parameter | Type | Description |
|---|---|---|
| tableName | String | ListObject name. |
Returns: ListObject — ListObject The ListObject
get()
Reserved for internal use.
getCount()
indexOf()
Reserved for internal use.
iterator()
removeAt()
updateColumnName()
Update all column name of the tables.