Export of static and conditional styles in cells, rows and columns.

Styles mentioned at left side of following list specified in

• rowData.pq_cellstyle[ dataIndx ] are exported as cell styles to Excel
• rowData.pq_rowstyle are exported as row styles to Excel
• column.style are exported as column styles to Excel

Conversely cell/row/column styles in Excel xlsx file or cell/row/column properties in javascript workbook are imported to grid as rowData.pq_cellstyle[ dataIndx ], rowData.pq_rowstyle and column.style.

css style of cell/row/column in grid	property of corresponding cell/row/column in javascript workbook
background: string	bgColor: string
border: string	border: {left: string, top: string, right: string, bottom: string}
border-top: string	border: { top: string }
border-right: string	border: { right: string }
border-bottom: string	border: {bottom: string}
border-left: string	border: {left: string}
color: string	color: string
font-family: string	font: string
font-size: string	fontSize: number
font-weight when 'bold'	bold = true
font-style when 'italic'	italic = true
text-decoration when 'underline'	underline = true
white-space when 'normal'	cell.wrap = true

prop of cell/row/column in grid	property of corresponding cell/row/column in javascript workbook
align: 'left' | 'center' | 'right'	align
valign: 'top' | 'center' | 'bottom'	valign

Ways to add Excel export ready styles in grid

Styles can be specified in rowData.pq_cellstyle[ dataIndx ], rowData.pq_rowstyle and column.style

• Statically in JSON data.
• Conditionally with help of formulas.
• Conditionally with help of column.render and column.rowInit callbacks.

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.