SpreadJS 14
Import and Export Reference / Excel-Formatted Files Import / Workbook Settings Imported
In This Topic
    Workbook Settings Imported
    In This Topic

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