Remove Duplicate Cells

Object to remove duplicate cells in an Excel file.

Settings

This object depends on the use of the "New Excel" or "Open Excel" object to work.

Field	Descriptive
Title	Object title
Select Main Object	Option to select an Excel spreadsheets
Starting Column	Initial column to be considered
Final Column	Final column to be considered

Example

In order to remove duplicate cells in an Excel spreadsheet file you need to follow a few steps:

1 - Select the "Open Excel" object from the "Excel" menu and drag it to your working area.

• First you must define a unique name for the object in the "Object Identifier Name" field, inform the complete directory containing the name and the extension of the file and then set a password if it is required.

2 - Then select the "Remove Duplicate Cells" object in the "Excel" menu, the main object defined in the Excel file opening and then inform the target columns and rows.