How to read and specific range from excel file


I am trying to read the range “A1:N1” using the activity “Read range” but it did not return any value. or Maybe I did not do the correct because I wrote this line “DT.Rows(0).Item(1).ToString” in a message box in order to show the value but there is an error.

The idea is to get just one row and get the column values through their items.

I hope some one can help me

The complete value of the parameter Range is “A”+NumRow+":N"+NumRow (“A4:N4”)




Check your AddHeaders property, uncheck it if you don’t have a header.
Got mine working.