TextFileOpenFlags Enumeration

Visual Basic
C#

'Declaration
 
<System.FlagsAttribute()>
Public Enum TextFileOpenFlags 
   Inherits System.Enum

'Usage
 
Dim instance As TextFileOpenFlags

[System.Flags()]
public enum TextFileOpenFlags : System.Enum

Member	Description
ImportFormula	Imports formulas.
IncludeColumnHeader	Includes column headers.
IncludeRowHeader	Includes row headers.
None	Imports with no special options.
UnFormatted	Leaves the data unformatted.

This example uses the TextFileOpenFlags enumeration.

C#

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

System.Object
   System.ValueType
      System.Enum
         GrapeCity.Windows.SpreadSheet.Data.TextFileOpenFlags

Reference

GrapeCity.Windows.SpreadSheet.Data Namespace