OpenCsv(Stream,TextFileOpenFlags) Method

Visual Basic
C#

'Declaration
 
Public Overloads Sub OpenCsv( _
   ByVal stream As System.IO.Stream, _
   ByVal flags As TextFileOpenFlags _
)

'Usage
 
Dim instance As Worksheet
Dim stream As System.IO.Stream
Dim flags As TextFileOpenFlags
 
instance.OpenCsv(stream, flags)

public void OpenCsv( 
   System.IO.Stream stream,
   TextFileOpenFlags flags
)

Parameters

stream: The stream from which to load the file.
flags: The import flags.

This example uses the OpenCsv method.

C#

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();
            }

VB.NET

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

Reference

Worksheet Class
Worksheet Members
Overload List