IXlSheet.Tables Property
Provides access to the read-only collection of tables contained in the worksheet.
Namespace: DevExpress.Export.Xl
Assembly: DevExpress.Printing.v20.2.Core.dll
NuGet Packages: DevExpress.Printing.Core, DevExpress.WindowsDesktop.Printing.Core
Declaration
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.