Opens an Excel Compound Document File and loads it into Spread.
Syntax
| Visual Basic (Declaration) | |
|---|
Public Overloads Function OpenExcel( _
ByVal stream As Stream _
) As Boolean |
| Visual Basic (Usage) |  Copy Code |
|---|
Dim instance As FpSpread
Dim stream As Stream
Dim value As Boolean
value = instance.OpenExcel(stream) |
Parameters
- stream
- Stream that contains an Excel Compound Document File
Return Value
Boolean:
true if successful;
false otherwise
Exceptions
Example
This example opens an excel file.
| C# | Copy Code |
|---|
string f;
f = "D:\\pic.xls";
System.IO.FileStream s = new System.IO.FileStream(f, IO.FileMode.Open, IO.FileAccess.ReadWrite);
try
{
fpSpread1.OpenExcel(s);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
|
| Visual Basic | Copy Code |
|---|
Dim f As String
f = "D:\savetostream.xls"
Dim s As New System.IO.FileStream(f, IO.FileMode.Open, IO.FileAccess.ReadWrite)
Try
FpSpread1.OpenExcel(s)
Catch ex As Exception
MessageBox.Show(ex.Message)
End Try |
Requirements
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8
See Also
