Visual Basic (Declaration) | |
---|---|
Public Overloads Function OpenExcel( _ ByVal fileName As String, _ ByVal warningList As ExcelWarningList _ ) As Boolean |
Visual Basic (Usage) | Copy Code |
---|---|
Dim instance As FpSpread Dim fileName As String Dim warningList As ExcelWarningList Dim value As Boolean value = instance.OpenExcel(fileName, warningList) |
C# | |
---|---|
public bool OpenExcel( string fileName, ExcelWarningList warningList ) |
Parameters
- fileName
- Path and name of file to open
- warningList
- Warning messages
Return Value
Boolean: true if successful; false otherwiseException | 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 opens an Excel-formatted file, and provides a list of warnings.
C# | Copy Code |
---|---|
FarPoint.Win.Spread.FpSpread fpSpread1 = new FarPoint.Win.Spread.FpSpread(); FarPoint.Win.Spread.SheetView shv = new FarPoint.Win.Spread.SheetView(); FarPoint.Excel.ExcelWarningList wList = new FarPoint.Excel.ExcelWarningList(); fpSpread1.Location = new Point(10, 10); fpSpread1.Height = 200; fpSpread1.Width = 400; Controls.Add(fpSpread1); fpSpread1.Sheets.Add(shv); string fileName; fileName = "..\\..\\bin\\Book1.xls"; try { fpSpread1.OpenExcel(fileName, wList); } catch (Exception ex) { listBox1.Items.Add(ex.ToString()); } |
Visual Basic | Copy Code |
---|---|
Dim fpSpread1 As New FarPoint.Win.Spread.FpSpread() Dim shv As New FarPoint.Win.Spread.SheetView() Dim wList As New FarPoint.Excel.ExcelWarningList() fpSpread1.Location = New Point(10, 10) fpSpread1.Height = 200 fpSpread1.Width = 400 Controls.Add(fpSpread1) fpSpread1.Sheets.Add(shv) Dim fileName As String fileName = "..\bin\Book1.xls" Try fpSpread1.OpenExcel(fileName, wList) Catch ex As Exception ListBox1.Items.Add(ex.ToString()) End Try |
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8