Export to excel button functionality in spotfire web player

[Viji Dade]

Is there a way to export data to using excel to excel button in spotfire web player and export data to local machine using Iron Python/ Java script

I have searched in older posts they suggest to export data to shared folder.

[Jose Leviaguirre]

Hello dade.viji,

There are different ways to export to excel using Iron Python, Data Function or Javascript depending on the amount of data you are exporting.

If you are exporting large amount of data, I recommend using the odbc approach and connect directly to Excel. You will need the proper driver. Checkout this article on how to achieve this.

Here are other ways:

https://community.spotfire.com/wiki/how-export-tablecross-table-visualization-data-csv-file-using-tibco-spotfirer-using-ironpython

 

https://www.youtube.com/watchv=D4vCAla5KtU&list=PLknbq-WaCOiVvyZpLXHOM2HUX8dmt7eN6&index=8&t=1563s

[Amanjotsingh Gill]

With IronPython scripting, scripts triggered on WebPlayer are executed on the Node Manager machine and thus the files will not be downloaded on the user's local machine. But, you can surely export to a specific network/shared file path as mentioned in the previous articles you are referring to.

You can try to develop a custom export tool instead of an Iron Python script to download the file onto the user's local machine, but there's quite a bit of work involved in that.

Below is a Wiki article that provides some information on how to develop a Custom Export Tool,https://community.spotfire.com/wiki/create-custom-export-tool-tibco-spotfire

[Marek Andrej]

I have working prototype, that loads all tables from hidden export page (custom export) with python and exports them to blank page as pure html tables, then I run datatables.net on the html tables, that will create Export to Excel button. To have multiple sheets, you need to modify the code a bit or use different js library. I am stuck with datatables, as this one is approved in our company. The XLSX is then downloaded directly from browser, you can even play with XML definitions to create freezed top row, change colors etc.. Downside is, that it takes 40sec to export 5000 rows, so I am looking for faster solution.