Export of static and conditional styles in cells.

Styles mentioned in first column of following table when specified in pq_cellattr[dataIndx].style in rows are exported to Excel.

Conversely cell styles in Excel xlsx file or cell properties in javascript workbook are imported to cells in grid as cell attributes.

cell attributes of grid cell of javascript workbook
backgroundcell.bgColor
colorcell.color
font-weight when 'bold'cell.bold
font-familycell.font
font-sizecell.fontSize
font-style when 'italic'cell.italic = true
text-aligncell.align
text-decoration when 'underline'cell.underline = true
vertical-aligncell.valign
white-space when 'normal'cell.wrap = true

Ways to add Excel export ready styles in grid

Styles can be specified in pq_cellattr[dataIndx].style

In this example, both column.render and formulas are shown for demonstration purpose, however it's not necessary to use both of them. Either one of them is sufficient to add conditional styles.