SaveExcel(Stream,ExcelFileFormat,String) Method

Visual Basic
C#

'Declaration
 
Public Overloads Sub SaveExcel( _
   ByVal stream As System.IO.Stream, _
   ByVal format As ExcelFileFormat, _
   ByVal password As System.String _
)

'Usage
 
Dim instance As GcSpreadSheet
Dim stream As System.IO.Stream
Dim format As ExcelFileFormat
Dim password As System.String
 
instance.SaveExcel(stream, format, password)

public void SaveExcel( 
   System.IO.Stream stream,
   ExcelFileFormat format,
   System.string password
)

Parameters

stream: The stream to save to.
format: The file format to save to.
password: The password for the file.

This example uses the SaveExcel method.

C#

SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = "Excel File (.xlsx)|*.xlsx";
bool? useClick = saveFileDialog.ShowDialog();
if (useClick == true)
{
    var stream = saveFileDialog.OpenFile();
    gcSpreadSheet1.SaveExcel(stream, GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX);
    //gcSpreadSheet1.SaveExcel(stream, GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX, GrapeCity.Windows.SpreadSheet.Data.ExcelSaveFlags.DataOnly);
    //gcSpreadSheet1.SaveExcel(stream, GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX, GrapeCity.Windows.SpreadSheet.Data.ExcelSaveFlags.DataOnly, "12Test9");
    //gcSpreadSheet1.SaveExcel(stream, GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX, "12Test9");
    stream.Dispose();
}

VB.NET

Dim saveFileDialog = New SaveFileDialog()
saveFileDialog.Filter = "Excel File(.xlsx)|*.xlsx"
Dim useClick As Boolean = saveFileDialog.ShowDialog()
If (useClick = True) Then
    Dim stream = saveFileDialog.OpenFile()
    GcSpreadSheet1.SaveExcel(stream, GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX)
    'GcSpreadSheet1.SaveExcel(stream, GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX, GrapeCity.Windows.SpreadSheet.Data.ExcelSaveFlags.DataOnly)
    'GcSpreadSheet1.SaveExcel(stream, GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX, GrapeCity.Windows.SpreadSheet.Data.ExcelSaveFlags.DataOnly, "12Test9")
    'GcSpreadSheet1.SaveExcel(stream, GrapeCity.Windows.SpreadSheet.Data.ExcelFileFormat.XLSX, "12Test9")
End If

Reference

GcSpreadSheet Class
GcSpreadSheet Members
Overload List