Remove duplicate worksheet rows
xlide_remove_duplicatesRemove duplicate rows in an Excel sheet by comparing chosen columns, keeping the first occurrence, then save the workbook. Confirm with the user first—deletion cannot be undone.
Instructions
Removes later rows with the same values in the chosen columns, keeping the first row of each set, and saves the workbook. A range inside a table acts on the table and shrinks it. An empty columns list compares every column. This deletes data and cannot be undone in the file: ask the user before calling it. Works on .xlsx, .xlsm and .xlam.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet | Yes | Worksheet name, matched without case. | |
| header | No | For a plain range: keep its first row. | |
| columns | No | Column letters to compare; omit for all. | |
| file_path | Yes | Absolute path to the Excel file. | |
| cell_range | Yes | Range such as A1:D20. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||