| 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. |