GrapeCity.Windows.SpreadSheet.Data Namespace : TextFileOpenFlags Enumeration |
'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. |
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(); }
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
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