Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Overloads Function OpenExcel( _ ByVal fileName As String, _ ByVal excelOpenFlags 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 excelOpenFlags As ExcelOpenFlags Dim warningList As ExcelWarningList Dim password As String Dim value As Boolean value = instance.OpenExcel(fileName, excelOpenFlags, warningList, password) | |
| C# | |
|---|---|
public bool OpenExcel( string fileName, ExcelOpenFlags excelOpenFlags, ExcelWarningList warningList, string password ) | |
Parameters
- fileName
- Path and name of file to open
- excelOpenFlags
- Which parts of the spreadsheet to load
- warningList
- List of warning messages that occur during this operation
- password
- The password
Example
This example loads an Excel-formatted file.
| C# | Copy Code |
|---|---|
FpSpread1.OpenExcel("C:\\savedinexcel.xls", FarPoint.Excel.ExcelOpenFlags.DataOnly, new FarPoint.Excel.ExcelWarningList, "test"); | |
| Copy Code | |
|---|---|
FpSpread1.OpenExcel("C:\savedinexcel.xls", FarPoint.Excel.ExcelOpenFlags.DataOnly, New FarPoint.Excel.ExcelWarningList, "test") | |
Requirements
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6