OpenCsv(Stream,TextFileOpenFlags,Encoding) Method

Visual Basic
C#

'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.

This example uses the OpenCsv method.

C#

OpenFileDialog openFileDialog = new OpenFileDialog();
            openFileDialog.Filter = "csv File (.csv)|*.csv";
            bool? useClick = openFileDialog.ShowDialog();
            if (useClick == true)
            {
                var stream = openFileDialog.File.OpenRead();
                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);
                stream.Dispose();
            }

VB.NET

Dim openFileDialog = New OpenFileDialog()
        openFileDialog.Filter = "csv File(.csv)|*.csv"
        Dim useClick As Boolean = openFileDialog.ShowDialog()
        If (useClick = True) Then
            Dim stream = openFileDialog.File.OpenRead()
            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)            
        End If

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

Worksheet Class
Worksheet Members
Overload List