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


GrapeCity.Windows.SpreadSheet.UI Namespace > GcSpreadSheet Class > OpenCSV Method : OpenCSV(Int32,Stream,TextFileOpenFlags) Method
The destination sheet index for loading.
Stream from which to load.
The import flags.
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 _
) 
'Usage
 
Dim instance As GcSpreadSheet
Dim sheetIndex As System.Integer
Dim stream As System.IO.Stream
Dim flags As TextFileOpenFlags
 
instance.OpenCSV(sheetIndex, stream, flags)
public void OpenCSV( 
   System.int sheetIndex,
   System.IO.Stream stream,
   TextFileOpenFlags flags
)

Parameters

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