Remove Duplicates Activity
The Remove Duplicates activity enables the identification and deletion of redundant data entries within a specified Excel workbook. This activity allows users to target specific rows or columns to maintain data integrity and optimize spreadsheet performance.
| Field | Description | Requirement |
|---|---|---|
| Excel name | The reference name assigned to the Excel instance that is currently active. | Required |
| Sheet name | The name of the specific worksheet where the operation is performed. | Optional |
| Sheet index | The numerical index of the worksheet to be processed. | Optional |
| Row | The specific row index targeted for the duplicate removal process. | Optional |
| Column | The specific column index or letter targeted for the duplicate removal process. | Optional |
Action Types & Examples
Row-Based Removal
- Format: digit
- Example Result: "1"
Column-Based Removal
- Format: string or digit
- Example Result: "A"
Implementation Examples
Field Setup - Excel name: newExcel - Sheet name: Sheet1 - Sheet index: 5
Execution Parameters - Row: 1 - Column: A
Technical Notes
In Excel, row indexing begins at 1, while column indexing begins at 0. If the Sheet name field is left blank, the activity defaults to the first worksheet in the file. To isolate the operation to a specific row, the column field must remain empty; conversely, to isolate the operation to a specific column, the row field must remain empty.