Jump to content

exporting filtered data from viewing mode

Greg App

Recommended Posts


I am trying to create a way for my manager to export filtered data in a clean excel format from viewing mode (he does not have the necessary license to edit spotfire documents). My current method of doing this is to filter the data with a toggle in a text box, creating a table, copying the table content, and then pasting that content into microsoft excel.

However, my manager's license will not allow him to create a table on his own using the manual method. Due to this license restriction, I am not sure an action button would bypass this restriction and allow him to effectively make changes to the dashboard by creating a new table.

There is a way to export filtered rows into a CSV file, but the result is extremely messy. Can anyone think of another way for my manager to accomplish this


Link to comment
Share on other sites

You can use an IronPython script tied to an button to export the data to excel. Below wiki article has a sample script reference,



Just replace this below line:

writer = Document.Data.CreateDataWriter(DataWriterTypeIdentifiers.SbdfDataWriter)With the following

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

Also since this is from WebPlayer use a network shared path (UNC path) instead of a local file path like C:/ as the files will be created on the NodeManager machine's C;/ drive in this case

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...