Spread Windows Forms 12.0 Product Documentation
OpenExcel(Stream,ExcelOpenFlags,ExcelWarningList) Method
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > FpSpread Class > OpenExcel Method : OpenExcel(Stream,ExcelOpenFlags,ExcelWarningList) Method
Stream
Open flag
List of Excel warnings
Opens an Excel Compound Document File and loads it into Spread with a list of warnings.
Syntax
'Declaration
 
Public Overloads Function OpenExcel( _
   ByVal stream As Stream, _
   ByVal openFlags As ExcelOpenFlags, _
   ByVal warningList As ExcelWarningList _
) As Boolean
'Usage
 
Dim instance As FpSpread
Dim stream As Stream
Dim openFlags As ExcelOpenFlags
Dim warningList As ExcelWarningList
Dim value As Boolean
 
value = instance.OpenExcel(stream, openFlags, warningList)
public bool OpenExcel( 
   Stream stream,
   ExcelOpenFlags openFlags,
   ExcelWarningList warningList
)

Parameters

stream
Stream
openFlags
Open flag
warningList
List of Excel warnings
Exceptions
ExceptionDescription
No stream specified or specified stream is null
No stream specified or specified stream is empty
Example
This example opens an Excel file from a stream.
string f;  
f = "D:\\formula1.xls";  
System.IO.FileStream s = new System.IO.FileStream(f, IO.FileMode.Open, IO.FileAccess.ReadWrite); 
fpSpread1.OpenExcel(s, FarPoint.Excel.ExcelOpenFlags.DataOnly, new FarPoint.Excel.ExcelWarningList);

Dim f As String 
f = "D:\mptest.xls"
Dim s As New System.IO.FileStream(f, IO.FileMode.Open,IO.FileAccess.ReadWrite)
FpSpread1.OpenExcel(s, FarPoint.Excel.ExcelOpenFlags.DataOnly, New FarPoint.Excel.ExcelWarningList)
See Also

Reference

FpSpread Class
FpSpread Members
Overload List