Excel Scenario based question

Hi Everyone,

There is a situation, in excel file we have lacs of records, while running the BOT some more data is keep on adding rows in excel.

BOT should be capable enough to read all the data(i.e the data which is read and also that data which is keep on adding)in excel.

And enter those data in web portal.

What would be the approach to achieve it?

Hi Rakesh,

  1. Read Range
  2. Remove Duplicates from datatable
  3. Run process
  4. Repeat

Regards,
Shaf

Hi @Rakesh_Tiwari,

1 process - use read range and start processing, Once done before completing execution, read range again and compare previous and new datatable received, if same nothing added.

If different, process the newly added rows.

Regards
Sonali

1 Like