GrapeCity.Spreadsheet.ITable

ITable Interface

Represents a table of the worksheet.

Namespace: GrapeCity.Spreadsheet

Assembly: GrapeCity.Spreadsheet.dll

Syntax

public interface ITable

Public Interface ITable

Properties

Name	Description
Active	Gets a value indicating whether the active cell of worksheet is inside the range of this ITable object.
AutoFilter	Gets the filter of this ITable.
AutoGenerateColumns	Gets or sets whether to generate the columns automatically based on the data source.
Comment	Gets or sets the comment associated with the ITable object.
DataAllowAddNew	Gets or sets whether to allow the user to add a new row when the table is bound.
DataBodyRange	Gets an IRange object that represents the range of values, excluding the header row, in a table.
DataSource	Gets or sets the data source that populates the table.
HeaderRowRange	Gets an IRange object that represents the range of the header row for a table.
Name	Gets the name of ITable object.
Range	Gets an IRange object that represents the range to which the specified table in the above list applies.
ShowAutoFilter	Gets or sets a boolean value indicating whether the AutoFilter will be displayed.
ShowAutoFilterDropDown	Gets or sets a boolean value indicating whether the AutoFilter drop down for the table object is displayed.
ShowHeaders	Gets or sets a value indicating whether the header row is visible.
ShowTableStyleColumnStripes	Gets or sets a value indicating whether the Column Stripes table style is used for the specified table object.
ShowTableStyleFirstColumn	Gets or sets a value indicating whether the first column is formatted for the specified table object.
ShowTableStyleLastColumn	Gets or sets a value indicating whether the last column is displayed for the specified table object.
ShowTableStyleRowStripes	Gets or sets a value indicating whether the Row Stripes table style is used for the specified table object.
ShowTotals	Gets or sets a value indicating whether the total row is visible.
Slicers	Gets a list of the table slicers associated with an ITable.
Sort	Gets the sort object.
TableColumns	Gets a ITableColumns collection that represents all the columns in a ITable object.
TableRows	Gets a ITableRows collection that represents all the rows in a ITable object.
TableStyle	Gets the TableStyle indicates which style will be applied to this ITable.
TableStyleName	Gets the string value indicates which style will be applied to this ITable.
TotalsRowRange	Gets an IRange object representing the Total row, if any, from a specified table object.
Worksheet	Gets the worksheet object for the specified table.

Methods

Name	Description
Delete(bool)	Deletes this ITable from the worksheet.
Resize(IRange)	Resizes the boundary of this table over a new range. No cells are inserted or moved.
Resize(int, int, int)	Resizes the boundary of this table over a new range. No cells are inserted or moved.
Resize(string)	Resizes the boundary of this table over a new range. No cells are inserted or moved.
Unlist()	Convert data of this ITable into normal cells and deletes it from the worksheet.