# Worksheet Settings Imported

## Content

This table summarizes how the sheet settings are handled when SpreadJS imports data from an Excel-formatted file. These settings are members of the GC.Spread.Sheets.Worksheet class unless otherwise noted.

| **Excel Setting** | **SpreadJS Setting** | **Remarks** |
| ------------- | ---------------- | ------- |
| Worksheets Worksheet names | SpreadJS Spread.name | SpreadJS imports this setting from Excel. |
| Default Width | Sheet.defaults.colWidth | SpreadJS imports this setting from Excel. |
| Frozen panes | Sheet.<strong>frozenRowCount</strong> or Sheet.<strong>frozenColumnCount</strong> | SpreadJS imports this setting from Excel. |
| Data |  | SpreadJS loads the data from Excel. |
| Sparkline | Sheet.[setSparkline](/spreadjs/api/classes/GC.Spread.Sheets.Worksheet#setsparkline) | SpreadJS imports this setting from Excel. |
| Spans | Sheet.[addSpan](/spreadjs/api/classes/GC.Spread.Sheets.Worksheet#addspan) | SpreadJS loads all span information from Excel. |
| ActiveCell | Sheet.[setActiveCell](/spreadjs/api/classes/GC.Spread.Sheets.Worksheet#setactivecell) | SpreadJS sets the active cell when importing from Excel. |
| Selections | Sheet.[setSelection](/spreadjs/api/classes/GC.Spread.Sheets.Worksheet#setselection) | SpreadJS sets the selection when importing from Excel. |
| GridLine | Sheet.<strong>options.gridline</strong> | SpreadJS imports this setting from Excel. |
| Zoom | Sheet.[zoom](/spreadjs/api/classes/GC.Spread.Sheets.Worksheet#zoom) | SpreadJS keeps the zoom factor when importing from Excel. |
| Theme | Sheet.[currentTheme](/spreadjs/api/classes/GC.Spread.Sheets.Worksheet#currenttheme) | SpreadJS imports this setting from Excel. |
| Conditional Formats | Sheet.[conditionalFormats](/spreadjs/api/classes/GC.Spread.Sheets.Worksheet#conditionalformats) | SpreadJS loads all conditional formats when importing from Excel. |
| TabColor | Sheet.<strong>options.sheetTabColor</strong> | SpreadJS imports this setting from Excel. |
| Sheet Protected | Sheet.<strong>options.isProtected</strong> | SpreadJS imports this setting from Excel. |
| Tables | Sheet.tables.[add](/spreadjs/api/classes/GC.Spread.Sheets.Tables.TableManager#add) | SpreadJS loads all tables when importing from Excel. |
| Range Group | Sheet.rowOutlines or Sheet.columnOutlines | SpreadJS loads all group information when importing from Excel. |
| Cell Overflow | Sheet.<strong>options.allowCellOverflow</strong> | SpreadJS sets allowCellOverflow to true (cells can always overflow in Excel). |
| Filter | Sheet.[rowFilter](/spreadjs/api/classes/GC.Spread.Sheets.Worksheet#rowfilter) | SpreadJS loads all filter information when importing from Excel. |
| Sheet Custom Names | Sheet.[addCustomName](/spreadjs/api/classes/GC.Spread.Sheets.Worksheet#addcustomname) | SpreadJS loads all custom names when importing from Excel. |
| Sheet Row or Column Header | Sheet.<strong>options.rowHeaderVisible</strong> or Sheet.<strong>options.colHeaderVisible</strong> | SpreadJS imports this setting from Excel. |
| Display Zeros as Blank | Sheet.options.showZeros | SpreadJS imports this setting from Excel. |