WorkbookSheetRowCell
The sheets cell configuration.
Name | Type | Default | Description |
---|---|---|---|
background? |
| Sets the background color of the cell. Supports hex CSS-like values that start with "#" e.g. "#ff00ff". | |
bold? |
| Setting it to true makes the cell value bold. | |
borderBottom? |
| The style information for the bottom border of the cell. | |
borderLeft? |
| The style information for the left border of the cell. | |
borderRight? |
| The style information for the right border of the cell. | |
borderTop? |
| The style information for the top border of the cell. | |
colSpan? |
| Sets the number of columns that a cell occupies. | |
color? |
| The text color of the cell. Supports hex CSS-like values that start with "#" e.g. "#ff00ff". | |
fontFamily? |
| Sets the font used to display the cell value. | |
fontSize? |
| Sets the font size in pixels. | |
format? |
| Sets the format that Excel uses to display the cell value. | |
formula? |
| Sets the formula that Excel uses to compute and display the cell value | |
index? |
| 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.
| |
italic? |
| Setting it to true italicizes the cell value. | |
rowSpan? |
| Sets the number of rows that a cell occupies. | |
textAlign? |
| Sets the horizontal alignment of the cell value. Supported values are | |
underline? |
| Setting it to true underlines the cell value. | |
value? |
| The value of the cell. Numbers and dates will be formatted as strings. String values are HTML encoded. | |
verticalAlign? |
| Sets the vertical alignment of the cell value. Supported values are | |
wrap? |
| Setting it to true wraps the cell value. |