DeleteRows

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

Overload	Description
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
)

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
)

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.