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

need to learn how to create an export to excel button function to my dashboard


Juan Vaca

Recommended Posts

One of my projectsis requesting to add an export data tableto excel sheet button on a page of a dashboard I'm creating.

I found this code online but it doesn't export the data table to the excel it just pops the window to save a file in .xls .

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)

Link to comment
Share on other sites

Hi!

Did you check that you defined crosstable as input to your script

If yes, ty to replace the 2 last lines with this

names = [col.Name for col in crosstable.Columns]

filtering = Document.ActiveFilteringSelectionReference.GetSelection(table).AsIndexSet()

writer.Write(stream, crosstable, filtering, names)

stream.Dispose()That works for table but I did not test it for crosstables.

Moreover, you have repetitions in your imports, you should cleanthem ;)

 

Besides, System.Windows.Forms is not compatible with the web player. If you want something compatible with the web player while allowing the user to choose where to save the file, you will most likely need JavaScript.

Link to comment
Share on other sites

  • 1 year later...

Hi Ch3,

 

"System.Windows.Forms" works only on windows environment. If the Web Player server is not under Windows, the library won't be usable, as the code will be executed on the server machine. Thate means, you have to specify the file location in another way. You could have a look there: https://spotfired.blogspot.com/2014/02/exporting-to-excel-web-player.html (or the other article mentionned at the end of the previous link). If you go for the first solution, the machine you want to export on should be available through the network.

 

I hope this wil help :)

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