Advertisement
Guest User

Untitled

a guest
Jun 24th, 2019
60
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.83 KB | None | 0 0
  1. import System
  2.  
  3. from System.IO import FileStream, FileMode
  4.  
  5. from Spotfire.Dxp.Application.Visuals import TablePlot
  6.  
  7. from Spotfire.Dxp.Data.Export import DataWriterTypeIdentifiers
  8.  
  9. import clr
  10.  
  11. clr.AddReference("System.Windows.Forms")
  12.  
  13. from System.Windows.Forms import SaveFileDialog
  14.  
  15. SaveFile = SaveFileDialog()
  16.  
  17. SaveFile.Filter = "Excel Workbook (*.xlsx)|*.xlsx"
  18.  
  19. SaveFile.ShowDialog()
  20.  
  21. saveFilename = SaveFile.FileName
  22.  
  23. print "saveFilename=", saveFilename
  24.  
  25. from Spotfire.Dxp.Application.Visuals import
  26.  
  27. VisualContent,TablePlotColumnSortMode
  28.  
  29. from Spotfire.Dxp.Data.Export import DataWriterTypeIdentifiers
  30.  
  31. from System.IO import File, StreamWriter
  32.  
  33. writer = Document.Data.CreateDataWriter(DataWriterTypeIdentifiers.ExcelXlsDataWriter)
  34.  
  35. stream = StreamWriter(saveFilename)
  36.  
  37. te = summaryCrossTable.As[VisualContent]()
  38.  
  39. te.ExportText(stream)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement