Change the Default File Extension for Excel 2002 Spreadsheets

You can change the default file extension to .xls by setting the RSVP.FILE.EXTENSION.XLS parameter to true.

By default, Excel 2002 spreadsheets sent by e-mail are created in Excel Multipart HTML format with the .mht file extension.

Setting RSVP.FILE.EXTENSION.XLS to true does not change the file content. The content remains as Excel Multipart HTML.

Procedure

  1. Start IBM® Cognos® Connection.
  2. In the upper-right corner, click Launch, IBM Cognos Administration.
  3. On the Configuration tab, click Dispatchers and Services.
  4. In the Configuration pane, under Name, click the dispatcher to configure.
  5. With the dispatcher selected, on the toolbar in the upper-right corner, click Set Properties.
  6. Click the Settings tab.
  7. For the Environment category, next to Advanced settings, click the Edit link.
  8. Select the Override the settings acquired from the parent entry check box.
  9. In the Parameter column, type RSVP.FILE.EXTENSION.XLS.
  10. In the Value column, type true.
  11. Click OK twice.
  12. Repeat steps 5 to 11 for ReportService.
  13. Restart the server.
Parent topic: Customizing the Functionality of IBM Cognos Software