Cells.DeleteRows

DeleteRows(int, int)

Deletes several rows.

public bool DeleteRows(int rowIndex, int totalRows)
ParameterTypeDescription
rowIndexInt32The first row index to be deleted.
totalRowsInt32Count of rows to be deleted.

Remarks

If the deleted range contains the top part(not whole) of the table(ListObject), the ranged could not be deleted and nothing will be done. It works in the same way with MS Excel.

See Also


DeleteRows(int, int, bool)

Deletes multiple rows in the worksheet.

public bool DeleteRows(int rowIndex, int totalRows, bool updateReference)
ParameterTypeDescription
rowIndexInt32Index of the first row to be deleted.
totalRowsInt32Count of rows to be deleted.
updateReferenceBooleanIndicates whether update references in other worksheets.

See Also