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.