WorkbookSheetRowCell

The sheets cell configuration.

background? string

Sets the background color of the cell. Supports hex CSS-like values that start with "#" e.g. "#ff00ff".

bold? boolean

Setting it to true makes the cell value bold.

borderBottom? WorkbookSheetRowCellBorderBottom

The style information for the bottom border of the cell.

borderLeft? WorkbookSheetRowCellBorderLeft

The style information for the left border of the cell.

borderRight? WorkbookSheetRowCellBorderRight

The style information for the right border of the cell.

borderTop? WorkbookSheetRowCellBorderTop

The style information for the top border of the cell.

colSpan? number

Sets the number of columns that a cell occupies.

color? string

The text color of the cell. Supports hex CSS-like values that start with "#" e.g. "#ff00ff".

fontFamily? string

Sets the font used to display the cell value.

fontSize? number

Sets the font size in pixels.

format? string

Sets the format that Excel uses to display the cell value.

formula? string

Sets the formula that Excel uses to compute and display the cell value

index? any

The zero-based index of the cell in the row. Records missing an index will be placed in the first available cell on the row.

Mixing indexed with non-indexed cells might yield invalid results. If you want to use both, place the indexed cells at the end of the array.

italic? boolean

Setting it to true italicizes the cell value.

rowSpan? number

Sets the number of rows that a cell occupies.

textAlign? "left" | "center" | "right"

Sets the horizontal alignment of the cell value. Supported values are "left", "center" and "right".

underline? boolean

Setting it to true underlines the cell value.

value? Date | number | string | boolean

The value of the cell. Numbers and dates will be formatted as strings. String values are HTML encoded.

verticalAlign? "top" | "center" | "bottom"

Sets the vertical alignment of the cell value. Supported values are "top", "center" and "bottom".

wrap? boolean

Setting it to true wraps the cell value.