| SpreadJS Documentation > Import and Export Reference > Excel-Formatted Files Export > Sheet Settings Exported |
This table summarizes how the Sheet settings are handled when SpreadJS exports to an Excel-formatted file. These functions are in the GcSpread.Sheets.Sheet class unless otherwise noted.
| Sheet Setting | Excel Setting and Remarks |
| name | Excel uses this setting. |
| defaults : rowHeight, columnWidth, columnHeaderRowHeight, rowHeaderColumnWidth |
Excel only use the default.colWidth setting, but loads other settings to the column or row header. |
| columns | Excel uses this setting. |
| rows | Excel uses this setting. |
| autoGenerateColumns | Excel ignores the Sheet setting. This is specific to SpreadJS. |
| dataSource | Excel ignores the Sheet setting. This is specific to SpreadJS. |
| frozenRowCount or frozenColumnCount | Excel uses this setting. |
| frozenTrailingRowCount or frozenTrailingColumnCount | Excel ignores the Sheet setting. This is specific to SpreadJS. |
| rowCount | Excel ignores the Sheet setting. This is specific to SpreadJS. |
| columnCount | Excel ignores the Sheet setting. This is specific to SpreadJS. |
| data | Excel loads the data from SpreadJS. |
| sparkline | Excel uses this setting. |
| spans | Excel uses this setting. |
| selections | Excel uses this setting. |
| selectionBackColor | Excel ignores the Sheet setting. This is specific to SpreadJS. |
| selectionBorderColor | Excel ignores the Sheet setting. This is specific to SpreadJS. |
| activeRowIndex | Excel uses this setting. |
| activeColumnIndex | Excel uses this setting. |
| gridLine | Excel uses this setting, but if the vertical or horizontal grid line is hidden, then both are exported as hidden in Excel. |
| allowCellOverflow | Excel ignores the Sheet setting. allowCellOverflow is always true in Excel. |
| zoomFactor | Excel uses this setting. |
| theme | Excel uses the first sheet theme as the current theme and ignores other sheet theme settings. |
| showRowRangeGroup or showColumnRangeGroup | Excel ignores the Sheet setting. Excel uses the range group that is shown. |
| rowRangeGroup or columnRangeGroup | Excel uses this setting. |
| rowFilter | Excel uses this setting. |
| conditionalFormats | Excel uses this setting. |
| sheetTabColor | Excel uses this setting. |
| frozenlineColor | Excel ignores the Sheet setting. This is specific to SpreadJS. |
| rowHeaderAutoText(Index) or columnHeaderAutoText(Index) | Excel ignores the Sheet setting. This is specific to SpreadJS. |
| rowHeaderVisible or columnHeaderVisible | Excel uses this setting. |
| rowHeaderColumnCount | Excel ignores the Sheet setting. This is specific to SpreadJS. |
| columnHeaderRowCount | Excel ignores the Sheet setting. This is specific to SpreadJS. |
| rowHeaderData | Excel ignores the Sheet setting. This is specific to SpreadJS. |
| columnHeaderData | Excel ignores the Sheet setting. This is specific to SpreadJS. |
| rowHeaderSpan | Excel ignores the Sheet setting. This is specific to SpreadJS. |
| columnHeaderSpan | Excel ignores the Sheet setting. This is specific to SpreadJS. |
| clipboardOptions | Excel ignores the Sheet setting. This is specific to SpreadJS. |
| isProtected | Excel uses this setting. |
| borderColor | Excel ignores the Sheet setting. This is specific to SpreadJS. |
| borderWidth | Excel ignores the Sheet setting. This is specific to SpreadJS. |
| table | Excel uses this setting. |
| namedStyles | Excel uses this setting. |