Exporting to Excel (Web Player)

# INPUT PARAMETERS
# vizTable : Visualization
# FileLocation: String (c:\temp\file.xls)


import System
from System.IO import FileStream, FileMode
from Spotfire.Dxp.Application.Visuals import TablePlot
from Spotfire.Dxp.Data.Export import DataWriterTypeIdentifiers

# Export Table data to the file
try:
 stream = FileStream(FileLocation, FileMode.Create)
 vizTable.As[TablePlot]().ExportData(DataWriterTypeIdentifiers.ExcelXlsxDataWriter, stream)
finally:
 stream.Dispose()



Here is a better solution:
http://spotfired.blogspot.com/2014/03/export-to-excel-pdf-clipboard-etc.html




Previous
Next Post »