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
Open a report.
From the Report menu, click Excel, and in the Version box, click Excel 2002/2003 or Excel 2007 and higher.
Click the check boxes next to the objects you want to include:
From the File menu, click Save As, and save the report as Excel with Format (*.XLS) or Excel with Format (*.XLSX).
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
header and footer information
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.