# Script that exports a file from client (not webplayer)
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
# GETS THE FILE PATH FROM THE USER THROUGH A FILE DIALOG
SaveFile = SaveFileDialog()
SaveFile.Filter = "Spotfire Text Data Format (*.xlsx)|*.xls"
SaveFile.ShowDialog()
for vis in Application.Document.ActivePageReference.Visuals:
if vis.Title == "ExportKPI" :
vizTable = vis.As[TablePlot]()
if SaveFile.FileName=="":
# user does not select a file (cancel button)
saveFilename = ""
else:
saveFilename = SaveFile.FileName
print "saveFilename=", saveFilename
# Export Table data to the file
try:
stream = FileStream(saveFilename, FileMode.Create)
vizTable.ExportData(DataWriterTypeIdentifiers.ExcelXlsxDataWriter, stream)
#vizTable.As[TablePlot]().ExportData(DataWriterTypeIdentifiers.StdfDataWriter, stream)
print "stream.Length = ", stream.Length
finally:
stream.Dispose()
This is dummy text. It is not meant to be read. Accordingly, it is difficult to figure out when to end it. But then, this is dummy text. It is not meant to be read. Period.
ConversionConversion EmoticonEmoticon