Spread Windows Forms 6.0 Product Documentation
SaveExcel(Stream,ExcelSaveFlags) Method
See Also Example Support Options

FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > FpSpread Class > SaveExcel Method : SaveExcel(Stream,ExcelSaveFlags) Method

Visual Basic (Declaration)
Visual Basic (Usage)
C#

stream: Stream

saveFlags: Save flag

Saves the contents of the Spread component to the specified stream with the headers exported as data.

Syntax

Visual Basic (Declaration)
Public Overloads Function SaveExcel( _ ByVal stream As Stream, _ ByVal saveFlags As ExcelSaveFlags _ ) As Boolean

Visual Basic (Usage)	Copy Code
Dim instance As FpSpread Dim stream As Stream Dim saveFlags As ExcelSaveFlags Dim value As Boolean value = instance.SaveExcel(stream, saveFlags)

C#
public bool SaveExcel( Stream stream, ExcelSaveFlags saveFlags )

Parameters

stream: Stream
saveFlags: Save flag

Return Value

Boolean: true if successful; false otherwise

Exceptions

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

Example

This example saves an Excel file to a stream.

C#	Copy Code
string f; f = "D:\\formula1.xls"; System.IO.FileStream s = new System.IO.FileStream(f, IO.FileMode.Open, IO.FileAccess.ReadWrite); fpSpread1.SaveExcel(s, FarPoint.Excel.ExcelSaveFlags.NoFlagsSet); s.Close();

Copy Code

string f;  
f = "D:\\formula1.xls";  
System.IO.FileStream s = new System.IO.FileStream(f, IO.FileMode.Open, IO.FileAccess.ReadWrite); 
fpSpread1.SaveExcel(s, FarPoint.Excel.ExcelSaveFlags.NoFlagsSet);
s.Close();

Visual Basic	Copy Code
Dim f As String f = "D:\mptest.xls" Dim s As New System.IO.FileStream(f, IO.FileMode.Open,IO.FileAccess.ReadWrite) FpSpread1.SaveExcel(s, FarPoint.Excel.ExcelSaveFlags.NoFlagsSet) s.Close()

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2