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
Hi, do you know if it is possible to script Jedox Web Actions, such as Download or Upload, entirely in a Macro? I would like to trigger a Download with a Macro and not a Web Action that is attached to a Button.
Hi Dominik,
Yes it is possible. Right click on the button and assign a macro. I am attaching one mode for Upload here. Please follow the procedure written in the document there in order to configure it on your instance.