This new feature from Spotfire 14 but in Spotfire Analyst API so IronPython can automate the export to Excel while retaining formatting. I currently kick of cache refresh via SOAP API when we have data updates to our database. It would be great if i can add automated ironpython scripts that kick off within the analysis when the data has refreshed to export to excel. Our IronPython adds color formatting and column sorting to dynamic data columns so we need to export visualisations as we see it in Spotfire.
Spotfire 14 has a new addition to share insights, results, and data in pretty formatted spreadsheets with Spotfire. Excel export. Tables, cross tables, summary tables, and graphical tables are exported WYSIWYG, preserving layout, styling, and formatting. No more manual formatting to make the spreadsheet look like the table in Spotfire, export and easily share with your colleagues, and you're done.