ColumnConfiginterface
Configuration for a column in an Excel sheet.
Properties (8)
| Property | Type | Default | Required | Description |
|---|---|---|---|---|
| backgroundColor⚓︎ | string | x | x | A color value for the background color of the cells in this column. |
| fieldName⚓︎ | string | x | The name of the property that is used to transmit this value to/from Excel. |
|
| forceText⚓︎ | boolean | x | x | If true, will cause numeric data in this column to be stored as text in Excel. |
| foregroundColor⚓︎ | string | x | x | A color value for the text color of the cells in this column. |
| header⚓︎ | string | x | x | A string that forms the Column header text in Excel. If not specified fieldName is used. |
| preserveEmptyString⚓︎ | boolean | x | x | If true, will cause empty strings in this column to be stored quoted in Excel, enabling round trip. |
| validation⚓︎ | Validation | x | x | The type and possible values for cells in the column. |
| width⚓︎ | number | x | x | Width of the column in Excel units of 0 (zero) to 255. This value represents the number of characters that can be displayed in a cell that is formatted with the standard font. The default column width is 8.43 characters. If a column has a width of 0 (zero), the column is hidden. |