OBIEE 11g|12c: Export Current Page Or Entire Dashboard Page To Excel Throwing "file is corrupt"

(Doc ID 1944111.1)

Last updated on AUGUST 02, 2017

Applies to:

Business Intelligence Server Enterprise Edition - Version 11.1.1.7.170718 and later
Information in this document applies to any platform.

Symptoms

You have a dashboard page that has a special character "&" in the Page name, when exporting this Dashboard page or the entire Dashboard into Excel, the Exported XLSX file fails to open in MS Excel, with the error:

Excel found unreadable content in
'RCI_Financials_support_withAmpersand.xlsx'. Do you want to recover the
contents of this workbook? If you trust the source of this workbook, click Yes.

Clicking Yes shows the message:

The workbook cannot be opened or repaired by Microsoft Excel because it is corrupt.

 

 

 

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms