Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How can I handle Excel files in Cognos BI?

April 26, 2017Bi Cognos Evanston Excel files Northwestern University NUIT Services Software

0

Posted

How can I handle Excel files in Cognos BI?

1 Answer

0

Posted

There are multiple versions of Excel output for backwards compatibility reasons: • CSV-raw data, no formatting, only possible with single Query reports. Delivered in email as .CSV file. • Excel 2000 Single Sheet – all report pages rendered to one Excel 2000 worksheet. Delivered in email as a .HTML file. • Excel 2002 – each report page is rendered to its own Excel 2002 worksheet, in a single Excel 2002 workbook. Delivered in email as a .MHT file. The Excel types are delivered via email as .HTML and .MHT files (supported Excel file types) instead of .XLS files for several reasons: • .XLS files are prone to macro viruses and as such are blocked by many email servers. • Using HTML/MHT files (supported Excel file types) permits users without Excel installed locally to view the files as well as those who have Excel available, thus potentially increasing a report’s target audience. Therefore, you should not be expecting .XLS files in the emails, instead you should be getting .HTML or .MHT fil