This table summarizes how the workbook settings are handled when SpreadJS imports data from an Excel-formatted file.
| Excel Setting |
SpreadJS Setting |
Remarks |
| Password-protected files |
Excel IO options |
SpreadJS can open password-protected files (specify the password setting in the Excel IO import API service). |
| NamedStyles |
Spread.addNamedStyle |
Named Styles in Excel files are imported into SpreadJS. |
| ActiveSheetIndex |
Spread.setActiveSheetIndex |
SpreadJS imports the setting from Excel. |
| ReferenceStyle |
Spread.referenceStyle |
SpreadJS imports the setting from Excel options. |
| StartSheetIndex |
Spread.startSheetIndex |
SpreadJS imports the setting from Excel. |
| SheetCount |
Spread.sheets.length |
SpreadJS imports the setting from Excel. |
| Scroll bar |
Spread.showHorizontalScrollbar or Spread.showVerticalScrollbar |
SpreadJS imports the setting from Excel options. |
| Show sheet tabs |
Spread.tabStripVisible |
SpreadJS imports the setting from Excel options. |