Exporting a Grid Design to Excel

You can export a report's grid design information as it appears while viewing the grid in Oracle Hyperion Financial Reporting Web Studio to Excel.

To export a grid design to an Excel spreadsheet:

  1. With the report containing the grid open, click the top node in the Report Designer to display the report design canvas, and then click the grid so that it is highlighted in red.
  2. Select File, and then Export Design to Excel, or click Export to Excel button.
  3. Do one of the following:
    • Select Open with to open the grid in Excel.

      If you get an error or warning in Excel when attempting to open the file, you can ignore the error and proceed to open the file. This is a security feature in Excel.

    • Select Save, to save the grid design as an .xls file, where you can then open it in Excel later.