Spread Windows Forms 10.0 Product Documentation
Open(Stream) Method
Example 


Stream from which to load the data
Opens saved XML from a stream.
Syntax
'Declaration
 
Public Overloads Function Open( _
   ByVal stream As Stream _
) As Boolean
'Usage
 
Dim instance As FpSpread
Dim stream As Stream
Dim value As Boolean
 
value = instance.Open(stream)
public bool Open( 
   Stream stream
)

Parameters

stream
Stream from which to load the data

Return Value

Boolean: true if successful; false otherwise
Exceptions
ExceptionDescription
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.
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);
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 Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

See Also

Reference

FpSpread Class
FpSpread Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.