# Sheet Settings Exported

## Content

This table summarizes how sheet settings are handled when SpreadJS exports a worksheet to an Excel-formatted file. Unless otherwise noted, these settings belong to the [`GC.Spread.Sheets.Worksheet`](/spreadjs/api/v19/classes/GC.Spread.Sheets.Worksheet) class.

## Settings Supported by Excel

| **Sheet Setting** | **Excel Setting and Remarks** |
| ------------- | ------------------------- |
| activeColumnIndex | Excel uses this setting. |
| activeRowIndex | Excel uses this setting. |
| columns | Excel uses this setting. |
| conditional formats | Excel uses this setting. |
| data | Excel loads the data from SpreadJS. |
| frozenRowCount or frozenColumnCount | Excel uses this setting. |
| isProtected | Excel uses this setting. |
| name | Excel uses this setting. |
| named styles | Excel uses this setting. |
| rowFilter | Excel uses this setting. |
| rowHeaderVisible or colHeaderVisible | Excel uses this setting. |
| rowOutlines or columnOutlines | Excel uses this setting. |
| rows | Excel uses this setting. |
| selections | Excel uses this setting. |
| sheetTabColor | Excel uses this setting. |
| showZeros | Excel uses this setting. |
| sparkline | Excel uses this setting. |
| spans | Excel uses this setting. |
| table | Excel uses this setting. |
| zoomFactor | Excel uses this setting. |

## Settings Supported with Limitations

| **Sheet Setting** | **Excel Setting and Remarks** |
| ------------- | ------------------------- |
| backgroundImage | Excel uses the worksheet background image and preserves the layout setting. The `paintOrder` setting is not preserved because Excel does not support drawing worksheet background images above content. |
| defaults: rowHeight, columnWidth, columnHeaderRowHeight, rowHeaderColumnWidth | Excel uses only the `defaults.columnWidth` setting. The other settings are loaded into the corresponding column or row headers. |
| gridline | Excel uses this setting. However, if either vertical or horizontal gridlines are hidden, both are exported as hidden in Excel. |
| theme | Excel uses the first sheet theme as the current theme and ignores the theme settings of other sheets. |

## Settings Ignored by Excel

| **Sheet Setting** | **Excel Setting and Remarks** |
| ------------- | ------------------------- |
| allowCellOverflow | Excel ignores this Sheet setting. `allowCellOverflow` is always `true` in Excel. |
| autoGenerateColumns | Excel ignores this Sheet setting. It is specific to SpreadJS. |
| borderColor | Excel ignores this Sheet setting. It is specific to SpreadJS. |
| borderWidth | Excel ignores this Sheet setting. It is specific to SpreadJS. |
| clipboardOptions | Excel ignores this Sheet setting. It is specific to SpreadJS. |
| columnCount | Excel ignores this Sheet setting. It is specific to SpreadJS. |
| column header row count | Excel ignores this Sheet setting. It is specific to SpreadJS. |
| dataSource | Excel ignores this Sheet setting. It is specific to SpreadJS. |
| frozenlineColor | Excel ignores this Sheet setting. It is specific to SpreadJS. |
| frozenTrailingRowCount or frozenTrailingColumnCount | Excel ignores this Sheet setting. It is specific to SpreadJS. |
| rowCount | Excel ignores this Sheet setting. It is specific to SpreadJS. |
| row header column count | Excel ignores this Sheet setting. It is specific to SpreadJS. |
| rowHeaderAutoText(Index) or colHeaderAutoText(Index) | Excel ignores this Sheet setting. It is specific to SpreadJS. |
| selectionBackColor | Excel ignores this Sheet setting. It is specific to SpreadJS. |
| selectionBorderColor | Excel ignores this Sheet setting. It is specific to SpreadJS. |
| showRowOutline or showColumnOutline | Excel ignores this Sheet setting. Excel uses the displayed range group instead. |