What I wish to do is, take that queried data, and perform manipulation on it, such that I end up with multiple .NET CASE statements: possibly stuffing the results in a table, in a single row per result.
e.g. using the above row data from Excel, I would like to end up with:
Case 111222 MsgBox("company is:" A COMPANY NAME + Environment.NewLine + Col 1: 20 Col 2: 15 Col 3: 10)
Are you trying to query Excel data in .NET and use that in a form? Is there a reason why you have the Excel data in an .xlsx and not in a database itself?