OpenTextFile(Stream,TextFileOpenFlags,String,String,String,Encoding) Method

Loads delimited text from a specified stream into the sheet, with or without headers, with the specified encoding.

Syntax

Visual Basic
C#

'Declaration
 
Public Overloads Sub OpenTextFile( _
   ByVal stream As System.IO.Stream, _
   ByVal flags As TextFileOpenFlags, _
   ByVal rowDelimiter As System.String, _
   ByVal columnDelimiter As System.String, _
   ByVal cellDelimiter As System.String, _
   ByVal encoding As System.Text.Encoding _
)

'Usage
 
Dim instance As Worksheet
Dim stream As System.IO.Stream
Dim flags As TextFileOpenFlags
Dim rowDelimiter As System.String
Dim columnDelimiter As System.String
Dim cellDelimiter As System.String
Dim encoding As System.Text.Encoding
 
instance.OpenTextFile(stream, flags, rowDelimiter, columnDelimiter, cellDelimiter, encoding)

public void OpenTextFile( 
   System.IO.Stream stream,
   TextFileOpenFlags flags,
   System.string rowDelimiter,
   System.string columnDelimiter,
   System.string cellDelimiter,
   System.Text.Encoding encoding
)

Parameters

stream: The stream from which to load data.
flags: The import flags.
rowDelimiter: The row delimiter string.
columnDelimiter: The column delimiter string.
cellDelimiter: The cell delimiter string.
encoding: The encoding.

Example

This example uses the OpenTextFile method.

VB.NET

OpenFileDialog openFileDialog = new OpenFileDialog();
openFileDialog.Filter = "Text File (.txt)|*.txt";
bool? useClick = openFileDialog.ShowDialog();
if (useClick == true)
{
    var stream = openFileDialog.File.OpenRead();
    stream.Seek(0, System.IO.SeekOrigin.Begin);
gcSpreadSheet1.Sheets[0].OpenTextFile(stream, GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None, "\r", ",", "");
//gcSpreadSheet1.Sheets[0].OpenTextFile(stream, GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None, "\r", ",", "", System.Text.Encoding.UTF8);
//gcSpreadSheet1.OpenTextFile(0, stream, GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None, "\r", ",", "");
stream.Dispose();
}

VB.NET

Dim openFileDialog = New OpenFileDialog()
openFileDialog.Filter = "Text File(.txt)|*.txt"
Dim useClick As Boolean = openFileDialog.ShowDialog()
If (useClick = True) Then
    Dim stream = openFileDialog.File.OpenRead()
    stream.Seek(0, IO.SeekOrigin.Begin)
GcSpreadSheet1.Sheets(0).OpenTextFile(stream, GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None, Chr(13), ",", "")
'GcSpreadSheet1.Sheets(0).OpenTextFile(stream, GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None, Chr(13), ",", "", System.Text.Encoding.UTF8)
'GcSpreadSheet1.OpenTextFile(0, stream, GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags.None, Chr(13), ",", "")
End If

Reference

Worksheet Class
Worksheet Members
Overload List