Help request for vb .net in excel
kh,
You can use an OleDbDataReader (ADO.NET) and query the cells in your range:
Dim cmd As OleDbCommand = dbConn.CreateCommand()
cmd.CommandText = " select * from [Sheet1$A2:A10] "
rdr = cmd.ExecuteReader()
Use Console.WriteLine() or whatever to output the data where you need.
Ciao,
|