How to style the Cross Table Cell Height/Column Header Height in Spotfire® using IronPython Scripting

Introduction

1. This article describes how to change the width and height of the Cells and the Headers in the Cross Table using IronPython Scripting.

2. We can change the column width in cross table using out of the box feature, but in order to change/modify the cell height as well as Header height you will need to make use of the Spotfire API's. Please refer below script to style the Cells/Headers individually using Scripting.

Code Sample

# Copyright © 2017. TIBCO Software Inc. Licensed under TIBCO BSD-style license.

# Change Height and Width of the Cells and Headers in Cross Table.


from Spotfire.Dxp.Application.Visuals import CrossTablePlot

vis.As[CrossTablePlot]().CellWidth=100
vis.As[CrossTablePlot]().CellHeight=50
vis.As[CrossTablePlot]().RowHeaderWidths.Item[0]=200
vis.As[CrossTablePlot]().ColumnHeaderHeights.Item[0]=40

References

• API Reference:CrossTablePlot.CellHeight Property
• API Reference: CrossTablePlot.CellWidth Property
• API Reference: CrossTablePlot.ColumnHeaderHeights Property
• API Reference: CrossTablePlot.RowHeaderWidths Property

License:  TIBCO BSD-Style License

Back to IronPython Scripting in Spotfire Examples:  https://community.spotfire.com/s/article/IronPython-Scripting-in-Spotfire