Skip to Main Content
Spotfire Ideas Portal
5 Not supported for the current status
Status Future Consideration
Product Spotfire
Categories API
Created by Guest
Created on Oct 1, 2024
Merged idea
This idea has been merged into another idea. To comment or vote on this idea, please visit TS-I-9899 please expose API to export visualization to excel file.

IronPython functionality to Share formatted table visualizations as Excel spreadsheets Merged

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.

1 MERGED

Add API for Cross Table and Table Visualizations for context menu "Export-->Visualization to Microsoft Excel"

Merged
API callable in IronPython, Text Area Action Control, Automation Services, or other code to more broadly integrate implemented feature in version 14+ https://ideas.spotfire.com/ideas/SPF-I-42
9 months ago in Spotfire / API 0 Future Consideration