# ColumnConfig

**Kind**: interface | **Module**: [Excel](https://docs.interop.io/adapters/reference/javascript/excel/index.md)

**Source**: https://docs.interop.io/adapters/reference/javascript/excel/columnconfig/index.html

Configuration for a column in an Excel sheet.

## Properties

- **`backgroundColor`** (`string`, optional)
  A color value for the background color of the cells in this column.
- **`fieldName`** (`string`, required)
  The name of the property that is used to transmit this value to/from Excel.
- **`forceText`** (`boolean`, optional)
  If true, will cause numeric data in this column to be stored as text in Excel.
- **`foregroundColor`** (`string`, optional)
  A color value for the text color of the cells in this column.
- **`header`** (`string`, optional)
  A string that forms the Column header text in Excel. If not specified fieldName is used.
- **`preserveEmptyString`** (`boolean`, optional)
  If true, will cause empty strings in this column to be stored quoted in Excel, enabling round trip.
- **`validation`** (`Validation`, optional)
  The type and possible values for cells in the column.
- **`width`** (`number`, optional)
  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.

## Related types

- [Validation](https://docs.interop.io/adapters/reference/javascript/excel/validation/index.md)