Opens an Excel Compound Document File and loads it into Spread.
Syntax
Visual Basic (Usage) | Copy Code |
---|
Dim instance As FpSpread
Dim stream As Stream
Dim password As String
Dim value As Boolean
value = instance.OpenExcel(stream, password) |
Parameters
- stream
- Stream that contains an Excel Compound Document File
- password
- File password
Exceptions
Example
This example uses the OpenExcel method.
C# | Copy Code |
---|
string f;
f = "D:\\savetostream.xls";
System.IO.FileStream s = new System.IO.FileStream(f, System.IO.FileMode.Open, System.IO.FileAccess.ReadWrite);
try
{
fpSpread1.OpenExcel(s, "test");
}
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, "test")
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