Rockwell Automation 1492-PRINT110_PRINT220 ClearTools User Manual - Manual (Page 135)

User Manual Importing files

129

You can remove the column break by clicking on the arrow again.
Importing an Excel file
When importing an Excel file (*.xls) you can select the worksheet and import range in this step.
Data is only imported from one worksheet
Only content is imported - no formats
Step 6: Options
Set further import options:

Filter: simple filter rule
The selected column is imported filtered using the selected criteria

Repetitions: The column contents of the selected column are repeated several times.

Extended filter
Further filter rules that can be applied to several columns.