Spread.Sheets Documentation
Workbook Settings Imported

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.

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.