Spread WPF Documentation
OpenCsv(Stream,TextFileOpenFlags,Encoding) Method
Example 


GrapeCity.Windows.SpreadSheet.Data Namespace > Worksheet Class > OpenCsv Method : OpenCsv(Stream,TextFileOpenFlags,Encoding) Method
The stream from which to load to file.
The import flags.
The encoding.
Loads the CSV (comma-separated values) file.
Syntax
'Declaration
 
Public Overloads Sub OpenCsv( _
   ByVal stream As System.IO.Stream, _
   ByVal flags As TextFileOpenFlags, _
   ByVal encoding As System.Text.Encoding _
) 
'Usage
 
Dim instance As Worksheet
Dim stream As System.IO.Stream
Dim flags As TextFileOpenFlags
Dim encoding As System.Text.Encoding
 
instance.OpenCsv(stream, flags, encoding)
public void OpenCsv( 
   System.IO.Stream stream,
   TextFileOpenFlags flags,
   System.Text.Encoding encoding
)

Parameters

stream
The stream from which to load to file.
flags
The import flags.
encoding
The encoding.
Example
This example uses the OpenCsv method.
Microsoft.Win32.OpenFileDialog openFileDialog = new Microsoft.Win32.OpenFileDialog();
            openFileDialog.Filter = "csv File (.csv)|*.csv";
            bool? useClick = openFileDialog.ShowDialog();
            if (useClick == true)
            {
                var stream = openFileDialog.OpenFile();
                stream.Seek(0, System.IO.SeekOrigin.Begin);
                gcSpreadSheet1.Sheets[0].OpenCsv(stream,GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None);
                //gcSpreadSheet1.Sheets[0].OpenCsv(stream, GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None, System.Text.Encoding.UTF8);
                //gcSpreadSheet1.OpenCSV(0, stream, GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None);
                //gcSpreadSheet1.OpenCSV(0, stream, GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None, System.Text.Encoding.UTF8);
                stream.Dispose();
            }
Dim openFileDialog = New Microsoft.Win32.OpenFileDialog()
        openFileDialog.Filter = "csv File(.csv)|*.csv"
        Dim useClick As Boolean = openFileDialog.ShowDialog()
        If (useClick = True) Then
            Dim stream = openFileDialog.OpenFile()
            stream.Seek(0, IO.SeekOrigin.Begin)
            GcSpreadSheet1.Sheets(0).OpenCsv(stream, GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None)
            'GcSpreadSheet1.Sheets(0).OpenCsv(stream, GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None, System.Text.Encoding.UTF8)
            'GcSpreadSheet1.OpenCSV(0, stream, GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None)
            'GcSpreadSheet1.OpenCSV(0, stream, GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None, System.Text.Encoding.UTF8)
            stream.Dispose()
        End If
See Also

Reference

Worksheet Class
Worksheet Members
Overload List