GrapeCity.Documents.Excel.IWorksheet.Tables

Tables Property

Tables

Gets the collection of ITable objects in the worksheet.

Use the returned ITables collection to create, access, and manage tables defined on the current worksheet. The collection can be empty if the worksheet does not contain any tables.

Declaration

ITables Tables { get; }

ReadOnly Property Tables As ITables

Examples

worksheet.Range["A1:B3"].Value = new object[,] {
    {"Name", "Value"},
    {"Tea", 100},
    {"Coffee", 200}
};
ITables tables = worksheet.Tables;
ITable salesTable = tables.Add(worksheet.Range["A1:B3"], true);
ITable firstTable = tables[0];