DS.Documents.Excel Assembly

GrapeCity.Documents.Excel.ITable

ITable Interface

Represents a table object on a worksheet.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public interface ITable

Public Interface ITable

Properties

Name	Description
AutoFilter	Filters a list using the IAutoFilter (read-only).
AutoGenerateColumns	Gets or sets whether to generate columns automatically while binding data.
BindingPath	Gets or sets binding path of current table.
Columns	Returns an ITableColumns collection that represents all the columns in the ITable object.
Comment	Gets or sets the comment associated with the table object.
DataRange	Returns the IRange object that represents the range that contains the data area in the table between the header row and the insert row.
DisplayName	Gets or sets the display name for the specified ITable.
ExpandBoundRows	Gets or sets whether to add/delete entire rows on data binding.
HeaderRange	Returns the IRange object that represents the range of the header row for a table.
Name	Gets or sets the name of the ITable object.
Range	Returns the IRange object that represents the range to which the specified table object applies.
Rows	Returns the ITableRows that represents all the rows of data in the ITable object.
ShowAutoFilter	Gets or sets whether the AutoFilter is displayed.
ShowAutoFilterDropDown	Gets or sets whether the table filter button is visible.
ShowHeaders	Gets or sets whether the header information should be displayed for the specified ITable object (read or write).
ShowTableStyleColumnStripes	Gets or sets if the column stripes table style is used for the specified ITable object (read or write).
ShowTableStyleFirstColumn	Gets or sets if the first column is formatted for the specified ITable object (read or write).
ShowTableStyleLastColumn	Gets or sets if the last column is displayed for the specified ITable object (read or write).
ShowTableStyleRowStripes	Gets or sets if the row stripes table style is used for the specified ITable object (read or write).
ShowTotals	Gets or sets whether the total row is visible.
Sort	Gets the sort column or columns, and sort order for the ITable collection.
TableStyle	Gets or sets the table style for the specified ITable object (read or write).
TotalsRange	Returns the IRange object that represents the Total row, if any, from a specified ITable object.

Methods

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 the worksheet.
FromJson(string)	Generate table from Json string.
Resize(IRange)	The Resize method allows the ITable object to be resized over a new range. No cells are inserted or moved. NOTE: The headers must remain in the same row, and the resulting table range must overlap the original table range.
ToJson()	Generate json string from table.