How to Export Cross Table ( ! without value formatting ! ) to Excel in SPotfire ( IronPython Script )

[Hugues Pags]

Good morning,

I can extract a report in CSV format and put it in my directory with the following code underneath. The only problem is that I want to extract it without value formatting.

from System.IO import Path, File, StreamWriter

from Spotfire.Dxp.Application.Visuals import TablePlot

from System.IO import Path, File, StreamWriter

from Spotfire.Dxp.Application.Visuals import TablePlot

from Spotfire.Dxp.Data import DataPropertyClass

from Spotfire.Dxp.Data import DataType

from Spotfire.Dxp.Data.Export import DataWriterTypeIdentifiers

from Spotfire.Dxp.Data import DataPropertyClass

from Spotfire.Dxp.Data import DataType

from System.IO import File, Directory

from System.IO import Path, File, StreamWriter

from Spotfire.Dxp.Application.Visuals import CrossTablePlot

 

 

report1 = "C:\export\report1.csv"

writer = StreamWriter(report1)

 

Viz1.As[CrossTablePlot]().ExportText(writer)I would like with the option to extract without value formatting.

Thank you in advance for your help

[Shashank Gurnalkar]

Can you try this article

https://community.spotfire.com/wiki/how-export-tablecross-table-visualization-data-csv-file-using-tibco-spotfirer-using-ironpython

You can comment out this line:

MemoryStream.Dispose(memStream);