FarPoint.Win.Spread.SheetView.OpenExcel

OpenExcel Method

OpenExcel(Stream, string)

Opens an Excel stream and loads the specified sheet (by name) from that file into this sheet.

Declaration

public bool OpenExcel(Stream stream, string excelSheetName)

Public Function OpenExcel(stream As Stream, excelSheetName As String) As Boolean

Parameters

Type	Name	Description
Stream	stream	stream
string	excelSheetName	Name of the sheet to load from the file

Returns

Type	Description
bool	TRUE if success. Otherwise, FALSE

OpenExcel(Stream, string, string)

Opens an Excel stream and loads the specified sheet (by name) from that file into this sheet.

Declaration

public bool OpenExcel(Stream stream, string excelSheetName, string password)

Public Function OpenExcel(stream As Stream, excelSheetName As String, password As String) As Boolean

Parameters

Type	Name	Description
Stream	stream	stream
string	excelSheetName	Name of the sheet to load from the file
string	password	Password

Returns

Type	Description
bool	TRUE if success. Otherwise, FALSE

OpenExcel(Stream, int)

Opens an Excel stream and loads the specified sheet (by number) from that file into this sheet.

Declaration

public bool OpenExcel(Stream stream, int excelSheetIndex)

Public Function OpenExcel(stream As Stream, excelSheetIndex As Integer) As Boolean

Parameters

Type	Name	Description
Stream	stream	stream
int	excelSheetIndex	Index of the sheet to load from the file

Returns

Type	Description
bool	TRUE if success. Otherwise, FALSE

OpenExcel(Stream, int, string)

Opens an Excel stream and loads the specified sheet (by number) from that file into this sheet.

Declaration

public bool OpenExcel(Stream stream, int excelSheetIndex, string password)

Public Function OpenExcel(stream As Stream, excelSheetIndex As Integer, password As String) As Boolean

Parameters

Type	Name	Description
Stream	stream	stream
int	excelSheetIndex	Index of the sheet to load from the file
string	password	Password

Returns

Type	Description
bool	TRUE if success. Otherwise, FALSE

OpenExcel(string, string)

Opens an Excel file and loads the specified sheet (by name) from that file into this sheet.

Declaration

public bool OpenExcel(string fileName, string excelSheetName)

Public Function OpenExcel(fileName As String, excelSheetName As String) As Boolean

Parameters

Type	Name	Description
string	fileName	Path and name of the file to open
string	excelSheetName	Name of the sheet to load from the file

Returns

Type	Description
bool	true if successful; false otherwise

OpenExcel(string, string, string)

Opens an Excel file and loads the specified sheet (by name) from that file into this sheet.

Declaration

public bool OpenExcel(string fileName, string excelSheetName, string password)

Public Function OpenExcel(fileName As String, excelSheetName As String, password As String) As Boolean

Parameters

Type	Name	Description
string	fileName	Path and name of the file to open
string	excelSheetName	Name of the sheet to load from the file
string	password	Password

Returns

Type	Description
bool	true if successful; false otherwise

OpenExcel(string, int)

Opens an Excel file and loads the specified sheet (by number) from that file into this sheet.

Declaration

public bool OpenExcel(string fileName, int excelSheetIndex)

Public Function OpenExcel(fileName As String, excelSheetIndex As Integer) As Boolean

Parameters

Type	Name	Description
string	fileName	Path and name of the file to open
int	excelSheetIndex	Index of the sheet to load from the file

Returns

Type	Description
bool	true if successful; false otherwise

OpenExcel(string, int, string)

Opens an Excel file and loads the specified sheet (by number) from that file into this sheet.

Declaration

public bool OpenExcel(string fileName, int excelSheetIndex, string password)

Public Function OpenExcel(fileName As String, excelSheetIndex As Integer, password As String) As Boolean

Parameters

Type	Name	Description
string	fileName	Path and name of the file to open
int	excelSheetIndex	Index of the sheet to load from the file
string	password	Password

Returns

Type	Description
bool	true if successful; false otherwise