This table summarizes how the workbook settings are handled when Spread.Sheets imports data from an Excel-formatted file.
| Excel Setting |
Spread.Sheets Setting |
Remarks |
| Password-protected files |
Excel IO options |
Spread.Sheets 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 Spread.Sheets. |
| ActiveSheetIndex |
Spread.setActiveSheetIndex |
Spread.Sheets imports the setting from Excel. |
| ReferenceStyle |
Spread.referenceStyle |
Spread.Sheets imports the setting from Excel options. |
| StartSheetIndex |
Spread.startSheetIndex |
Spread.Sheets imports the setting from Excel. |
| SheetCount |
Spread.sheets.length |
Spread.Sheets imports the setting from Excel. |
| Scroll bar |
Spread.showHorizontalScrollbar or Spread.showVerticalScrollbar |
Spread.Sheets imports the setting from Excel options. |
| Show sheet tabs |
Spread.tabStripVisible |
Spread.Sheets imports the setting from Excel options. |