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.frozenRowCount or Sheet.frozenColumnCount	SpreadJS imports this setting from Excel.
Data		SpreadJS loads the data from Excel.
Sparkline	Sheet.setSparkline	SpreadJS imports this setting from Excel.
Spans	Sheet.addSpan	SpreadJS loads all span information from Excel.
ActiveCell	Sheet.setActiveCell	SpreadJS sets the active cell when importing from Excel.
Selections	Sheet.setSelection	SpreadJS sets the selection when importing from Excel.
GridLine	Sheet.options.gridline	SpreadJS imports this setting from Excel.
Zoom	Sheet.zoom	SpreadJS keeps the zoom factor when importing from Excel.
Theme	Sheet.currentTheme	SpreadJS imports this setting from Excel.
Conditional Formats	Sheet.ConditionalFormats	SpreadJS loads all conditional formats when importing from Excel.
TabColor	Sheet.options.sheetTabColor	SpreadJS imports this setting from Excel.
Sheet Protected	Sheet.options.isProtected	SpreadJS imports this setting from Excel.
Tables	Sheet.tables.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.options.allowCellOverflow	SpreadJS sets allowCellOverflow to true (cells can always overflow in Excel).
Filter	Sheet.rowFilter	SpreadJS loads all filter information when importing from Excel.
Sheet Custom Names	Sheet.addCustomName	SpreadJS loads all custom names when importing from Excel.
Sheet Row or Column Header	Sheet.options.rowHeaderVisible or Sheet.options.colHeaderVisible	SpreadJS imports this setting from Excel.