Visual Basic (Declaration) | |
---|---|
Public Overloads Function OpenExcel( _ ByVal stream As Stream, _ ByVal warningList As ExcelWarningList _ ) As Boolean |
Visual Basic (Usage) | Copy Code |
---|---|
Dim instance As FpSpread Dim stream As Stream Dim warningList As ExcelWarningList Dim value As Boolean value = instance.OpenExcel(stream, warningList) |
C# | |
---|---|
public bool OpenExcel( Stream stream, ExcelWarningList warningList ) |
Parameters
- stream
- Stream
- warningList
- List of Excel warnings
Return Value
Boolean: true if successful; false otherwiseException | Description |
---|---|
System.ArgumentNullException | No stream specified or specified stream is null |
System.ArgumentException | No stream specified or specified stream is empty |
This example opens an Excel file from a stream.
C# | Copy Code |
---|---|
string f; f = "D:\\pic.xls"; System.IO.FileStream s = new System.IO.FileStream(f, IO.FileMode.Open, IO.FileAccess.ReadWrite); FarPoint.Excel.ExcelWarningList wl = new FarPoint.Excel.ExcelWarningList(); try { fpSpread1.OpenExcel(s, wl); } catch (Exception ex) { MessageBox.Show(ex.Message); } |
Visual Basic | Copy Code |
---|---|
Dim f As String f = "D:\testforexception.xls" Dim s As New System.IO.FileStream(f, IO.FileMode.Open, IO.FileAccess.ReadWrite) Dim wl As New FarPoint.Excel.ExcelWarningList Try FpSpread1.OpenExcel(s, wl) Catch ex As Exception MessageBox.Show(ex.Message) 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