Bot is Not reading entire Excel Sheet using as a database

Help Something Else
,
1

Hi All,

I’m having data in excel like around more than 10 Lakhs data, so i used as a database using an excel while reading using as a database i’m not able to get all the datas some of the rows are missing kindly help me to get all the rows.

2

kindly note, when checking within the debug panels like locals, watch … the data is limited
Was the yourdatatable.Rows.Count checked for the analysis?

3

HI @ppr i have checked the row count is mismatching.