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.

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:

  1. Header row height
  2. Data rows height
  3. Number of frozen columns
  4. Show cell borders
  5. Allow table data export in Spotfire web clients
  6. 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

The purpose of this website is to provide a comprehensive, accurate, and efficient IronPython reference for Spotfire developers.

If you have any questions, comments, or ideas, feel free to get in touch!