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. | |
color? |
|
The text color of the cell. Supports hex CSS-like values that start with "#" e.g. "#ff00ff". | |
colSpan? |
|
Sets the number of columns that a cell occupies. | |
disabled? |
|
Specifies if the cell is disabled. | |
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. |