Back to Devexpress

Table Members

officefileapi-devexpress-dot-spreadsheet-dot-table-dot-underscore-members.md

latest3.2 KB
Original Source

Table Members

A table in a worksheet.

Properties

NameDescription
AutoFilterProvides access to an object that contains options to filter data in a table.
ColumnsProvides access to the collection of table columns.
CommentGets or sets a string that provides additional information about the table.
DataRangeReturns the cell range that contains table data.
HeaderRowRangeReturns the cell range that contains the header row of the table.
NameGets or sets the table name.
RangeSpecifies the cell range that contains the entire table.
RowsProvides access to the collection of table rows.
ShowHeadersGets or sets whether the table header row is visible.
ShowTableStyleColumnStripesIndicates whether alternate shading should be applied to the table columns.
ShowTableStyleFirstColumnIndicates whether special formatting should be applied to the first column of the table.
ShowTableStyleLastColumnIndicates whether special formatting should be applied to the last column of the table.
ShowTableStyleRowStripesIndicates whether alternate shading should be applied to the table rows.
ShowTotalsSpecifies whether the table total row is visible.
StyleGets or sets the style applied to the table.
TotalRowRangeReturns the cell range that contains the total row of the table.

Methods

NameDescription
ConvertToRange()Converts the table to a regular range of cells without losing data and formatting.
Delete()Removes the table from the worksheet.
GetDataSource()Creates the data source from the worksheet table using the specified options.
GetDataSource(RangeDataSourceOptions)Creates the data source from the worksheet table using the specified options.

See Also

Table Interface

DevExpress.Spreadsheet Namespace