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. |