- SpreadJS Overview
- Getting Started
- JavaScript Frameworks
- Best Practices
- Features
- SpreadJS Designer
- SpreadJS Designer Component
- Touch Support
- Formula Reference
- Import and Export Reference
- Frequently Used Events
- API Documentation
- Release Notes
Worksheet Settings Imported
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. |
Display Zeros as Blank | Sheet.options.showZeros | SpreadJS imports this setting from Excel. |