Examples

Example 01 - Import CSV and Format Table

The script imports on the Window class of type table with the method importCSV(). The basic cell formatting like setting the background color, font sizes etc. is also done using the Window class methods with cell references as arguments.

Conditional formatting dependent on the cell values is achieved by using the TableRule class. Attributes used are operator, textColor, backgroundColor and cellList.

# Import required modules
import hw
import hw.hg as hg
import os

# Link to csv from demo directory
ALTAIR_HOME  = os.path.abspath(os.environ['ALTAIR_HOME'])
tableCsvFile = os.path.join(ALTAIR_HOME,'demos','report','data','mesh_statistics.csv')

# Create new session and get window object
ses = hw.Session()
ses.new()
tableWin = ses.get(hw.Window)

# Switch to TableView Window
tableWin.type = 'table'

# Import csv file with ',' symbol as delimiter
tableWin.importCSV(tableCsvFile,delimiter=',')

# Autofit columns
tableWin.setAutofitColumnWidth(['a','c:d'],True)

# Format cell text and background colors dependent of filled cells
lowRightCell=tableWin.getFilledLowerRightCell()
uppLeftCell=tableWin.getFilledUpperLeftCell()
tableWin.setCellBackgroundColor([uppLeftCell+':'+lowRightCell],(230,230,230))
tableWin.setCellBackgroundColor(['a1:j1'],(0,0,0))
tableWin.setCellTextColor('a1:j1','#ffffff')
font=hw.Font(size=10,style='bold',family='Noto Sans')
tableWin.setCellFont('a1:j1',font)
tableWin.setCellAlignmentHorizontal([uppLeftCell+':'+lowRightCell],'center')

# Add conditional formatting rules
textColorList=[(0,0,0),(229,83,0),'#000000']
bgColorList=[(0,255,0),(255,255,0),'#ff0000']
valueList = [10,50,80]
for (textColor,bgColor,value) in zip(textColorList,bgColorList,valueList):
    # Add Rule
    tableRule=hg.TableRule()
    tableRule.textColor=textColor
    tableRule.backgroundColor=bgColor
    tableRule.cellList = ['b2:b13']
    tableRule.operator='>='
    tableRule.value = value
# Refresh TableView to activate conditional formatting
tableWin.refresh()

Figure 6. Output of ‘Import CSV and Format Table’