ExcelOpenFlags Enumeration

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

Syntax

Visual Basic
C#

[System.Flags()]
public enum ExcelOpenFlags : System.Enum

'Declaration
 
<System.FlagsAttribute()>
Public Enum ExcelOpenFlags 
   Inherits System.Enum

'Usage
 
Dim instance As ExcelOpenFlags

Members

Member	Description
ColumnHeaders	Loads column headers from frozen rows in the Excel-compatible file into the spreadsheet.
DataAndFormulasOnly	Loads formulas from the Excel-compatible file into the spreadsheet.
DataOnly	Loads only the data from the Excel-compatible file into the spreadsheet.
DoNotRecalculateAfterLoad	Avoids recalculation after loading the Excel-compatible file (by not setting the SheetView.AutoCalculation property to true and not calling SheetView.Recalculate()).
NoFlagsSet	Opens the spreadsheet from the Excel-compatible file with no special options.
RowAndColumnHeaders	Loads row headers from frozen columns and column headers from frozen rows.
RowHeaders	Loads 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);

VB.NET

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

Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional (SP4), Windows XP (SP2), Windows 2008, Windows 2003 Server (SP1)

Reference

GrapeCity.Windows.SpreadSheet.Data Namespace