OpenExcel(String,String,ExcelOpenFlags,String) Method

Visual Basic
C#

'Declaration
 
Public Overloads Function OpenExcel( _
   ByVal fileName As String, _
   ByVal sheetName As String, _
   ByVal excelOpenFlags As ExcelOpenFlags, _
   ByVal password As String _
) As Boolean

'Usage
 
Dim instance As SheetView
Dim fileName As String
Dim sheetName As String
Dim excelOpenFlags As ExcelOpenFlags
Dim password As String
Dim value As Boolean
 
value = instance.OpenExcel(fileName, sheetName, excelOpenFlags, password)

public bool OpenExcel( 
   string fileName,
   string sheetName,
   ExcelOpenFlags excelOpenFlags,
   string password
)

Parameters

fileName: Name of the file to open
sheetName: Name of the sheet in the Excel file to load
excelOpenFlags: Flags to specify file open options
password: The password

This example uses the OpenExcel method.

C#

//FpSpread1.Sheets[0].OpenExcel("c:\\controls\\book1.xlsx", "Sheet1", FarPoint.Excel.ExcelOpenFlags.DataOnly);
//FpSpread1.Sheets[0].OpenExcel("c:\\controls\\book1.xlsx", "Sheet1", FarPoint.Excel.ExcelOpenFlags.DataOnly, "123*");
//FpSpread1.Sheets[0].OpenExcel("c:\\controls\\book1.xlsx", 0, FarPoint.Excel.ExcelOpenFlags.DataOnly);
FpSpread1.Sheets[0].OpenExcel("c:\\controls\\book1.xlsx", 0, FarPoint.Excel.ExcelOpenFlags.DataOnly, "123*");

VB.NET

'FpSpread1.Sheets(0).OpenExcel("c:\controls\book1.xlsx", "Sheet1", FarPoint.Excel.ExcelOpenFlags.DataOnly)
'FpSpread1.Sheets(0).OpenExcel("c:\controls\book1.xlsx", "Sheet1", FarPoint.Excel.ExcelOpenFlags.DataOnly, "123*")
'FpSpread1.Sheets(0).OpenExcel("c:\controls\book1.xlsx", 0, FarPoint.Excel.ExcelOpenFlags.DataOnly)
FpSpread1.Sheets(0).OpenExcel("c:\controls\book1.xlsx", 0, FarPoint.Excel.ExcelOpenFlags.DataOnly, "123*")

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

SheetView Class
SheetView Members
Overload List