Spread WPF Documentation
OpenCSV(Int32,Stream,TextFileOpenFlags,Encoding) Method
Example 


GrapeCity.Windows.SpreadSheet.UI Namespace > GcSpreadSheet Class > OpenCSV Method : OpenCSV(Int32,Stream,TextFileOpenFlags,Encoding) Method
The destination sheet index for loading.
Stream from which to load.
The import flags.
The encoding.
Loads the CSV (comma-separated values) file.
Syntax
'Declaration
 
Public Overloads Sub OpenCSV( _
   ByVal sheetIndex As System.Integer, _
   ByVal stream As System.IO.Stream, _
   ByVal flags As TextFileOpenFlags, _
   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 TextFileOpenFlags
Dim encoding As System.Text.Encoding
 
instance.OpenCSV(sheetIndex, stream, flags, encoding)
public void OpenCSV( 
   System.int sheetIndex,
   System.IO.Stream stream,
   TextFileOpenFlags flags,
   System.Text.Encoding encoding
)

Parameters

sheetIndex
The destination sheet index for loading.
stream
Stream from which to load.
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

GcSpreadSheet Class
GcSpreadSheet Members
Overload List