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


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

Parameters

stream
Stream
openFlags
Open flag
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);

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)
See Also

Reference

FpSpread Class
FpSpread Members
Overload List