Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Enum ExcelOpenFlags Inherits System.Enum | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As ExcelOpenFlags | |
| C# | |
|---|---|
public enum ExcelOpenFlags : System.Enum | |
Members
| Member | Description |
|---|---|
| ColumnHeaders | [8] Loads column headers from frozen rows in the Excel-compatible file into the spreadsheet. |
| ComboDataOnly | [4096] Save the displayed data in the combobox celltype, do not save the items in the combo box. |
| 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. |
| DocumentCaching | [512] Loads content from Excel files that is kept while writing back. (e.g. VBA, Macro) |
| DocumentCachingOnly | [2048] Only loads content from Excel files that is kept while writing back. (e.g. VBA, Macro) The Excel files are not imported into Spread. |
| 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. |
| 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] Truncate empty rows and columns to improve performance. |
Inheritance Hierarchy
System.Object
System.ValueType
System.Enum
FarPoint.Excel.ExcelOpenFlags
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2