ListObjectCollection
Source: aspose.
Represents a collection of ListObject objects in the worksheet.
Methods
add(startRow, startColumn, endRow, endColumn, hasHeaders) → Number
Adds a ListObject to the worksheet.
Parameters
| Name | Type | Optional | 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
-
NumberThe index of the new ListObject
add(startCell, endCell, hasHeaders) → Number
Adds a ListObject to the worksheet.
Parameters
| Name | Type | Optional | 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
-
NumberThe index of the new ListObject
add()
Reserved for internal use.
clear()
contains()
Reserved for internal use.
get(index) → ListObject
Gets the ListObject by index.
Parameter
| Name | Type | Optional | Description |
|---|---|---|---|
|
index |
Number |
|
The index. |
- Returns
-
ListObjectThe ListObject
get(tableName) → ListObject
Gets the ListObject by specified name.
Parameter
| Name | Type | Optional | Description |
|---|---|---|---|
|
tableName |
String |
|
ListObject name. |
- Returns
-
ListObjectThe ListObject
get()
Reserved for internal use.
getCount()
indexOf()
Reserved for internal use.
iterator()
removeAt()
updateColumnName()
Update all column name of the tables.