Click or drag to resize

ExcelTablesCollection Methods

The ExcelTablesCollection type exposes the following members.

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