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
background	cell.bgColor
color	cell.color
font-weight when 'bold'	cell.bold
font-family	cell.font
font-size	cell.fontSize
font-style when 'italic'	cell.italic = true
text-align	cell.align
text-decoration when 'underline'	cell.underline = true
vertical-align	cell.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

• Statically in JSON data.
• Conditionally with help of formulas.
• Conditionally with help of column.render callback.

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.