8.5

Lookup in Microsoft® Excel® Documents
The Lookup in Microsoft® Excel® Documents action task is used to complement your job file's metadata
by retrieving data from a Microsoft® Excel® spreadsheet on your system.The data retrieved is based on
existing data in your metadata, and it will either be added to your metadata or will append or replace your
existing metadata if it exists.
Fields on any level (Page, Datapage, Document, Group, Job)can be used, and the result field will be added
on the same level as the lookup field.
Note
This task will automatically "loop" through the metadata and repeat its action for each of your
metadata's data pages. This task should not be placed after a Metadata Sequencer task, otherwise it
will run as many times as there are metadata sequences, which will result in decreased performance.
Input
Any compatible data file, requires metadata to be present.
Processing
The task parses each level of the metadata and, for each field of the specified name it finds, a lookup is
made. If a field of the same name appears on multiple levels, the lookup will happen for all fields, on all
levels, individually.
Output
The original data file is unchanged. Metadata is updated according to the specified criteria.
Properties
General Tab
l Excel group
l Excel workbook:The full path and file name of a Microsoft® Excel® workbook (.xls or .xslx file).
You can use the Browse button on the right to browse to the file on your computer.