2020.2

Table Of Contents
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 computer.
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.
Page 492