This table summarizes how the sheet settings are handled when Spread.Sheets imports data from an Excel-formatted file. These settings are members of the GC.Spread.Sheets.Worksheet class unless otherwise noted.
| Excel Setting | Spread.Sheets Setting | Remarks |
| Worksheets Worksheet names | Spread.sheets Spread.name | Spread.Sheets imports this setting from Excel. |
| Default Width | Sheet.defaults.colWidth | Spread.Sheets imports this setting from Excel. |
| Frozen panes | Sheet.frozenRowCount or Sheet.frozenColumnCount | Spread.Sheets imports this setting from Excel. |
| Data | Spread.Sheets loads the data from Excel. | |
| Sparkline | Sheet.setSparkline | Spread.Sheets imports this setting from Excel. |
| Spans | Sheet.addSpan | Spread.Sheets loads all span information from Excel. |
| ActiveCell | Sheet.setActiveCell | Spread.Sheets sets the active cell when importing from Excel. |
| Selections | Sheet.setSelection | Spread.Sheets sets the selection when importing from Excel. |
| GridLine | Sheet.options.gridline | Spread.Sheets imports this setting from Excel. |
| Zoom | Sheet.zoom | Spread.Sheets keeps the zoom factor when importing from Excel. |
| Theme | Sheet.currentTheme | Spread.Sheets imports this setting from Excel. |
| Conditional Formats | Sheet.ConditionalFormats | Spread.Sheets loads all conditional formats when importing from Excel. |
| TabColor | Sheet.options.sheetTabColor | Spread.Sheets imports this setting from Excel. |
| Sheet Protected | Sheet.options.isProtected | Spread.Sheets imports this setting from Excel. |
| Tables | Sheet.tables.add | Spread.Sheets loads all tables when importing from Excel. |
| Range Group | Sheet.rowOutlines or Sheet.columnOutlines | Spread.Sheets loads all group information when importing from Excel. |
| Cell Overflow | Sheet.options.allowCellOverflow | Spread.Sheets sets allowCellOverflow to true (cells can always overflow in Excel). |
| Filter | Sheet.rowFilter | Spread.Sheets loads all filter information when importing from Excel. |
| Sheet Custom Names | Sheet.addCustomName | Spread.Sheets loads all custom names when importing from Excel. |
| Sheet Row or Column Header | Sheet.options.rowHeaderVisible or Sheet.options.colHeaderVisible | Spread.Sheets imports this setting from Excel. |