How to Export Data Table Summaries to Excel via Ironpython?
I'm new to Ironpython and so would appreciate any help! I have the following code to export my data table to an Excel file, but it doesn't seem to work on Data Table Summaries. Does anyone know how I can adapt it so that it would work to export data table summaries?
from System.IO import FileStream, FileMode
from Spotfire.Dxp.Application.Visuals import TablePlot
from Spotfire.Dxp.Data.Export import DataWriterTypeIdentifiers
from System.Windows.Forms import SaveFileDialog
SaveFile = SaveFileDialog() #GETS THE FILE PATH FROM THE USER THROUGH A FILEDIALOG
SaveFile.Filter = "xls Format (*.xls)|*.xlsx|*.xls|*.xlsx"
saveFilename = SaveFile.FileName
print "saveFilename=", saveFilename
stream = FileStream(saveFilename, FileMode.Create) #Export Table data to the file
import System.Windows.Forms as WinForms
WinForms.MessageBox.Show("Export Complete!", "Success!")