IXlSheet.Tables Property

Provides access to the read-only collection of tables contained in the worksheet.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v21.2.Core.dll

Declaration

IXlTableCollection Tables { get; }

Property Value

Type Description
IXlTableCollection

An IXlTableCollection object specifying the worksheet’s collection of tables.

Remarks

Use the Tables property to get access to the IXlTableCollection collection, which stores all tables generated in a worksheet. You can access an individual table represented by the IXlTable object by its name or index from the collection.

The IXlTable object’s properties allow you to get information about the table: for example, its name (IXlTable.Name) or location in the worksheet (IXlTable.Range). You can also change the table appearance by applying a table style (IXlTable.Style) or disable the filtering functionality for the table (IXlTable.HasAutoFilter).

To format a cell range containing related data as a table, use the IXlRow.BeginTable - IXlRow.EndTable method pair. For details on how to generate a table and adjust its properties, refer to the Tables section for examples.

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the Tables property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

See Also