GrapeCity.Xaml.SpreadSheet.Data Namespace : ExcelOpenFlags Enumeration |
'Declaration <FlagsAttribute()> Public Enum ExcelOpenFlags Inherits System.Enum
'Usage Dim instance As ExcelOpenFlags
[Flags()] public enum ExcelOpenFlags : System.Enum
Member | Description |
---|---|
ColumnHeaders | Loads column headers from frozen rows in the Excel-compatible file into the spreadsheet. |
DataAndFormulasOnly | Loads formulas from the Excel-compatible file into the spreadsheet. |
DataOnly | Loads only the data from the Excel-compatible file into the spreadsheet. |
DoNotRecalculateAfterLoad | Avoids recalculation after loading the Excel-compatible file (by not setting the SheetView.AutoCalculation property to true and not calling SheetView.Recalculate()). |
NoFlagsSet | Opens the spreadsheet from the Excel-compatible file with no special options. |
RowAndColumnHeaders | Loads row headers from frozen columns and column headers from frozen rows. |
RowHeaders | Loads row headers from frozen columns in the Excel-compatible file into the spreadsheet. |
private async void Button_Click_1(object sender, RoutedEventArgs e) { try { var filePicker = new Windows.Storage.Pickers.FileOpenPicker(); filePicker.FileTypeFilter.Add(".xls"); filePicker.FileTypeFilter.Add(".xlsx"); Windows.Storage.StorageFile storageFile = await filePicker.PickSingleFileAsync(); if (storageFile != null) { using (var stream = await storageFile.OpenStreamForReadAsync()) { await gcSpreadSheet1.OpenExcelAsync(stream); //await gcSpreadSheet1.OpenExcelAsync(stream, GrapeCity.Xaml.SpreadSheet.Data.ExcelOpenFlags.RowAndColumnHeaders); } } } 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(".xls") filePicker.FileTypeFilter.Add(".xlsx") Dim storageFile As Windows.Storage.StorageFile = Await filePicker.PickSingleFileAsync() If storageFile IsNot Nothing Then Using stream = Await storageFile.OpenStreamForReadAsync() await gcSpreadSheet1.OpenExcelAsync(stream) 'await gcSpreadSheet1.OpenExcelAsync(stream, GrapeCity.Xaml.SpreadSheet.Data.ExcelOpenFlags.RowAndColumnHeaders) 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.ExcelOpenFlags
Target Platforms: Windows Server 2012, Windows RT