Excel Content for Desktop Publishing

Add a Desktop Publishing Tag to an Excel Object

In CDM, you can add tags to specific content in an Excel object for desktop publishing applications such as Adobe™ InDesign.

When you tag an Excel object, you can use styles that were created in CDM or styles that were imported into CDM from InDesign. To do so:

1. Open the report that you want to work with.
2. Check out the Excel object where you want to add a desktop publishing tag.
3. Select the content that you want to apply a tag to. You can select one cell or multiple contiguous cells, and you can also tag pictures, graphs, and ranges. You cannot mix different kinds of content in a single tag or tag content that was already tagged.
4. Click Add Tag > New Tag in the Report Object tab on the ribbon. In the window that opens, a name is automatically assigned to the tag that you are creating and the next consecutive number after the previously created tag is used. If you prefer, you can change the name. Select a style from the list. The list includes styles that were created in CDM and styles that were imported into this report from an InDesign import file.
5. Click OK.
6. Click Save.
7. Check in the Excel object.
8. If a message indicates that some items from the Tag Explorer might be out of date, click Refresh Now.

The order of tags in the XML file that you will eventually generate will be the same as the order of the objects within the report. The order of tags in a report object are based on their placement in the report object.

Use of Styles in an Excel Table

Tagging a full table in Excel, instead of individual cells and using proper Excel cell styles, gives the desired result faster and tag maintenance is kept to a minimum. When tagging an Excel range you must assign a name to the tag being created and choose a style from the list defined in the Desktop Publishing Styles list (Administration > Resources > Desktop Publishing Styles). The cell tags automatically use the Excel cell style name.

Consider this sample Excel table (note that the name of the style is placed in the cell as content). When the range below is tagged, a tag name of "TableTagCreatedManually" and the "Normal" is assigned:

The generated desktop publishing content is:

/

Note that the cell style is used as the name of the tag for each cell.