Click or drag to resize

ExcelTablesCollection Class

Represents the Excel tables of a worksheet, returned by Tables. Excel tables are available only in the Excel 2007+ (.xlsx) format; in an Excel 97-2003 workbook use AddAutoFilter for the filter buttons and cell styles for the formatting.
Inheritance Hierarchy
SystemObject
  ExpertXls.ExcelLibExcelTablesCollection

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

The ExcelTablesCollection type exposes the following members.

Properties
 NameDescription
Public propertyCount Gets the number of tables in the worksheet.
Public propertyItemInt32 Gets the table at the specified index.
Public propertyItemString Gets the table with the specified name, compared without regard to case, or null if the worksheet has no table with that name.
Top
Methods
 NameDescription
Public methodAdd Creates an Excel table from a range of cells. The first row of the range is the header row: its cells become the names of the table columns (empty header cells get the names Column1, Column2 ...). The table gets the Medium2 style, banded rows and filter buttons, like a new table in Excel. Excel tables are available only in the Excel 2007+ (.xlsx) format.
Public methodGetEnumerator Gets the collection enumerator
Public methodRemoveAt Removes the table at the specified index. The cells of the table keep their values; the table style and the filter buttons are removed.
Top
See Also