How do I prompt the user on Spotfire to create .csv and .xlsx excel file

[Hung Huynh]

Hi, I am trying to prompt the user on Spotfire to create an excel file to "My Documents".

 

from Spotfire.Dxp.Data.Export import DataWriterTypeIdentifiers

from System.IO import File

 

writer = Document.Data.CreateDataWriter(DataWriterTypeIdentifiers.ExcelXlsxDataWriter)

filtering = Document.ActiveFilteringSelectionReference.GetSelection(table).AsIndexSet()

 

#create an excel file with its path of file and filename

 

stream = File.OpenWrite(LOCATION OF EXCEL FILE) #open excel file to be read

names = []

 

for col in table.Columns:

names.append(col.Name)

 

writer.Write(stream, table, filtering, names)

stream.Close()

[Shandilya Peddi]

You can try something like below on Spotfire Analyst,

clr.AddReference("System.Windows.Forms")

from System.Windows.Forms import OpenFileDialog, MessageBox

 

OpenFile = OpenFileDialog()

OpenFile.ShowDialog()

filename = OpenFile.FileName

MessageBox.Show("Selected file: " + filename)

[Hung Huynh]

Thank you for your help!