Skip to main content

IXlSheet.Tables Property

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

Namespace: DevExpress.Export.Xl

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

NuGet Packages: DevExpress.Printing.Core, DevExpress.Win.Dashboard.Design


IXlTableCollection Tables { get; }

Property Value

Type Description

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


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.

See Also