Producing a Report in Microsoft Excel Format

You can export your report output to several different Microsoft Excel spreadsheet software formats.

Excel and Excel data formats render report output in native Excel XML format, also known as XLSX. This format provides a fast way to deliver native Excel spreadsheets to Microsoft Excel 2002, Microsoft Excel 2003, and Microsoft Excel 2007. Users of Microsoft Excel 2002 and Microsoft Excel 2003 must install the Microsoft Office Compatibility Pack, which provides file open and save capabilities for the new format.

Excel provides fully formatted reports for use in Microsoft Excel version 2007.

The output is similar to other Excel formats, with the following exceptions:

  • Charts are rendered as static images.
  • Row height can change in the rendered report to achieve greater fidelity.
  • Column widths that are explicitly specified in reports are ignored in Microsoft Excel 2007.
  • Merged cells are used to improve the appearance of reports.
  • The default size of worksheets is 65 536 rows by 256 columns.

    Your IBM® Cognos administrator can enable larger worksheets and change the maximum number of rows in a worksheet, up to a maximum of 16,384 columns by 1,048,576 rows, by using advanced server properties. For more information, see the IBM Cognos Analytics with Watson Administration and Security Guide.

Excel data provides data for use in Microsoft Excel version 2007. These reports only contain minimal formatting. Default data formatting is applied to the data based on data type and assumes that each column has a single data type.

The output is similar to other Excel formats, with the following exceptions:

  • The generated output includes only the first list query in the report. Other queries are ignored. If a report contains only multi-dimensional queries for crosstabs or charts, an error message is displayed when the report runs.
  • Nested frames and master-detail links are not supported.
  • Cells in the Microsoft Excel file have a default width and height. You must adjust the column width and height if the data is larger than the default size.
  • Style specifications are not rendered, including color, background color, and fonts.
  • Borders are not rendered.
  • User-specified data formatting in the report specification are not applied, including exception highlighting and color rules for negative numbers.