ironpython - 在 Spotfire 中将交叉表可视化导出到 Excel

Question

我正在尝试通过 Iron Python 脚本将交叉表可视化导出到 Excel。下面的代码非常适合数据表导出。您能否指导我从交叉表中导出它。

from Spotfire.Dxp.Data.Export import DataWriterTypeIdentifiers 
from System.IO import File
writer = 
Document.Data.CreateDataWriter(DataWriterTypeIdentifiers.ExcelXlsDataWriter)
filtering = 
Document.ActiveFilteringSelectionReference.GetSelection(table).AsIndexSet()
stream = File.OpenWrite("C:\Users\Q849965\Desktop\SpotfireExport.xls")
names = []
for col in table.Columns:
names.append(col.Name)
writer.Write(stream, table, filtering, names)
stream.Close()

标签： ironpythonspotfire