How to Process only newer data from excel

Help Studio
, ,
1

Hello Guys !!

I need your help for one Sequence of my Project,
I would like to use one Excel file to load my process, but I want to use only news rows that have just arrived on the Excel file and not the old ones.

so I want my robot to process those new data only
then in the end, it should write ,how many new data rows been added , from its last time

Thanks in advance :slight_smile:

2

Hi @Jiban_Stars

During the first run get the row count and store it on the notepad or something else.

And during the second run read that text file with the count and give read range from that count
For eg : we have about 10 lines in 1st run and it will be stored in notepad
in Second run Give the range as A+ReadTextFileVar and process and at the end also take that and store it in the same location where you stored like NewCount+Oldcount

Hope this helps

Regards
Sudharsan

1 Like
3

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.