Opens saved XML from a stream.

Syntax

Visual Basic (Declaration)
Public Overloads Function Open( _ 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.Open(stream)

C#
public bool Open( Stream stream )

Parameters

stream: Stream from which to load the data

Return Value

Boolean: true if successful; false otherwise

Exceptions

Exception	Description
System.ArgumentNullException	No stream specified or specified stream is null

Remarks

This method opens a stream, which means replacing anything in the spreadsheet and overwriting it with the contents of the stream. If you want to load only the data into the existing spreadsheet without overwriting anything else, use the SheetView's LoadTextFile method.

Example

This example opens a file.

C#	Copy Code
FarPoint.Win.Spread.FpSpread fpSpread1 = new FarPoint.Win.Spread.FpSpread(); FarPoint.Win.Spread.SheetView shv = new FarPoint.Win.Spread.SheetView(); fpSpread1.Location = new Point(10, 10); fpSpread1.Height = 200; fpSpread1.Width = 400; Controls.Add(fpSpread1); fpSpread1.Sheets.Add(shv); string fileName; fileName = "..\\..\\bin\\testsaveopen.xml"; System.IO.Stream stream; stream = System.IO.File.Open(fileName, System.IO.FileMode.Open); fpSpread1.Open(stream);

Copy Code

FarPoint.Win.Spread.FpSpread fpSpread1 = new FarPoint.Win.Spread.FpSpread();
FarPoint.Win.Spread.SheetView shv = new FarPoint.Win.Spread.SheetView();
fpSpread1.Location = new Point(10, 10);
fpSpread1.Height = 200;
fpSpread1.Width = 400;
Controls.Add(fpSpread1);
fpSpread1.Sheets.Add(shv);
string fileName;
fileName = "..\\..\\bin\\testsaveopen.xml";
System.IO.Stream stream; 
stream = System.IO.File.Open(fileName, System.IO.FileMode.Open);
fpSpread1.Open(stream);

Visual Basic	Copy Code
Dim fpSpread1 As New FarPoint.Win.Spread.FpSpread() Dim shv As New FarPoint.Win.Spread.SheetView() fpSpread1.Location = New Point(10, 10) fpSpread1.Height = 200 fpSpread1.Width = 400 Controls.Add(fpSpread1) fpSpread1.Sheets.Add(shv) Dim fileName As String fileName = "..\bin\testsaveopen.xml" Dim stream As System.IO.Stream stream = System.IO.File.Open(fileName, System.IO.FileMode.Open) fpSpread1.Open(stream)

Visual Basic

Copy Code

Dim fpSpread1 As New FarPoint.Win.Spread.FpSpread()
Dim shv As New FarPoint.Win.Spread.SheetView()
fpSpread1.Location = New Point(10, 10)
fpSpread1.Height = 200
fpSpread1.Width = 400
Controls.Add(fpSpread1)
fpSpread1.Sheets.Add(shv)
Dim fileName As String
fileName = "..\bin\testsaveopen.xml"
Dim stream As System.IO.Stream
stream = System.IO.File.Open(fileName, System.IO.FileMode.Open)
fpSpread1.Open(stream)

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