ExcelOpenFlags Enumeration

Specifies what part of the Excel-compatible file you want to load into the spreadsheet.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum ExcelOpenFlags 
   Inherits System.Enum

'Usage
 
Dim instance As ExcelOpenFlags

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] 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.
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

Requirements

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

Reference

FarPoint.Excel Namespace