[]
Deletes the cells in this table row and shifts the cells below the deleted row upward.
Use this method to remove a data row from a ITable. The deleted row is removed from the table's data rows, and the remaining cells below it are shifted up.
void Delete()
Sub Delete()
worksheet.Range["A1:B3"].Value = new object[,] {
{"Name", "Value"},
{"Apple", 100},
{"Orange", 200}
};
ITable table = worksheet.Tables.Add(worksheet.Range["A1:B3"], true);
ITableRow row = table.Rows[0];
row.Delete();