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:
images
static charts
text frames
summary expressions
Click OK.
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.