SaveCSV(Int32,Stream,TextFileSaveFlags) Method

Saves the CSV (comma-separated values) file.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub SaveCSV( _
   ByVal sheetIndex As System.Integer, _
   ByVal stream As System.IO.Stream, _
   ByVal flags As TextFileSaveFlags _
)

'Usage
 
Dim instance As GcSpreadSheet
Dim sheetIndex As System.Integer
Dim stream As System.IO.Stream
Dim flags As TextFileSaveFlags
 
instance.SaveCSV(sheetIndex, stream, flags)

public void SaveCSV( 
   System.int sheetIndex,
   System.IO.Stream stream,
   TextFileSaveFlags flags
)

Parameters

sheetIndex: The destination sheet index for saving.
stream: Stream to which to save the content.
flags: The export flags.

Example

This example uses the SaveCSV method.

Microsoft.Win32.SaveFileDialog saveFileDialog = new Microsoft.Win32.SaveFileDialog();
            saveFileDialog.Filter = "csv File (.csv)|*.csv";
            bool? useClick = saveFileDialog.ShowDialog();
            if (useClick == true)
            {
                var stream = saveFileDialog.OpenFile();
                gcSpreadSheet1.Sheets[0].SaveCsv(stream, GrapeCity.Windows.SpreadSheet.Data.TextFileSaveFlags.None);
                //gcSpreadSheet1.Sheets[0].SaveCsv(stream, GrapeCity.Windows.SpreadSheet.Data.TextFileSaveFlags.None, System.Text.Encoding.UTF8);
                //gcSpreadSheet1.Sheets[0].SaveCsv(0,0,5,5,stream,GrapeCity.Windows.SpreadSheet.Data.TextFileSaveFlags.None);
                //gcSpreadSheet1.Sheets[0].SaveCsv(0,0,5,5,stream, GrapeCity.Windows.SpreadSheet.Data.TextFileSaveFlags.None, System.Text.Encoding.UTF8);
                //gcSpreadSheet1.SaveCSV(0, stream, GrapeCity.Windows.SpreadSheet.Data.TextFileSaveFlags.None);
                //gcSpreadSheet1.SaveCSV(0, stream, GrapeCity.Windows.SpreadSheet.Data.TextFileSaveFlags.None, System.Text.Encoding.UTF8);
                stream.Dispose();
            }

VB.NET

Dim saveFileDialog = New Microsoft.Win32.SaveFileDialog()
       saveFileDialog.Filter = "csv File(.csv)|*.csv"
       Dim useClick As Boolean = saveFileDialog.ShowDialog()
       If (useClick = True) Then
           Dim stream = saveFileDialog.OpenFile()
           GcSpreadSheet1.Sheets(0).SaveCsv(stream, GrapeCity.Windows.SpreadSheet.Data.TextFileSaveFlags.None)
           'GcSpreadSheet1.Sheets(0).SaveCsv(stream, GrapeCity.Windows.SpreadSheet.Data.TextFileSaveFlags.None, System.Text.Encoding.UTF8)
           'GcSpreadSheet1.Sheets(0).SaveCsv(0, 0, 5, 5, stream, GrapeCity.Windows.SpreadSheet.Data.TextFileSaveFlags.None)
           'GcSpreadSheet1.Sheets(0).SaveCsv(0, 0, 5, 5, stream, GrapeCity.Windows.SpreadSheet.Data.TextFileSaveFlags.None, System.Text.Encoding.UTF8)
           'GcSpreadSheet1.SaveCSV(0, stream, GrapeCity.Windows.SpreadSheet.Data.TextFileSaveFlags.None)
           'GcSpreadSheet1.SaveCSV(0, stream, GrapeCity.Windows.SpreadSheet.Data.TextFileSaveFlags.None, System.Text.Encoding.UTF8)
            stream.Dispose()
       End If

Reference

GcSpreadSheet Class
GcSpreadSheet Members
Overload List