This is probably a very trivial issue, but - just starting with UI for Winforms - I am unable to access the data apparently loaded in the workbook below (what I am trying to do is to load an excel file in a Worksheet to use it in a datatable)
When I run this, it goes well, but the only output displayed by the Debug.Writeline instruction is :
Private Sub RadButton1_Click(sender As Object, e As EventArgs) Handles RadButton1.Click
Dim fileName As String = "C:\Users\patrick\testfile.xlsx"
Dim MyWorkbook As New Telerik.Windows.Documents.Spreadsheet.Model.Workbook
Dim WorkbookFormatProvider As New XlsxFormatProvider()
Dim MyInput As New FileStream(fileName, FileMode.Open)
MyWorkbook = WorkbookFormatProvider.Import(MyInput)
Dim MySheet As Worksheet = MyWorkbook.Sheets.ActiveSheet
RadSpreadsheet1 = MyWorkbook.Sheets
Dim Res As String = MySheet.Cells(1, 1).GetValue().ToString
Debug.WriteLine(" > " & Res)
Can someone be kind to tell me what I do wrong ?
(using Win 11, VS 2019, DEvCraft UI)