Spread WPF Documentation
SaveCSV(Int32,Stream,TextFileSaveFlags,Encoding) Method
Example 


GrapeCity.Windows.SpreadSheet.UI Namespace > GcSpreadSheet Class > SaveCSV Method : SaveCSV(Int32,Stream,TextFileSaveFlags,Encoding) Method
The destination sheet index for saving.
Stream to which to save the content.
The export flags.
The encoding.
Saves the CSV (comma-separated values) file.
Syntax
'Declaration
 
Public Overloads Sub SaveCSV( _
   ByVal sheetIndex As System.Integer, _
   ByVal stream As System.IO.Stream, _
   ByVal flags As TextFileSaveFlags, _
   ByVal encoding As System.Text.Encoding _
) 
'Usage
 
Dim instance As GcSpreadSheet
Dim sheetIndex As System.Integer
Dim stream As System.IO.Stream
Dim flags As TextFileSaveFlags
Dim encoding As System.Text.Encoding
 
instance.SaveCSV(sheetIndex, stream, flags, encoding)
public void SaveCSV( 
   System.int sheetIndex,
   System.IO.Stream stream,
   TextFileSaveFlags flags,
   System.Text.Encoding encoding
)

Parameters

sheetIndex
The destination sheet index for saving.
stream
Stream to which to save the content.
flags
The export flags.
encoding
The encoding.
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();
            }
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
See Also

Reference

GcSpreadSheet Class
GcSpreadSheet Members
Overload List