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.
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:
The final output looks like this:
The whole project can be downloaded from here.