Spread ASP.NET 6.0 Product Documentation
SaveExcel(Stream,ExcelSaveFlags,ExcelWarningList,String) Method
See Also Example Send Feedback

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

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

stream: Stream to save the file to as an Excel Compound Storage file

saveFlags: Which parts of the spreadsheet to save

warningList: List of warning messages that occur during this operation

password: Password of file

Saves the contents of the Spread component to the specified Excel file in a stream, keeping track of warnings.

Syntax

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

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

Visual Basic (Usage)

Copy Code

Dim instance As FpSpread
Dim stream As Stream
Dim saveFlags As ExcelSaveFlags
Dim warningList As ExcelWarningList
Dim password As String
Dim value As Boolean
 
value = instance.SaveExcel(stream, saveFlags, warningList, password)

C#
public bool SaveExcel( Stream stream, ExcelSaveFlags saveFlags, ExcelWarningList warningList, string password )

Parameters

stream: Stream to save the file to as an Excel Compound Storage file
saveFlags: Which parts of the spreadsheet to save
warningList: List of warning messages that occur during this operation
password: Password of file

Example

This example uses the SaveExcel method.

C#	Copy Code
string f; f = "D:\savexcel.xls"; System.IO.FileStream s = new System.IO.FileStream(f, IO.FileMode.OpenorCreate, IO.FileAccess.ReadWrite); FarPoint.Excel.ExcelWarningList w = new FarPoint.Excel.ExcelWarningList(); FpSpread1.SaveExcel(s, FarPoint.Excel.ExcelSaveFlags.NoFlagsSet, w, "test");

Copy Code

string f;
f = "D:\savexcel.xls";
System.IO.FileStream s = new System.IO.FileStream(f, IO.FileMode.OpenorCreate, IO.FileAccess.ReadWrite);
FarPoint.Excel.ExcelWarningList w = new FarPoint.Excel.ExcelWarningList();
FpSpread1.SaveExcel(s, FarPoint.Excel.ExcelSaveFlags.NoFlagsSet, w, "test");

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

Visual Basic

Copy Code

Dim f As String
f = "D:\savexcel.xls"
Dim s As New System.IO.FileStream(f, IO.FileMode.OpenOrCreate, IO.FileAccess.ReadWrite)
Dim w As New FarPoint.Excel.ExcelWarningList
FpSpread1.SaveExcel(s, FarPoint.Excel.ExcelSaveFlags.NoFlagsSet, w, "test")

Requirements

Target Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

Syntax

Parameters

Example

Requirements

See Also

Reference