Save(Stream,Boolean) Method

Visual Basic
C#

'Declaration
 
Public Overloads Function Save( _
   ByVal stream As Stream, _
   ByVal dataOnly As Boolean _
) As Boolean

'Usage
 
Dim instance As FpSpread
Dim stream As Stream
Dim dataOnly As Boolean
Dim value As Boolean
 
value = instance.Save(stream, dataOnly)

public bool Save( 
   Stream stream,
   bool dataOnly
)

Parameters

stream: Stream to which to save
dataOnly: True to save only data; false otherwise

Return Value

Boolean: true if successful; false otherwise

This example saves the Spread component as a Spread XML file.

C#

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);
fpSpread1.ActiveSheet.ColumnCount = 4;
fpSpread1.ActiveSheet.RowCount = 4;
string fileName;
fileName = "..\\..\\bin\\savespreadstream.xml";
System.IO.Stream stream; 
stream = System.IO.File.Create(fileName);
fpSpread1.Save(stream, false);

Visual Basic

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)
fpSpread1.ActiveSheet.ColumnCount = 4
fpSpread1.ActiveSheet.RowCount = 4
Dim fileName As String
fileName = "..\bin\savespreadstream.xml"
Dim stream As System.IO.Stream
stream = System.IO.File.Create(fileName, System.IO.FileMode.Create)
fpSpread1.Save(stream, False)

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

Reference

FpSpread Class
FpSpread Members
Overload List