Visual Basic (Declaration) | |
---|---|
Public Overloads Function OpenExcel( _ ByVal fileName As String, _ ByVal openFlags As ExcelOpenFlags, _ ByVal warningList As ExcelWarningList, _ ByVal password As String _ ) As Boolean |
Visual Basic (Usage) | Copy Code |
---|---|
Dim instance As FpSpread Dim fileName As String Dim openFlags As ExcelOpenFlags Dim warningList As ExcelWarningList Dim password As String Dim value As Boolean value = instance.OpenExcel(fileName, openFlags, warningList, password) |
C# | |
---|---|
public bool OpenExcel( string fileName, ExcelOpenFlags openFlags, ExcelWarningList warningList, string password ) |
Parameters
- fileName
- Path and name of file
- openFlags
- Open flag
- warningList
- List of Excel warnings
- password
- Password of file
Exception | Description |
---|---|
System.IO.FileNotFoundException | Specified file is not found |
System.ArgumentNullException | No file name is specified (or specified file name is null) |
System.ArgumentException | No file name is specified (or specified file name is empty) |
This example uses the OpenExcel method.
C# | Copy Code |
---|---|
string f; f = "D:\\formula1.xls"; fpSpread1.OpenExcel(f, FarPoint.Excel.ExcelOpenFlags.DataOnly, new FarPoint.Excel.ExcelWarningList(), "test"); |
Visual Basic | Copy Code |
---|---|
Dim f As String f = "D:\formula1.xls" FpSpread1.OpenExcel(f, FarPoint.Excel.ExcelOpenFlags.DataOnly, New FarPoint.Excel.ExcelWarningList(), "test") |
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8