Export data tables (visualizations) by a dynamic Command Button
How to export any data table on your report with Iron Python? (yes, even tables with data limitation)
Note this tool will allow you to:
- Export any data table on the report as data visualization. It means, if you decide to limite the data and/or to show only some columns of the data table, the file will be export as it.
- Choose the export folder on your computer by a document property (« C:\\ »…)
- Customize the name of the export file by a document property (« _2017 », « _ByMe »…)
You must pay attention to select your input for the selected script as below (« Viz1 », « Viz2 » and « Viz3 »).
The objective is to give to each export the data visualization concerned : Viz3.As[TablePlot] is concerning the Viz3 selected as input. Then, as you can see on the script above, x and y are defined as the ReportingDate and ReportingFolder’ document properties. Both can be modify directly in the analysis by input fields (HTML).
Important information: This tool works only in Spotfire Desktop, not in the web version!