GrapeCity.Documents.Excel.ITable.ExpandBoundRows

ExpandBoundRows Property

ExpandBoundRows

Gets or sets whether the table can add or delete entire worksheet rows during data binding.

This property indicates whether the table is allowed to expand or shrink by whole rows when its bound data changes.

Declaration

bool ExpandBoundRows { get; set; }

Property ExpandBoundRows As Boolean

Examples

worksheet.Range["A1:B3"].Value = new object[,] {
    {"Name", "Value"},
    {"Item A", 100},
    {"Item B", 200}
};
ITable table = worksheet.Tables.Add(worksheet.Range["A1:B3"], true);
table.ExpandBoundRows = true;
bool expandBoundRows = table.ExpandBoundRows;