# Workbook Settings Imported

## Content

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](/spreadjs/api/v17/classes/GC.Spread.Sheets.Workbook#addnamedstyle) | Named Styles in Excel files are imported into SpreadJS.<br>Apply flags set to named styles in Excel files are imported into SpreadJS. |
| ActiveSheetIndex | [Spread.setActiveSheetIndex](/spreadjs/api/v17/classes/GC.Spread.Sheets.Workbook#setactivesheetindex) | SpreadJS imports the setting from Excel. |
| ReferenceStyle | Spread.**referenceStyle** | SpreadJS imports the setting from Excel options. |
| StartSheetIndex | [Spread.startSheetIndex](/spreadjs/api/v17/classes/GC.Spread.Sheets.Workbook#startsheetindex) | SpreadJS imports the setting from Excel. |
| SheetCount | SpreadJS.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. |