How do I export CSV files in the Web Player using IronPython Scripting? It works fine in the Client however I am getting this error “Could not perform action”.

How do I export CSV files in the Web Player using IronPython Scripting? It works fine in the Client however I am getting this error “Could not perform action”.

If you are using ShowDialog() method from System.Windows.Forms.SaveFileDialog to export data as excel files from Web Player, you may get an error message saying could not perform action at System.Windows.Forms.CommonDialog.ShowDialog.

The reason why the export would fail in Web Player is because ShowDialog() method only works in WinForm (System.Windows.Forms.SaveFileDialog) namespace. In Web Player, the browser will not be aware of any WinForm function.

This is a workaround:

Step 1: To convert Spotfire table into an html table in a text area.

http://spotfired.blogspot.com/2014/03/export-to-excel-pdf-clipboard-etc.html

Step 2: use Javascript to download html table to csv.

http://stackoverflow.com/questions/15547198/export-html-table-to-csv