Setting up an Excel template for object packing

In Teamcenter structures, two or more identical elements can be grouped, or packed, in a single level. To preserve that packing in one row of the Excel output file, set up the export template as follows:

1. For the template's Excel Template Rules property value, choose Apply Packing.
2. In the corresponding Level key field of the rule table, enter the level number as the argument — e.g. enter {%L-2} for packed elements that are direct children of the top-level element.

Caution:

• Packing applies only if you export all elements in the structure. If you select individual elements, each is exported to a separate row in the output file.
• Cell formatting may be processed as content, which in turn may prevent the desired data placement. Siemens Digital Industries Software recommends not applying any formatting to a cell where you intend to include one object on the same row as another object (apply packing).
• A cell that contains a space is considered empty. To keep a cell from being overwritten, enter a visible character in the cell.