Remove Row Duplicates

A group of actions: Excel

The action allows you to remove duplicate rows from a sheet in an Excel document.

Settings

Property	Description	Type	Filling example	Mandatory field
Parameters
Context	Action context for working with an Excel document	Robin.Excel	Excel context	Yes
Start column name	The name of the column from which to search for duplicates.	Robin.String		No
Start column index	The index of the column from which to search for duplicates.	Robin.Numeric		No
Start line	Line number, starting from which the search for duplicates will be performed.	Robin.Numeric		No
End column name	The name of the column up to which duplicates will be searched.	Robin.String		No
End column index	Index of the column up to which to search for duplicates.	Robin.Numeric		No
End row	Line number up to which duplicates will be searched.	Robin.Numeric		No
Skip empty	If the value is «true», then empty values will not be duplicates.	Robin.Boolean	true	No
Skip hiden	If the value is «true», then hidden cells will not be taken into account.	Robin.Boolean	true	No
Consider merged cells	If the value is «true», then if duplicates are found in the combined rows, columns, the action will return an error.	Robin.Boolean	true	No