FarPoint.Excel
ExcelOpenFlags Enumeration
See Also 
FarPoint.Excel Assembly > FarPoint.Excel Namespace : ExcelOpenFlags Enumeration


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

Syntax

Visual Basic (Declaration) 
Public Enum ExcelOpenFlags 
   Inherits Enum
Visual Basic (Usage)Copy Code
Dim instance As ExcelOpenFlags
C# 
public enum ExcelOpenFlags : Enum

Members

MemberDescription
NoFlagsSet [0] Opens the spreadsheet from the Excel-compatible file with no special options.
DataOnly [1] Loads only the data from the Excel-compatible file into the spreadsheet.
DataAndFormulasOnly [3] Loads formulas from the Excel-compatible file into the spreadsheet.
RowHeaders [4] Loads row headers from frozen columns in the Excel-compatible file into the spreadsheet.
ColumnHeaders [8] Loads column headers from frozen rows in the Excel-compatible file into the spreadsheet.
RowAndColumnHeaders [12] Loads row headers from frozen columns and column headers from frozen rows.
DoNotRecalculateAfterLoad [1024] Avoids recalculation after loading the Excel file (by not setting the SheetView.AutoCalculation property to true and not calling SheetView.Recalculate().
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.
ComboDataOnly 
TruncateEmptyRowsAndColumns [128] Truncate empty rows and columns to improve performance.

Inheritance Hierarchy

System.Object
   System.ValueType
      System.Enum
         FarPoint.Excel.ExcelOpenFlags

See Also