I am trying to read an Excel worksheet into my application, where the data will be manipulated in a database setting.
The code I am using is:
Dim x As Object = CreateObject("Excel.application")
Dim t as object = x.ActiveWorkbook.Sheets(1).cells(rowno, cellno).value
The problem is that in the case of formatted text (containing bold, underline etc) only the text string is retrieved. How do I read the formatting code from Excel?