Need to add each transection details in excel fromREFW

Help Studio
, ,
1

hi all!!!

i do have few account we are loaded to queue and for eache transection and need to extract the name age class and i need to add these detailsin excel

image
image935×563 8.03 KB

for ex output would be like his

image

how can do this in REFW

Thank you!!!

2

Hi @vineelag ,
Where do we get the data of name, age, clasee?
regards,

3

@Nguyen_Van_Luong1
where bot will extract the data from application and need to enter them in excel and if there is no data need to go another transection

4

Hi @vineelag ,
I understand is you have list Bill_acc → we call this file is bill.xlsx
you enter they as key to application to find data.
then extract data of age,name, clasee form application then write all of them to original excel
that’s right?
We can use read range to read file to get data bill_acc, then use for each row in data bill_acc
each row we get name,age, clasee from application then write cell to file

5

@Nguyen_Van_Luong1 \

how can we add these details in REFW like for each TRANSECION

6

after each row with a bill_acc we have value of 1 name, 1 gae, 11 clasee
we can write cell to file, with index eg: B+index.tostring(),…etc
we need assign index = index+1 each loop

7

@vineelag

Hi

You can use 3 write cell activity for writing into excel

Or you can use 3 assign activities

Dt.rows(transactionnumber)(“name”)=pass your value

Dt.rows(transactionnumber)(“age”)=pass your value

Dt.rows(transactionnumber)(“clasee”)=pass your value

Here transactionnumber is an argument of in direction you need to map in_transactionnumber to it

In the end process state you can use write range workbook activity

Cheers