ListObjectCollection

ListObjectCollection class

Represents a collection of ListObject objects in the worksheet.

Properties

NameTypeDescription
Countint
Item (int)ListObjectGets the ListObject by index.
Item (java.lang.String)ListObjectGets the ListObject by specified name.

Methods

NameDescription
addAdds a ListObject to the worksheet.
removeAt
updateColumnNameUpdate all column name of the tables.
clear
iterator
getReserved for internal use.
containsReserved for internal use.
indexOfReserved for internal use.

ListObjectCollection.Count property

Type: int

ListObjectCollection.Item (int) property

Gets the ListObject by index.

Type: ListObject

ListObjectCollection.Item (java.lang.String) property

Gets the ListObject by specified name.

Type: ListObject

add(startRow, startColumn, endRow, endColumn, hasHeaders) (1 of 3)

Adds a ListObject to the worksheet.

ParameterTypeDescription
startRowintThe start row of the list range.
startColumnintThe start row of the list range.
endRowintThe start row of the list range.
endColumnintThe start row of the list range.
hasHeadersbooleanWhether the range has headers.

Returns: The index of the new ListObject


add(startCell, endCell, hasHeaders) (2 of 3)

Adds a ListObject to the worksheet.

ParameterTypeDescription
startCellStringThe start cell of the list range.
endCellStringThe end cell of the list range.
hasHeadersbooleanWhether the range has headers.

Returns: The index of the new ListObject


add(value) (3 of 3)

Reserved for internal use.

removeAt(index)

updateColumnName()

Update all column name of the tables.

clear()

iterator()

get(index)

Reserved for internal use.

contains(value)

Reserved for internal use.

indexOf(value)

Reserved for internal use.