Bot is Not reading entire Excel Sheet using as a database

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.

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

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