OpenExcel(Stream,ExcelOpenFlags,String,Int32) Method

In This Topic

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

Syntax

Visual Basic
C#

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

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

public void OpenExcel( 
   Stream stream,
   ExcelOpenFlags openFlags,
   string password,
   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