Name | Description | |
---|---|---|
![]() | convertToRange | Convert the range of cells that made up the table to a regular range of data. |
![]() | delete | Deletes the ITable object and clears the cell data from theworksheet. |
![]() | fromJson | Generate the table from json string. |
![]() | getAutoFilter | Filters a list using the IAutoFilter . |
![]() | getAutoGenerateColumns | Gets whether to generate columns automatically while binding data. |
![]() | getBindingPath | Gets the binding path of current table. |
![]() | getColumns | Returns an ITableColumns collection that represents all the columnsin the ITable object. |
![]() | getComment | Gets the comment associated with the table object. |
![]() | getDataRange | Returns the IRange object that represents the range that contains thedata area in the table between the header row and the insert row. |
![]() | getDisplayName | Gets the display name for the specified ITable. |
![]() | getExpandBoundRows | Gets whether to add/delete entire rows on data binding. |
![]() | getHeaderRange | Returns the IRange object that represents the range of the header rowfor a table. |
![]() | getName | Gets the name of the ITable object. |
![]() | getRange | Returns the IRange object that represents the range to which thespecified table object applies. |
![]() | getRows | Returns the ITableRows that represents all the rows of data in the ITable object. |
![]() | getShowAutoFilter | Gets whether the AutoFilter is displayed. |
![]() | getShowAutoFilterDropDown | Gets whether the table filter button is visible. |
![]() | getShowHeaders | Gets whether the header information should be displayed for the specified ITable object. |
![]() | getShowTableStyleColumnStripes | Gets if the column stripes table style is used for the specified ITable object . |
![]() | getShowTableStyleFirstColumn | Gets if the first column is formatted for the specified ITableobject. |
![]() | getShowTableStyleLastColumn | Gets if the last column is displayed for the specified ITable object. |
![]() | getShowTableStyleRowStripes | Gets if the row stripes table style is used for the specified ITableobject. |
![]() | getShowTotals | Gets whether the total row is visible. |
![]() | getSort | Gets the sort column or columns, and sort order for the ITablecollection. |
![]() | getTableStyle | Gets the table style for the specified ITable object. |
![]() | getTotalsRange | Returns the IRange object that represents the Total row, if any, froma specified ITable object. |
![]() | resize | The Resize method allows the ITable object to be resized over a newrange. No cells are inserted or moved. |
![]() | setAutoGenerateColumns | Sets whether to generate columns automatically while binding data. |
![]() | setBindingPath | Sets the binding path of current table. |
![]() | setComment | Sets the comment associated with the table object. |
![]() | setDisplayName | Sets the display name for the specified ITable. |
![]() | setExpandBoundRows | Sets whether to add/delete entire rows on data binding. |
![]() | setName | Sets the name of the ITable object. |
![]() | setShowAutoFilter | Sets whether the AutoFilter is displayed. |
![]() | setShowAutoFilterDropDown | Sets whether the table filter button is visible. |
![]() | setShowHeaders | Sets whether the header information should be displayed for the specified ITable object. |
![]() | setShowTableStyleColumnStripes | Sets if the column stripes table style is used for the specified ITable object . |
![]() | setShowTableStyleFirstColumn | Sets if the first column is formatted for the specified ITableobject. |
![]() | setShowTableStyleLastColumn | Sets if the last column is displayed for the specified ITable object. |
![]() | setShowTableStyleRowStripes | Sets if the row stripes table style is used for the specified ITableobject. |
![]() | setShowTotals | Sets whether the total row is visible. |
![]() | setTableStyle | Sets the table style for the specified ITable object. |
![]() | toJson | Generate the string from table. |