Cells.DeleteRows

DeleteRows(int, int)

Deletes multiple 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


DeleteRows(int, int, DeleteOptions)

Deletes multiple rows in the worksheet.

public bool DeleteRows(int rowIndex, int totalRows, DeleteOptions options)
ParameterTypeDescription
rowIndexInt32Index of the first row to be deleted.
totalRowsInt32Count of rows to be deleted.
optionsDeleteOptionsOptions for the deleting operation

See Also