Spread WPF Documentation
GrapeCity.Windows.SpreadSheet.Data Namespace / ExcelOpenFlags Enumeration
Example Example


In This Topic
    ExcelOpenFlags Enumeration
    In This Topic
    Specifies what part of the Excel-compatible file to load into the spreadsheet.
    Syntax
    'Declaration
     
    <FlagsAttribute()>
    Public Enum ExcelOpenFlags 
       Inherits System.Enum
    'Usage
     
    Dim instance As ExcelOpenFlags
    [Flags()]
    public enum ExcelOpenFlags : System.Enum 
    Members
    MemberDescription
    ColumnHeadersLoads column headers from frozen rows in the Excel-compatible file into the spreadsheet.
    DataAndFormulasOnlyLoads formulas from the Excel-compatible file into the spreadsheet.
    DataOnlyLoads only the data from the Excel-compatible file into the spreadsheet.
    DoNotRecalculateAfterLoadAvoids recalculation after loading the Excel-compatible file (by not setting the SheetView.AutoCalculation property to true and not calling SheetView.Recalculate()).
    NoFlagsSetOpens the spreadsheet from the Excel-compatible file with no special options.
    RowAndColumnHeadersLoads row headers from frozen columns and column headers from frozen rows.
    RowHeadersLoads row headers from frozen columns in the Excel-compatible file into the spreadsheet.
    Example
    This example uses the ExcelOpenFlags enumeration.
    gcSpreadSheet1.OpenExcel("c:\\zipfile\\test.xlsx");
    //gcSpreadSheet1.OpenExcel("c:\\zipfile\\test.xlsx", "1NaMe5");
    //gcSpreadSheet1.OpenExcel("c:\\zipfile\\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.ExcelOpenFlags.DataAndFormulasOnly, "1NaMe5");
    //gcSpreadSheet1.OpenExcel("c:\\zipfile\\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.ExcelOpenFlags.RowAndColumnHeaders);
    GcSpreadSheet1.OpenExcel("c:\zipfile\test.xlsx")
    'GcSpreadSheet1.OpenExcel("c:\zipfile\test.xlsx", "1NaMe5")
    'GcSpreadSheet1.OpenExcel("c:\zipfile\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.ExcelOpenFlags.DataAndFormulasOnly, "1NaMe5")
    'GcSpreadSheet1.OpenExcel("c:\zipfile\test.xlsx", GrapeCity.Windows.SpreadSheet.Data.ExcelOpenFlags.RowAndColumnHeaders)
    Inheritance Hierarchy

    System.Object
       System.ValueType
          System.Enum
             GrapeCity.Windows.SpreadSheet.Data.ExcelOpenFlags

    See Also