Here is one quick way to download a file as an Excel.

In normal conditions, Jedox offers two possibilities to Export to Excel:

  • XLSX Snapshot
  • XLSX OLAP Snapshot

More about differences can be found here.

Download Excel

Sometimes, we want to limit end users from seeing these buttons. That can be done in this way [see bellow] by clicking on report properties and unchecking Interface checkboxes.

Now, when the report does not contain anything related to Jedox bars we can install the macro for exporting.

The code behind the macro is very simple:

return array

  (

  array(‘actn’, “exportToXLSX”,2),

);

The final output looks like this:

Download Macro Excel

The whole project can be downloaded from here.