GrapeCity.Documents.Excel.ITableColumn.DataBodyRange

DataBodyRange Property

DataBodyRange

Gets the IRange that represents the data body cells of this table column.

The returned range includes only the data rows in the column and excludes the header cell and totals cell.

Declaration

IRange DataBodyRange { get; }

ReadOnly Property DataBodyRange As IRange

Examples

worksheet.Range["A1:B3"].Value = new object[,] {
    {"Product", "Amount"},
    {"Apple", 100},
    {"Pear", 200}
};
ITable table = worksheet.Tables.Add(worksheet.Range["A1:B3"], true);
ITableColumn tableColumn = table.Columns[1];
IRange dataBodyRange = tableColumn.DataBodyRange;
dataBodyRange.Value = new object[,] {{120}, {220}};