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
-
Number
The 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
-
Number
The 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
-
ListObject
The ListObject
get(tableName) → ListObject
Gets the ListObject by specified name.
Parameter
Name | Type | Optional | Description |
---|---|---|---|
tableName |
String |
|
ListObject name. |
- Returns
-
ListObject
The ListObject
get()
Reserved for internal use.
getCount()
indexOf()
Reserved for internal use.
iterator()
removeAt()
updateColumnName()
Update all column name of the tables.