Missing rows while typing data to web

Hi, I am trying to read the data from excel and type into on web page. For this I created a excel scope and store the data into a variable then used the “Type Into” activity in for each row.

Now, it is missing rows stored in variable when typing the data. Can someone please have me on this?

Hi @Naresh_Upadhyay

Inside For each row while using Type into activity use below syntax to get value
row(“columnname”).ToString

if you want to check any string is empty or not use below syntax. if the result is true then you are getting a null value from datatable

string.isNullOrEmpty(row(“columnname”).ToString )

Regards
Roshan

Please mark as a solution if found useful :slight_smile:

Thanks for your reply!! it was resolve after deactivating “Active” in the property.