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:
return array
(
array(‘actn’, “exportToXLSX”,2),
);
The final output looks like this:
The whole project can be downloaded from here.
Is it possible to give the downloaded file a name? For example, if i want to include a timestamp in the filename.
Hi Verena,
I am afraid that there is no way to rename it via this particular example. However, you can try using action buttons in that case. They are providing the possibility to rename the file before downloading.
Here: https://knowledgebase.jedox.com/jedox/jedox-web/actions-export-report.htm