test

Warning when upgrading to Spotfire 10

TIBCO has deprecated the JQueryUI Javascript library in the latest Spotfire 10.0 release

TIBCO Community pages show us how to use JQuery properly

Exporting to Excel (from client only)

# 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()




No comments: