Spread Windows Forms 17
FarPoint.Excel Assembly / FarPoint.Excel Namespace / ExcelOpenFlags Enumeration


In This Topic
    ExcelOpenFlags Enumeration
    In This Topic
    Specifies what part of the Excel-compatible file you want to load into the spreadsheet.
    Syntax
    'Declaration
     
    
    Public Enum ExcelOpenFlags 
       Inherits System.Enum
    'Usage
     
    
    Dim instance As ExcelOpenFlags
    public enum ExcelOpenFlags : System.Enum 
    Members
    MemberDescription
    ColumnHeaders[8] Loads column headers from frozen rows in the Excel-compatible file into the spreadsheet.
    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.
    DataValidationAsCombo[32768] Indicates the DataValidation will be imported as ComboBoxCellType.
    DocumentCaching[512] Loads content from Excel files that is kept while writing back. (e.g. VBA, Macro)
    DoNotRecalculateAfterLoad[1024] Avoids recalculation after loading the Excel file (by not setting the SheetView.AutoCalculation property to true and not calling SheetView.Recalculate().
    ExchangeableIndicates that the extension data will be imported.
    NoFlagsSet[0] Opens the spreadsheet from the Excel-compatible file with no special options.
    PreferDateTime[65536] Convert cell value to .NET DateTime object if the it's the number and cell format is date time.
    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

    See Also