|123602||Apr 2,2016 02:21 PM||Apr 7,2016 01:48 AM||UWP||3|
var picker = new FileOpenPicker();
picker.ViewMode = PickerViewMode.List;
var tempFile = await picker.PickSingleFileAsync();
if (tempFile != null)
var exStream = await tempFile.OpenStreamForReadAsync();
ExcelEngine excelEngine = new ExcelEngine();
IApplication application = excelEngine.Excel;
IWorkbook workbook = await application.Workbooks.OpenAsync(exStream, ",");
var data = workbook.Worksheets.Rows;
this.CsvGrid.ItemsSource = data;
We have analyzed your query and we regret to inform you that, you cannot directly get the items from WorkBook and assign it to Grid’s ItemSource. We need to manually get the items from Worksheet and assign it to a collection then assign the Grid’s ItemSource.
Jai Ganesh S
This post will be permanently deleted. Are you sure you want to continue?
Sorry, An error occured while processing your request. Please try again later.