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.