How can I add a button and export the cross table data from a report to excel

[vibin m]

Hi All,

 

Attached the file.

I wanted to add a button to this cross table and export the data to an excel file.

Kindly help.

Thank you,

Vibin.

[Sean Riley]

You can create a Text Area, and insert an Action Control which executes an IronPython script. Here is a sample script to save a cross table to an Excel .xls file (with prompt):

 

import System

from System.IO import FileStream, FileMode

from Spotfire.Dxp.Application.Visuals import TablePlot

from Spotfire.Dxp.Data.Export import DataWriterTypeIdentifiers

import clr

clr.AddReference("System.Windows.Forms")

 

from System.Windows.Forms import SaveFileDialog

SaveFile = SaveFileDialog()

SaveFile.Filter = "Excel Workbook (*.xls)|*.xls"

SaveFile.ShowDialog()

saveFilename = SaveFile.FileName

 

from Spotfire.Dxp.Application.Visuals import VisualContent,TablePlotColumnSortMode

from Spotfire.Dxp.Data.Export import DataWriterTypeIdentifiers

from System.IO import File, StreamWriter

writer = Document.Data.CreateDataWriter(DataWriterTypeIdentifiers.ExcelXlsDataWriter)

stream = StreamWriter(saveFilename)

te = crossTable.As[VisualContent]()

te.ExportText(stream)This requires that you define "crossTable" as an input parameter which is defined as the cross table you want to export.

[Richard Lake 4]

Thanks Sean.  I tried u[[{"fid":"112966","view_mode":"default","fields":{"format":"default","field_file_image_alt_text[und][0][value]":"","field_file_image_title_text[und][0][value]":""},"type":"media","attributes":{"height":"1038","width":"1483","class":"media-element file-default"}}]]sing this script but was unable to see the data.  Wondering what I am missing.

[Sean Riley]

Your input parameter is called Viz1, and not crossTable like required:

 

This requires that you define "crossTable" as an input parameter which is defined as the cross table you want to export.

 

And you modified the following line incorrectly:

 

te = crossTable.As[Viz1]()

 

 

 

If you did want to keep your input parameter named Viz1 then this would be how to modify the script:

 

te = Viz1.As[VisualContent]()

 

 

[Richard Lake 4]

Got it.  Thanks Sean!

[Richard Lake 4]

And if I have 50 different visualizations (crosstables) that I would like to export to a common directory with the click of one action button.  Is that possible as well I looked at the automation services but it only offers crosstable exports as text files.

[Namrata Gade 3]

Hi Sean, 

 

When trying to implement this solution in 7.10 environemnt at my end , it works in professional client but gives attached error on webplayer. Any clue why this could be

 

 

[Hung Huynh]

Hi Sean, I tried this :

SaveFile.Filter = "Excel Workbook (*.xlsx)|*.xlsx"However, the xlsx file cannot be opened. Do you know why your code only works with .xls files