Appearance

These IronPython scripts below show how to modify any of the Table visualization settings found on the Appearance tab of the Table Properties dialog box in the Spotfire user interface.

Note

In each of the scripts below, it is assumed that the MyVis variable references the targeted visualization. See here for more information about referencing visualizations.

Change Table Appearance Tab Options

This IronPython script shows how to change the following options, in order from top to bottom in the user interface:

Header row height
Data rows height
Number of frozen columns
Show cell borders
Allow table data export in Spotfire web clients
Use separate color for marked items

from Spotfire.Dxp.Application.Visuals import *
from Spotfire.Dxp.Application.Visuals.TablePlotBase import BorderStyle

myVis = myVis.As[Visualization]()

# 1. Change header row height:
myVis.HeaderHeight = 3

# 2. Change data row height:
myVis.RowHeight = 3

# 3. Change number of frozen columns:
myVis.FrozenCount = 5

# 4. Show / hide cell borders:
myVis.CellBorderStyle = BorderStyle.Solid  # Show borders
# OR
myVis.CellBorderStyle = BorderStyle.None  # Hide borders

# 5. Allow table data export in Spotfire web clients
myVis.ExportDataEnabled = True

# 6. Use separate color for marked items
myVis.UseSeparateColorForMarkedItems = True