OpenExcel(Stream,ExcelOpenFlags,String,Int32) Method

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

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub OpenExcel( _
   ByVal stream As System.IO.Stream, _
   ByVal openFlags As ExcelOpenFlags, _
   ByVal password As System.String, _
   ByVal sheetIndex As System.Integer _
)

'Usage
 
Dim instance As Workbook
Dim stream As System.IO.Stream
Dim openFlags As ExcelOpenFlags
Dim password As System.String
Dim sheetIndex As System.Integer
 
instance.OpenExcel(stream, openFlags, password, sheetIndex)

public void OpenExcel( 
   System.IO.Stream stream,
   ExcelOpenFlags openFlags,
   System.string password,
   System.int sheetIndex
)

Parameters

stream: The stream that contains an Excel Compound Document File.
openFlags: The open flags.
password: The password for the file.
sheetIndex: The index of sheet in Excel file.

Remarks

For performance considerations, this method suspends all events during the file load.

Reference

Workbook Class
Workbook Members
Overload List