'Declaration
Public Enum ExcelOpenFlags Inherits System.Enum
'Usage
Dim instance As ExcelOpenFlags
public enum ExcelOpenFlags : System.Enum
'Declaration
Public Enum ExcelOpenFlags Inherits System.Enum
'Usage
Dim instance As ExcelOpenFlags
public enum ExcelOpenFlags : System.Enum
Member | Description |
---|---|
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(). |
Exchangeable | Indicates that the extension data will be imported. |
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. |
System.Object
System.ValueType
System.Enum
FarPoint.Excel.ExcelOpenFlags