Converting Reports to Excel Tables

How to:

You can use the Excel Tables feature to utilize the Excel functionality and apply it to the reports created in WebFOCUS Designer. You do that by enabling the XLSX format and configuring your output settings.

Procedure: How to Convert a Report to an Excel Table

  1. Create a report as described in Creating Reports.
  2. In the Output Format menu above the canvas, select XLSX.
  3. In the Settings/Format pane, click Format, and select Output Settings from the drop-down menu.
  4. In the XLSX Features section, select the Enable Excel Tables checkbox and, optionally, edit the name field below to give your Excel table a unique identifier.

    An example of the fully configured Format pane for an Excel-optimized report is shown in the following image.

  5. Save your report and exit WebFOCUS Designer.
  6. On the WebFOCUS Hub, right-click your newly-created report, and click Run.

    The Excel file with the report automatically downloads to your computer. An example of the Excel version of the report created in WebFOCUS Designer is shown in the following image.

    You can now use Excel features to modify and enhance your report.