Spread Windows Forms 11.0 Product Documentation
ExcelOpenFlags Enumeration


FarPoint.Excel Assembly > FarPoint.Excel Namespace : ExcelOpenFlags Enumeration
Specifies what part of the Excel-compatible file you want to load into the spreadsheet.
Syntax
'Declaration
 
Public Enum ExcelOpenFlags 
   Inherits System.Enum
'Usage
 
Dim instance As ExcelOpenFlags
public enum ExcelOpenFlags : System.Enum 
Members
MemberDescription
ColumnHeaders[8] Loads column headers from frozen rows in the Excel-compatible file into the spreadsheet.
DataAndFormulasOnly[3] Loads formulas from the Excel-compatible file into the spreadsheet.
DataOnly[1] Loads only the data from the Excel-compatible file into the spreadsheet.
DataValidationAsCombo[32768] Indicates the DataValidation will be imported as ComboBoxCellType.
DocumentCaching[512] Loads content from Excel files that is kept while writing back. (e.g. VBA, Macro)
DoNotRecalculateAfterLoad[1024] Avoids recalculation after loading the Excel file (by not setting the SheetView.AutoCalculation property to true and not calling SheetView.Recalculate().
NoFlagsSet[0] Opens the spreadsheet from the Excel-compatible file with no special options.
PreferDateTime[65536] Convert cell value to .NET DateTime object if the it's the number and cell format is date time.
RowAndColumnHeaders[12] Loads row headers from frozen columns and column headers from frozen rows.
RowHeaders[4] Loads row headers from frozen columns in the Excel-compatible file into the spreadsheet.
TruncateEmptyRowsAndColumns[8192] Truncates empty rows and columns to improve performance.
UseOldConditionalFormat[16384] Uses the old conditional format.
Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Excel.ExcelOpenFlags

See Also

Reference

FarPoint.Excel Namespace