# 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
# 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
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
ConversionConversion EmoticonEmoticon