SaveExcel(Stream,ExcelFileFormat,ExcelSaveFlags) Method

Visual Basic
C#

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

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

public void SaveExcel( 
   System.IO.Stream stream,
   ExcelFileFormat format,
   ExcelSaveFlags saveFlags
)

Parameters

stream: The stream to save to.
format: The file format to save to.
saveFlags: Options for saving to a 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

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

GcSpreadSheet Class
GcSpreadSheet Members
Overload List