TextFileOpenFlags Enumeration

Visual Basic
C#

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

'Usage
 
Dim instance As TextFileOpenFlags

[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#
VB.NET

private async void Button_Click_1(object sender, RoutedEventArgs e)
        {
            try
            {
                var filePicker = new Windows.Storage.Pickers.FileOpenPicker();
                filePicker.FileTypeFilter.Add(".txt");                
                Windows.Storage.StorageFile storageFile = await filePicker.PickSingleFileAsync();
                if (storageFile != null)
                {
                    using (var stream = await storageFile.OpenStreamForReadAsync())
                    {
await gcSpreadSheet1.Sheets[0].OpenTextFileAsync(stream, GrapeCity.Xaml.SpreadSheet.Data.TextFileOpenFlags.None, "\r", ",", "");
//await gcSpreadSheet1.Sheets[0].OpenTextFileAsync(stream, GrapeCity.Xaml.SpreadSheet.Data.TextFileOpenFlags.None, "\r", ",", "", System.Text.Encoding.UTF8);
//await gcSpreadSheet1.OpenTextFileAsync(0, stream, GrapeCity.Xaml.SpreadSheet.Data.TextFileOpenFlags.None, "\r", ",", "");
                    }
                }
            }
            catch (Exception ex)
            {
                Windows.UI.Popups.MessageDialog dialog = new Windows.UI.Popups.MessageDialog(ex.Message, "Error");
                dialog.ShowAsync();
            }
        }

Private Async Sub Button_Click_1(sender As Object, e As RoutedEventArgs)
        Try
            Dim filePicker As New Windows.Storage.Pickers.FileOpenPicker()
            filePicker.FileTypeFilter.Add(".txt")
            Dim storageFile As Windows.Storage.StorageFile = Await filePicker.PickSingleFileAsync()
            If storageFile IsNot Nothing Then
                Using stream = Await storageFile.OpenStreamForReadAsync()
                    await GcSpreadSheet1.Sheets(0).OpenTextFileAsync(stream, GrapeCity.Xaml.SpreadSheet.Data.TextFileOpenFlags.None, ChrW(13), ",", "")
                   'await GcSpreadSheet1.Sheets(0).OpenTextFileAsync(stream, GrapeCity.Xaml.SpreadSheet.Data.TextFileOpenFlags.None, ChrW(13), ",", "", System.Text.Encoding.UTF8)
                   'await GcSpreadSheet1.OpenTextFileAsync(0, stream, GrapeCity.Xaml.SpreadSheet.Data.TextFileOpenFlags.None, ChrW(13), ",", "")
                End Using
            End If
        Catch ex As Exception
            Dim dialog As Windows.UI.Popups.MessageDialog = New Windows.UI.Popups.MessageDialog(ex.Message, "Error")
            dialog.ShowAsync()
        End Try
    End Sub

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

Reference

GrapeCity.Xaml.SpreadSheet.Data Namespace