Update the excel

Help Studio
, ,
1

Hello Guys ,

I have done a process in which if there is a file in particular folder it should update an excel with current date and the status as “found”

The thing is that when i run the process it is replacing the previous data in the excel so is there any solution for this.

Record_Tracker.xaml (9.4 KB)

2

With A2, B2 the cells are fixed and will be overwritten
When it is about writing Line by Line for Run by Run then:

  • Write with a dynamized Range to the excel
  • build a 2 column datatable and add the the data by using append range activity
3

Can you elaborate please

4

Once the Bot has done an entering with date and status in A2,B2 cell, should the Bot do the next entries then into A2, B3 cell?

We asked as we could interpret the description in this direction

5

Hi @Gokul_Murali,

Hop below mentioned workflow help to you

image
image496×690 23.4 KB

FolderStatusUpdate.xaml (9.8 KB)

Thanks,
RajKumar