GrapeCity.Documents.Excel.ITable.HeaderRange

HeaderRange Property

HeaderRange

Gets the IRange object that represents the header row of the table.

Use this property to access the cells that contain the table column headers.

Declaration

IRange HeaderRange { get; }

ReadOnly Property HeaderRange 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);
IRange headerRange = table.HeaderRange;
headerRange[0, 1].Value = "Total";