GrapeCity.Documents.Excel.ITable.DataRange

DataRange Property

DataRange

Gets the IRange that represents the data area of the table.

The returned range contains the table rows between the header row and the insert row. It does not include the header row.

Declaration

IRange DataRange { get; }

ReadOnly Property DataRange As IRange

Examples

worksheet.Range["A1:B3"].Value = new object[,] {
    {"Name", "Value"},
    {"Apple", 100},
    {"Pear", 200}
};
ITable table = worksheet.Tables.Add(worksheet.Range["A1:B3"], true);
IRange dataRange = table.DataRange;