# 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](https://developer.mescius.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.Worksheet~setSparkline.html) | SpreadJS imports this setting from Excel. |
| Spans | Sheet.[addSpan](https://developer.mescius.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.Worksheet~addSpan.html) | SpreadJS loads all span information from Excel. |
| ActiveCell | Sheet.[setActiveCell](https://developer.mescius.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.Worksheet~setActiveCell.html) | SpreadJS sets the active cell when importing from Excel. |
| Selections | Sheet.[setSelection](https://developer.mescius.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.Worksheet~setSelection.html) | SpreadJS sets the selection when importing from Excel. |
| GridLine | Sheet.<strong>options.gridline</strong> | SpreadJS imports this setting from Excel. |
| Zoom | Sheet.[zoom](https://developer.mescius.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.Worksheet~zoom.html) | SpreadJS keeps the zoom factor when importing from Excel. |
| Theme | Sheet.[currentTheme](https://developer.mescius.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.Worksheet~currentTheme.html) | SpreadJS imports this setting from Excel. |
| Conditional Formats | Sheet.[ConditionalFormats](https://developer.mescius.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.ConditionalFormatting.ConditionalFormats.html) | 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](https://developer.mescius.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.Tables.TableManager~add.html) | 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](https://developer.mescius.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.Worksheet~rowFilter.html) | SpreadJS loads all filter information when importing from Excel. |
| Sheet Custom Names | Sheet.[addCustomName](https://developer.mescius.com/spreadjs/docs/latest/online/SpreadJS~GC.Spread.Sheets.Worksheet~addCustomName.html) | 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. |