SpreadJS Documentation
Excel Open and Save Flags

This topic lists the Excel open and save flags that can be used when importing or exporting an Excel-formatted file.

Enumeration Description
public enum ExcelOpenFlags Specifies what part of the Excel-compatible file to load into the spreadsheet.
NoFlagsSet = 0 Opens the spreadsheet from the Excel-compatible file with no special options.
DataOnly = 1 Loads only the data from the Excel-compatible file into the spreadsheet.
DataAndFormulasOnly = 3 Loads formulas from the Excel-compatible file into the spreadsheet.
RowHeaders = 4 Loads row headers from frozen columns in the Excel-compatible file into the spreadsheet.
ColumnHeaders = 8 Loads column headers from frozen rows in the Excel-compatible file into the spreadsheet.
RowAndColumnHeaders = 12 Loads row headers from frozen columns and column headers from frozen rows.
DoNotRecalculateAfterLoad = 1024 Avoids recalculation after loading the Excel-compatible file (by not setting the SheetView.AutoCalculation property to true and not calling SheetView.Recalculate())

 

Enumeration Description
public enum ExcelSaveFlags Specifies what part of the spreadsheet to export to an Excel-compatible file.
NoFlagsSet = 0 Saves the spreadsheet to the Excel-compatible file with no special options.
NoFormulas = 1 Saves the displayed data, but not the formulas, to the Excel-compatible file.
SaveCustomRowHeaders = 2 Saves the custom row headers to the Excel-compatible file.
SaveCustomColumnHeaders = 4 Saves the custom column headers to the Excel-compatible file.
SaveAsFiltered = 8 Saves the filtered row results to the Excel-compatible file.
SaveBothCustomRowAndColumnHeaders = 6 Saves both the custom row headers and the custom column headers to the Excel-compatible file.
SaveAsViewed = 136 Saves the spreadsheet as viewed to the Excel-compatible file.
DataOnly = 32 Saves only the data to the Excel-compatible file.
AutoRowHeight = 4096 The default row height is not saved. Excel automatically determines row heights based on the largest font that is set in each row.

 

 


Copyright © GrapeCity, inc. All rights reserved.

Send comments on this topic.