aspose.cells

Class ListObjectCollection

Represents a collection of ListObject objects in the worksheet.

Property Getters/Setters Summary
functiongetCount()
functionget(index)
Gets the ListObject by index.
functionget(tableName)
Gets the ListObject by specified name.
 
Method Summary
functionadd(startRow, startColumn, endRow, endColumn, hasHeaders)
Adds a ListObject to the worksheet.
functionadd(value)
Reserved for internal use.
functionadd(startCell, endCell, hasHeaders)
Adds a ListObject to the worksheet.
functionclear()
functioncontains(value)
Reserved for internal use.
functionget(index)
Reserved for internal use.
functionindexOf(value)
Reserved for internal use.
functioniterator()
functionremoveAt(index)
functionupdateColumnName()
Update all column name of the tables.
 

    • Property Getters/Setters Detail

      • getCount : Number 

        function getCount()
        
      • get : ListObject 

        function get(index)
        
        Gets the ListObject by index.
        Parameters:
        index - The index.
        Returns:
        The ListObject
      • get : ListObject 

        function get(tableName)
        
        Gets the ListObject by specified name.
        Parameters:
        tableName - ListObject name.
        Returns:
        The ListObject
    • Method Detail

      • add

        function add(startRow, startColumn, endRow, endColumn, hasHeaders)
        Adds a ListObject to the worksheet.
        Parameters:
        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:
        The index of the new ListObject
      • add

        function add(startCell, endCell, hasHeaders)
        Adds a ListObject to the worksheet.
        Parameters:
        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:
        The index of the new ListObject
      • updateColumnName

        function updateColumnName()
        Update all column name of the tables.
      • clear

        function clear()
      • removeAt

        function removeAt(index)
      • iterator

        function iterator()
      • get

        function get(index)
        Reserved for internal use.
      • contains

        function contains(value)
        Reserved for internal use.
      • add

        function add(value)
        Reserved for internal use.
      • indexOf

        function indexOf(value)
        Reserved for internal use.