UiPath Documentation
activities
latest
false
Productivity activities

DeleteRows

Delete one or several rows from a specified position in a workbook range.

Delete one or several rows from a specified position in a workbook range.

Namespace: UiPath.MicrosoftOffice365.Activities.Api

Assembly: UiPath.MicrosoftOffice365.Activities.Api (in UiPath.MicrosoftOffice365.Activities.Api.dll)

Overloads​

OverloadDescription
DeleteRows(IWorkbook, IRange, IEnumerable<Int32>, RowsDeleteMode)Delete one or several rows from a specified position in a workbook range. When you delete a row, the cells below are shifted up.
DeleteRows(IWorkbook, IRange, String, RowsDeleteMode)Delete one or several rows from a specified position in a workbook range. When you delete a row, the cells below are shifted up.

DeleteRows(IWorkbook, IRange, IEnumerable<Int32>, RowsDeleteMode)​

Delete one or several rows from a specified position in a workbook range. When you delete a row, the cells below are shifted up.

voidDeleteRows(
	IWorkbookworkbook,
	IRangerange,
	IEnumerable<int> rowIndices,
	RowsDeleteModedeleteMode = RowsDeleteMode.Delete
)
voidDeleteRows(
	IWorkbookworkbook,
	IRangerange,
	IEnumerable<int> rowIndices,
	RowsDeleteModedeleteMode = RowsDeleteMode.Delete
)

workbook IWorkbook : The target workbook to delete rows from.

range IRange : The range to delete rows from.

rowIndices IEnumerable<Int32> : Specify the row indices to delete.

deleteMode RowsDeleteMode (Optional) : Indicates the delete mode.

DeleteRows(IWorkbook, IRange, String, RowsDeleteMode)​

Delete one or several rows from a specified position in a workbook range. When you delete a row, the cells below are shifted up.

void DeleteRows(
	IWorkbook workbook,
	IRange range,
	string rows,
	RowsDeleteMode deleteMode = RowsDeleteMode.Delete
)
void DeleteRows(
	IWorkbook workbook,
	IRange range,
	string rows,
	RowsDeleteMode deleteMode = RowsDeleteMode.Delete
)

workbook IWorkbook : The target workbook to delete rows from.

range IRange : The range to delete rows from.

row String : Specify the row indices to delete, or their range, separated by commas, e.g. 0, 2, 5-7.

deleteMode RowsDeleteMode (Optional) : Indicates the delete mode.

Was this page helpful?

Connect

Need help? Support(opens in new window)

Want to learn? UiPath Academy(opens in new window)

Have questions? UiPath Forum(opens in new window)

Stay updated