Jump to content
We've recently updated our Privacy Statement, available here. ×

Export Crosstab to CSV


diablo908

Recommended Posts

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

  • 2 months later...
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

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

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...