Styles mentioned at left side of following list specified in
rowData.pq_cellstyle[ dataIndx ]
are exported as cell styles to ExcelrowData.pq_rowstyle
are exported as row styles to Excelcolumn.style
are exported as column styles to ExcelConversely 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-color: string ( background in <= v7.2.0 ) | 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 |
Styles can be specified in rowData.pq_cellstyle[ dataIndx ]
, rowData.pq_rowstyle
and column.style
column.render
and column.rowInit
callbacks.