UiPath Documentation
activities
latest
false
Productivity activities

DeleteRows

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

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​

OverloadDescription
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
)
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
)
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, for example, 0, 2, 5-7.

deleteMode RowsDeleteMode : 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