Click or drag to resize

ExcelTable Class

Represents an Excel table (a list object): a range of cells with a header row, a table style, filter buttons in the header row and an optional totals row. Create it with Add(String, ExcelRange) of Tables. Excel tables are available only in the Excel 2007+ (.xlsx) format.
Inheritance Hierarchy
SystemObject
  ExpertXls.ExcelLibExcelTable

Namespace: ExpertXls.ExcelLib
Assembly: expertxls (in expertxls.dll) Version: 10.0.0
Syntax
public class ExcelTable

The ExcelTable type exposes the following members.

Properties
 NameDescription
Public propertyColumns Gets the columns of the table.
Public propertyDataRange Gets the data rows of the table, without the header row and the totals row.
Public propertyName Gets or sets the name of the table. The name is used in formulas with structured references, for example =SUM(Sales[Amount]). It must start with a letter or an underscore, cannot contain spaces and must be unique in the workbook.
Public propertyRange Gets the range of the table, including the header row and the totals row.
Public propertyShowBandedColumns Gets or sets a value indicating if the columns of the table are banded (alternate column colors of the table style). The default value is false.
Public propertyShowBandedRows Gets or sets a value indicating if the rows of the table are banded (alternate row colors of the table style). The default value is true.
Public propertyShowFilterButtons Gets or sets a value indicating if the header row shows the filter buttons. The default value is true.
Public propertyShowFirstColumn Gets or sets a value indicating if the first column has the special formatting of the table style. The default value is false.
Public propertyShowLastColumn Gets or sets a value indicating if the last column has the special formatting of the table style. The default value is false.
Public propertyShowTotalsRow Gets or sets a value indicating if the table has a totals row below the data. Showing the totals row adds a row to the table and moves the cells below the table, in its columns, one row down. Set the calculation of each column with TotalsCalculation. The default value is false.
Public propertyStyle Gets or sets the built-in style of the table. The default style of a new table is Medium2.
Public propertyWorksheet Gets the worksheet of this table.
Top
See Also