Cell Color in Perspective Table

[victordcq]

you'd have to put a transform script like this in the data prop

Perspective table cell color

Thanks for your help. That has cleaned up the code a little. I’ll work on sorting the key order in the json string later. output_json = [] style_red = {"backgroundColor": "red"} style_green = {"backgroundColor": "green"} style_gray = {"backgroundColor": "gray"} for row in range(value.getRowCount()): row_object = {} for col in value.getColumnNames(): cell_object = {} cell_style = {} # Add a key/value pair for the cell cell_object['value']=value.getValueAt(ro…