Excel |
The ExcelTablesCollection type exposes the following members.
| Name | Description | |
|---|---|---|
| Add | 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. | |
| GetEnumerator | Gets the collection enumerator | |
| RemoveAt | Removes the table at the specified index. The cells of the table keep their values; the table style and the filter buttons are removed. |