Setting output properties for Microsoft Excel documents

You can set output properties, such as a path, for your Microsoft Excel output documents.

1. In the Launcher, expand Output, right-click the Output: Excel, and select Configure Output.
2. In the Configure Excel Output window, enter the following details:
   1. Path: Type a path with a file extension or click Browse to select the location for the output.
      You can edit the path to be a relative path from the document specification.
      For example: ..\output\sampleOutput.xlsx
   2. Sheet name: Enter the name that you want for the output spreadsheet. If you have more than one sheet, use document breaks to name subsequent sheets.
   3. Style sheet: Type or click Browse to specify any Microsoft Excel style sheet (.xls or .xlsm or .xlt or .xltm).
      All of these file types are handled the same way when generating document-style reports with IBM Engineering Lifecycle Optimization - Publishing (PUB).
   4. Macro name: Enter the macro to use in the generated Microsoft Excel output.
   5. Authentication: Select the authentication type that applies to accessing your style sheet.
      You can select one of the following authentication types:

      • Auto
      • Basic
      • Form
      • OAuth
      • OAuth-OSLC
      • SSL Certificate: If you choose SSL Certificate, click the + sign to add a certificate. In the Upload Certificate window, enter the certificate title, select the certificate, and click Upload. These certificates are private and user-specific.
      • Smart-Card: If you choose Smart-Card, select the certificate and enter the password.
      • Kerberos-SPNEGO
   6. User: Enter the user name, if the style sheet is in a secured location.
   7. Password: Enter the password, if the style sheet is in a secured location.
   8. Accept header: Enter an accept type for your style sheet.
      Examples:

      • image/jpeg
      • text/html
      • application/xml
      • */*
   9. Optional: Extra header: Enter an extra header for your style sheet.
   10. Bidirectional languages: Select this option to support languages that are read from right to left such as Arabic and Hebrew.
3. Click OK.

   For more information, see the following videos: