diablo908 Posted February 27 Share Posted February 27 Is it possible to export a crosstab visualization to CSV? When I try to export a crosstab viz, the only option I get to export is tab delimited. If I try to export a table viz, I get a whole host of options including CSV and XSLX. Link to comment Share on other sites More sharing options...
David Boot-Olazabal Posted February 28 Share Posted February 28 Hello Diablo908, In the latest Spotfire version, you can export a crosstable as an .xlsx file. If you need to export a crosstable as a .csv file, you can use IronPython (explained in the article below) to accomplish that: Kind regards, David Link to comment Share on other sites More sharing options...
diablo908 Posted February 28 Author Share Posted February 28 Hi David, Which version specifically are you referring to that adds the functionality? Thanks Link to comment Share on other sites More sharing options...
David Boot-Olazabal Posted February 29 Share Posted February 29 Hi Diablo908, I'm referring to the Spotfire 14.0.x LTS versions and above. You can find it in our what's new page https://community.spotfire.com/articles/spotfire/what-s-new-in-spotfire-14-0-lts/, in the "And More >> Visual Analytics" part. Kind regards, David Link to comment Share on other sites More sharing options...
Neeta Joji Posted April 30 Share Posted April 30 On 2/28/2024 at 2:57 AM, David Boot-Olazabal said: Hello Diablo908, In the latest Spotfire version, you can export a crosstable as an .xlsx file. If you need to export a crosstable as a .csv file, you can use IronPython (explained in the article below) to accomplish that: Kind regards, David Hi David, Is there an IronPython script to export a Cross Table Visual to .xlsx format. I can export it to .xls or .csv, but unfortunately not able to export to .xlsx via IronPython. Wondering if its a limitation. Thx Link to comment Share on other sites More sharing options...
David Boot-Olazabal Posted May 2 Share Posted May 2 Hi Neeta, You may want to have a look at these solutions, depending on where the export functionality is needed (from Analyst, from web or both). Note that you probably need to tweak the iron python code, as you need to reference a crosstable visualization. https://spotfired.blogspot.com/2014/02/exporting-to-excel-from-client-only.html https://spotfired.blogspot.com/2014/02/exporting-to-excel-web-player.html. Furthermore, as referenced in the below topic as well, there are lots of iron python code snippets that provide input for export functionality: Kind regards, David Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now