Export Data from Dashboards

Click here to download the add-on.

You can install this Add-on in Dashboards 4.0 via the ‘Add-On Manager’. After this Add-on is installed, you will find a new component in folder Add-Ons called Export Data.

Dragging this component to your canvas will display a button:

Selecting this button will give you an option to set the following properties:

Based on the properties you have set in Design Time, the button will either export the data to your clipboard, to MS Excel or do both.

In the behavior tab we can maintain the dynamic visibility of the item. The appearance tab have the ability to set the message which the dashboard will pass when download is successful and gives you an option to set the file name.

Export to Excel

If the button is clicked during runtime and the flag Export to Excel was set in the properties, the user is asked for a location to store the Excel file. It is automatically called Export.xls but can be renamed.

The data in the MS Excel range that was selected in the Data Set property will be exported to Excel.

Export to Clipboard

If the button is clicked during runtime and the flag Export to Clipboard was set in the properties, the data in the MS Excel range that was selected in the Data Set property will be copied to the clipboard. After that a message is shown to the user indicating that the action is completed:

Using the default Paste functionality the data can be made visible in another application: