IronPhyton script to export excel with format for crosstable

[Wee Loon Goh]

Hi,

I'm new to Spotfire. I have a crosstable with format coloring. I need a button with ironpython script to export the crosstable with format included. Thanks in advance for the help.

[David Boot-Olazabal]

Hi shinngoh,

I'm not sure if you can keep the color formatting when exporting to excel (I haven't tried it myself), but have a look at this blogpost:https://spotfired.blogspot.com/2014/03/export-to-excel-pdf-clipboard-etc.html

It might set you on the right track.

You can also check out our wiki, where you will find lots of iron python examples (alongside with other extensions as C#):https://community.spotfire.com/wiki/ironpython-scripting-tibco-spotfire

Kind regards,

David