DeleteRows

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

Namespace: UiPath.Gsuite.Activities.API

Assembly: UiPath.Gsuite.Activities.API (in UiPath.Gsuite.Activities.API.dll)

Overloads

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

DeleteRows(ISpreadsheet, IRange, IEnumerable<Int32>, RowsDeleteMode)

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

void DeleteRows(
	ISpreadsheet spreadsheet,
	IRange range,
	IEnumerable<int> rowsIndexes,
	RowsDeleteMode deleteMode
)

spreadsheet ISpreadsheet

The target spreadsheet to delete rows from.

range IRange

The range to delete rows from.

rowsIndexes IEnumerable<Int32>

Specify the row indices to delete.

deleteMode RowsDeleteMode

Indicates the delete mode.

DeleteRows(ISpreadsheet, IRange, String, RowsDeleteMode)

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

void DeleteRows(
	ISpreadsheet spreadsheet,
	IRange range,
	string rows,
	RowsDeleteMode deleteMode
)

spreadsheet ISpreadsheet

The target spreadsheet to delete rows from.

range IRange

The range to delete rows from.

rows String

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

deleteMode RowsDeleteMode

Indicates the delete mode.