Microsoft Excel output properties reference for document specifications

The following output properties can be set in the Document Specification view under Output by selecting Output: Excel.

Type Value Description
Type Excel The type of output being generated. You cannot edit this field.
Driver Telelogic.Excel.Driver The name of the driver that generates the output. You cannot edit this field.
Path File path The path to save the generated output. You can edit the path to be a relative path from the document specification.
Sheet name Name of the sheet in the Excel output The name that you want for the worksheet in the output spreadsheet. If you have more than one sheet, use document breaks to name subsequent sheets.
Autofit column width true or false Whether the column width can adjust to the amount of content in cells.
Wrap text true or false

Wraps the text so it can appear on more than one line in a cell.

Max column width 0 to 255 characters The width of the widest column.
Span to parent width true or false

Sets a row to span across the whole table, merging all the cells in the row, which is useful for titles and notes. This approach can accommodate more text within the row.

Data in single cell true or false The default value is false, which displays the list items or text in multiple cells. Set to true to display the list items or text in a single cell.
Style sheet Filepath The path to the style sheet file. You can use the following Microsoft Excel document types as style sheets:
  • .xls
  • .xlsm
  • .xlt
  • .xltm
All of these file types are handled the same way when generating document-style reports with IBM Engineering Lifecycle Optimization - Publishing (PUB).
Macro name Name A subroutine that updates or formats the data in the Microsoft Excel output.
Image Placement In Cell or In Comment

Controls whether images in Microsoft Excel output are inserted directly into cells or displayed as comments that appear on hover.

Table Placement In Cell or In Comment

Controls whether tables in Microsoft Excel output are inserted directly into cells or displayed as comments that appear on hover.