Filter Columns

Object for filtering Excel worksheet columns.

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 spreadsheet

Column

Column that will be filtered

Filter Criteria

Option to enter the criteria for the filter

Example

To filter columns 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 "Filter Columns" object from the "Excel" menu, select the main object defined when opening Excel and enter the column. Finally, enter the criteria for the filter (type and click "Enter")

Last updated

Was this helpful?