Export a Report in Excel Format

When you export a report to Excel, you can choose the version of Excel to use. Reports can be rendered in Excel 2002/2003, or Excel 2007 and higher. Reports exported to Excel 2002/2003 are in .xls format, whereas reports exported to Excel 2007 and higher are in .xlsx format.

Impromptu provides full rendering of report objects including images, static charts, text frames, and summaries. To render these reports successfully, you can employ certain strategies in your Impromptu reports. For example, you can

• add worksheet names

• set worksheet order

• use data scoping to assist with navigation

• align objects

• eliminate overlapping objects

• avoid splitting reports over multiple worksheets

• group objects to export them to the same worksheet

• export summaries as live formulas

Steps

1. Open a report.

2. From the Report menu, click Excel, and in the Version box, click Excel 2002/2003 or Excel 2007 and higher.

3. Click the check boxes next to the objects you want to include:

   • images

   • static charts

   • text frames

   • summary expressions

4. Click OK.

5. From the File menu, click Save As, and save the report as Excel with Format (*.XLS) or Excel with Format (*.XLSX).

The page breaks you add in Impromptu control the page breaks in the Excel report output. For more information about inserting page breaks, see the Impromptu online help.

If the size of a column is less than 1, the column is rendered with a width of 1 pixel in Excel.

If you export reports without images, static charts, text frames, and summary expressions, you still retain the following:

• list frames and crosstabs

• data formatting

• header and footer information

• column titles

Note that the Excel column width of 255 may not be large enough to display the data in your report. If so, change the column width manually within Excel. For more information, check the Excel online help for the topic, "Change column width".

If an Impromptu Report contains a header or footer with localized information, for example German text, the header or footer information is not be translated when the report is saved as Excel. This is a Microsoft Excel issue.

You should also note that when saving a report as Excel with format, IBM Cognos Impromptu and Impromptu Web Reports exports the full numeric precision. However, when you manually enter a value, the number is rounded and truncated after the 15th digit. The remaining digits are replaced with zeros.

To avoid this problem, convert the value from a number to a string using the Microsoft Excel number-to-string function.