| FarPoint.Excel Assembly > FarPoint.Excel Namespace : ExcelOpenFlags Enumeration |
'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. |
| ComboDataOnly | [4096] Saves the displayed data in the combobox celltype, does 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. |
| NoPaging | [32768] Ignores paging when importing. |
| 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
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10