Error while retrieving data from Excel


I think you are using read range activity with range “A1” and “B1” and so on which makes it to read only one row.
if you change it to “A1:A+“dtYourExcelRead.rows.count.ToString”” or “B1:B+”+dtYourExcelRead.rows.count.tostring+“” , you will be able to read all the rows.

you can also use Nothing to read all the columns at the same time.

Hope this will work for you.


1 Like