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 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

FarPoint.Excel Namespace