.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

Table Members

A table in a worksheet.

Properties

Name Description
AutoFilter

Provides access to an object that contains options to filter data in a table.

Columns

Provides access to the collection of table columns.

Comment

Gets or sets a string that provides additional information about the table.

DataRange

Gets the cell range that contains table data.

HeaderRowRange

Gets the cell range that contains the header row of the table.

Name

Gets or sets the table name.

Range

Gets or sets the range of cells that contains the table.

Rows

Provides access to the collection of table rows.

ShowHeaders

Gets or sets whether the table header row is visible.

ShowTableStyleColumnStripes

Indicates whether alternate shading should be applied to the table columns.

ShowTableStyleFirstColumn

Indicates whether special formatting should be applied to the first column of the table.

ShowTableStyleLastColumn

Indicates whether special formatting should be applied to the last column of the table.

ShowTableStyleRowStripes

Indicates whether alternate shading should be applied to the table rows.

ShowTotals

Gets or sets whether the table total row is visible.

Style

Gets or sets the style applied to the table.

TotalRowRange

Gets the cell range that contains the total row of the table.

Methods

Name Description
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