OpenExcel(String,ExcelOpenFlags,String) Method

Opens an Excel Compound Document File and loads it into GcSpreadSheet.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub OpenExcel( _
   ByVal file As System.String, _
   ByVal openFlags As ExcelOpenFlags, _
   ByVal password As System.String _
)

'Usage
 
Dim instance As GcSpreadSheet
Dim file As System.String
Dim openFlags As ExcelOpenFlags
Dim password As System.String
 
instance.OpenExcel(file, openFlags, password)

public void OpenExcel( 
   System.string file,
   ExcelOpenFlags openFlags,
   System.string password
)

Parameters

file: The path to load the file from.
openFlags: The flags used to open the file.
password: The password used to open the file.

Example

This example uses the OpenExcel method.

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)

Reference

GcSpreadSheet Class
GcSpreadSheet Members
Overload List