2022.2

Microsoft® Excel® Documents action task will replace the value of this Metadata field with the cor-
responding customer email.
Use Case 2: Translate a list of line items descriptions into a given language
A PlanetPress Design document takes as input a transactional PDF file, and reproduces it exactly as it
enters. Metadata fields called ItemDesc are created, one for each line item description, at the data
page level. Each ItemDesc Metadata field is given the value of a line item description as found on a
region of the current data page. The line item descriptions appearing on the resulting page produced by
the design tool are custom data selections whose value come from the corresponding ItemDesc
Metadata fields. The Lookup in Microsoft® Excel® Documents action task updates the value of all
'ItemDesc' Metadata fields with their corresponding foreign language descriptions.
Input
Any compatible data file. This task 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.
Task 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 com-
puter.
l
Excel worksheet: The name of the worksheet you want to use. Once a workbook is open,
this drop-down will automatically list all the available worksheets.
l
Refresh button: If you have modified the original Microsoft® Excel® workbook to add a
sheet, click this button to refresh the list of worksheets.
l
Metadata group
l
Lookup Field: The name of the Metadata field that will be used to determine which row
should be returned. The Metadata field can be on any level.
Page 443