Change Cross Table properties

#Script to change row header, cell widths and row sorting
#viz is a Cross Table visualization script parameter
from Spotfire.Dxp.Application.Visuals import CrossTablePlot, CategoryKey 

from Spotfire.Dxp.Data import SortOrder 

#Get a reference of the cross table from viz param
crossTable = viz.As[CrossTablePlot]()

#Change the second RowHeader
crossTable.RowHeaderWidths[1]=150

#Resize cells

crossTable.CellWidth=100

#sort 

#Change sorting
categoryKey = CategoryKey("cellValueColumnToSort") 
crossTable.SortRowsCategory = categoryKey 
crossTable.SortColumnsOrder = SortOrder.Descending
crossTable.SortRowsOrder = SortOrder.Descending

#Reset sorting
crossTable.SortRowsCategory  = None

See CrossTablePlot Members