OBIEE 11g|12c: Export Current Page Or Entire Dashboard Page To Excel Throwing "file is corrupt"
Last updated on AUGUST 02, 2017
Applies to:Business Intelligence Server Enterprise Edition - Version 220.127.116.11.170718 and later
Information in this document applies to any platform.
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.
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