Spread Silverlight Documentation
TextFileOpenFlags Enumeration
Example Example 


Specifies the import flags.
Syntax
'Declaration
 
<System.FlagsAttribute()>
Public Enum TextFileOpenFlags 
   Inherits System.Enum
'Usage
 
Dim instance As TextFileOpenFlags
[System.Flags()]
public enum TextFileOpenFlags : System.Enum 
Members
MemberDescription
ImportFormulaImports formulas.
IncludeColumnHeaderIncludes column headers.
IncludeRowHeaderIncludes row headers.
NoneImports with no special options.
UnFormattedLeaves the data unformatted.
Example
This example uses the TextFileOpenFlags enumeration.
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
Inheritance Hierarchy

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

Requirements

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

See Also

Reference

GrapeCity.Windows.SpreadSheet.Data Namespace

 

 


Copyright © GrapeCity, inc. All rights reserved.