Spread WPF Documentation
SaveCsv(Stream,TextFileSaveFlags,Encoding) Method
Example 


GrapeCity.Windows.SpreadSheet.Data Namespace > Worksheet Class > SaveCsv Method : SaveCsv(Stream,TextFileSaveFlags,Encoding) Method
The 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 stream As System.IO.Stream, _
   ByVal flags As TextFileSaveFlags, _
   ByVal encoding As System.Text.Encoding _
) 
'Usage
 
Dim instance As Worksheet
Dim stream As System.IO.Stream
Dim flags As TextFileSaveFlags
Dim encoding As System.Text.Encoding
 
instance.SaveCsv(stream, flags, encoding)
public void SaveCsv( 
   System.IO.Stream stream,
   TextFileSaveFlags flags,
   System.Text.Encoding encoding
)

Parameters

stream
The 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

Worksheet Class
Worksheet Members
Overload List