GrapeCity.Xaml.SpreadSheet.UI
OpenCSVAsync(Int32,Stream,TextFileOpenFlags,Encoding) Method
Example 


The destination sheet index for loading.
Stream from which to load.
The import flags.
The encoding.
Loads the CSV (comma-separated values) file asynchronously.
Syntax
'Declaration
 
Public Overloads Function OpenCSVAsync( _
   ByVal sheetIndex As Integer, _
   ByVal stream As Stream, _
   ByVal flags As TextFileOpenFlags, _
   ByVal encoding As Encoding _
) As IAsyncAction
'Usage
 
Dim instance As GcSpreadSheet
Dim sheetIndex As Integer
Dim stream As Stream
Dim flags As TextFileOpenFlags
Dim encoding As Encoding
Dim value As IAsyncAction
 
value = instance.OpenCSVAsync(sheetIndex, stream, flags, encoding)
public IAsyncAction OpenCSVAsync( 
   int sheetIndex,
   Stream stream,
   TextFileOpenFlags flags,
   Encoding encoding
)

Parameters

sheetIndex
The destination sheet index for loading.
stream
Stream from which to load.
flags
The import flags.
encoding
The encoding.
Example
This example uses the OpenCsvAsync method.
private async void Button_Click_1(object sender, RoutedEventArgs e)
        {
            try
            {
                var filePicker = new Windows.Storage.Pickers.FileOpenPicker();
                filePicker.FileTypeFilter.Add(".csv");                
                Windows.Storage.StorageFile storageFile = await filePicker.PickSingleFileAsync();
                if (storageFile != null)
                {
                    using (var stream = await storageFile.OpenStreamForReadAsync())
                    {
                 await gcSpreadSheet1.Sheets[0].OpenCsvAsync(stream, GrapeCity.Xaml.SpreadSheet.Data.TextFileOpenFlags.None);
                //await gcSpreadSheet1.Sheets[0].OpenCsvAsync(stream, GrapeCity.Xaml.SpreadSheet.Data.TextFileOpenFlags.None, System.Text.Encoding.UTF8);
                //await gcSpreadSheet1.OpenCSVAsync(0, stream, GrapeCity.Xaml.SpreadSheet.Data.TextFileOpenFlags.None);
                //await gcSpreadSheet1.OpenCSVAsync(0, stream, GrapeCity.Xaml.SpreadSheet.Data.TextFileOpenFlags.None);
                    }
                }
            }
            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(".csv")
            Dim storageFile As Windows.Storage.StorageFile = Await filePicker.PickSingleFileAsync()
            If storageFile IsNot Nothing Then
                Using stream = Await storageFile.OpenStreamForReadAsync()
             await GcSpreadSheet1.Sheets(0).OpenCsvAsync(stream, GrapeCity.Xaml.SpreadSheet.Data.TextFileOpenFlags.None)
            'await GcSpreadSheet1.Sheets(0).OpenCsvAsync(stream, GrapeCity.Xaml.SpreadSheet.Data.TextFileOpenFlags.None, System.Text.Encoding.UTF8)         
            'await GcSpreadSheet1.OpenCSVAsync(0, stream, GrapeCity.Xaml.SpreadSheet.Data.TextFileOpenFlags.None)
            'await GcSpreadSheet1.OpenCSVAsync(0, stream, GrapeCity.Xaml.SpreadSheet.Data.TextFileOpenFlags.None, System.Text.Encoding.UTF8)   
                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
Requirements

Target Platforms: Windows Server 2012, Windows RT

See Also

Reference

GcSpreadSheet Class
GcSpreadSheet Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.

Support Options