This table summarizes how the sheet settings are handled when SpreadJS imports data from an Excel-formatted file. These properties are members of the GcSpread.Sheets.Sheet class unless otherwise noted.
| Excel Setting |
SpreadJS Setting |
Remarks |
| Worksheets Worksheet names |
Spread.sheets Spread.name |
SpreadJS imports this setting from Excel. |
| Default Width |
Sheet.defaults.colWidth |
SpreadJS imports this setting from Excel. |
| Frozen panes |
Sheet.setFrozenRowCount or Sheet.setFrozenColumnCount |
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 activeCell when importing from Excel. |
| Selections |
Sheet.setSelection |
SpreadJS sets the selection when importing from Excel. |
| GridLine |
Sheet.setGridlineOptions |
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.getConditionalFormats |
SpreadJS loads all conditional formats when importing from Excel. |
| TabColor |
Sheet.sheetTabColor |
SpreadJS imports this setting from Excel. |
| Sheet Protected |
Sheet.setIsProtected |
SpreadJS imports this setting from Excel. |
| Tables |
Sheet.addTable |
SpreadJS loads all tables when importing from Excel. |
| Range Group |
Sheet.rowRangeGroup or Sheet.colRangeGroup |
SpreadJS loads all group information when importing from Excel. |
| Cell Overflow |
Sheet.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.setRowHeaderVisible or Sheet.setColumnHeaderVisible |
SpreadJS imports this setting from Excel. |