Remove row duplicates Version 1 (.Net)

Action group: Excel

Description

The action removes row duplicates from the sheet in an Excel-document.

Action icon

Settings of parameters

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

Special conditions of use

The robot will return an error if:

the row indexes are negative or 0. отрицательные индексы строк или 0.
the row name was input incorrectly.
"Consider merged cells" field is marked.

If the optional fields are not filled in, the search will be performed over the entire used area of the sheet.

If the search range will not be limited to columns, uniqueness is checked across all cells in the row.

Duplicates are searched for within the specified column range. If the value in the rows does not match outside the columns check range and matches inside the selected range, the row will be considered a duplicate and deleted by the robot.

Priority is given to the "Column name" field if both "Column name" and "Column index" fields are filled in.

If only the row/column start index is filled, the range will start with that index and end with the last row/column of the data area.

If only the row/column end index is filled, the range will start with the first row/column of the data area and end with that index.

The action does not delete merged rows. In the "Consider merged cells" checkbox the default value is "false", which means that if duplicates are found in merged rows, the action will skip them, not delete them. If "true" and duplicates are found, an error will be returned to let the user know that there are duplicates in them and we can't process them.

Example. Row 8 and 9-10 are identical, but 9-10 are merged. These rows are considered identical, but will not be deleted if "false" in the "Consider merged cells" field.