Excel : Insert Data Into Row Automatically

[fizzuraimi (Mohammad Hafiz Bin Zuraimi)]

Hello all,

I need some suggestions about the excel file, I need to update the exchange rate data everyday in this template. So, this is the template that I want to insert the data everyday.

Can I know how to insert the data by row automatically using the RPA? Thank you.

[Maria_Nolan (mn)]

You can use the Append Range activity in an Excel Scope or a Workbook > Append Range activity.

[fizzuraimi (Mohammad Hafiz Bin Zuraimi)]

It it possible to insert different data row by row using Append Range activity?

[venkat4u (venkat)]

@fizzuraimi,

1. Read excel using read range activity - output is DT1
2. then find the row based on your current date to update like below using assign activity.
   DT1.select(“Date = '”+now.tostring(“dd-MM-yyyy”)+“’ and Day ='”+now.DayOfWeek+“”)(0)(“1 USD”) = value

[fizzuraimi (Mohammad Hafiz Bin Zuraimi)]

I still not clear Do you have any example?

[Maria_Nolan (mn)]

Yes. As long as it has the same columns.