Hello, i Need help in excel Update the data

Hello, I want to read the data from excel and update the data and write it in the other excel file
An example, I have 3 data in the excel file
ID Name date
1 Chethan Sep 5, 2020, I will increment this date 30 days using ADDDays(30)
2 ABCD Sep 6, 2020
like this data is there today what I update I want to write only that data not other (Chethan only I write ) in other excel how to do
How to write the only that updated data to the new excel? only Chethan data only
Please help me!!! @monsieurrahul @pattyricarte @Palaniyappan

Use Filter If you want to fiterout todays data only or say todaysdate+30 days
Using Filter Datatable
In that u can use = condition.
And then use write range and use Filter datatable activity output in it

1 Like

My excel is like this now i send the mail to that same data and i want to save the data today send mail and i will increment that date also in the data date column i want save that row only

i want save that data in other excel file!!!

You want to mail to that row email id whose date is todays day ryt?

1 Like

yaa i already did that but i want to save the data what i send in another excel file or new excel file every day the data has save in that new excel file

Ok then use read range and then use Filter datatable activity
in that give input as output of Read Range and use condition as “Date” = date u want
and store the output in another variable and then use that in write range

1 Like

check bellow i think u will get an idea what i did
Main.xaml (13.0 KB)

Hi ,

Use Filter Data table activity after For Each Row and write range out side for each row after filter datatable


1 Like

No, it’s not write anything in an excel sheet

share me the excel

Main (3).xaml (13.6 KB)
try this

TenentDetails.xlsx (8.8 KB)

its work but i need that full row and today id one is running and tomorrow id 2 will run on that time id 2 is update in the that new excel file but when am write that one one data is write
and its not overwrite any data only update i want how can i do that

How it will overwrite you are using another excel right then it will write data of todays date +30
In another file

ya but hear some times the data is 2 is there means it was write one only and i need full row not only that column.

Have u run it
Result of filterdatatable will give you all data

yes I run it but it’s not work its write only date column

Can you share the screen shot of file and filterdatable and write range

1 Like

Hi @Chethan_P

Also try to do the below thing :-

Mark as solution and like it if this helps you :slight_smile:

Happy Automation :raised_hands:

Best Regards
Er Pratik Wavhal :robot::man_technologist:t4: :computer:

1 Like