How to fill data in excel sheet which is already present in variables

[Rahul_Tanwar (Rahul)]

I have one column of data in my excel sheet. I have to search each row of item data on a webpage, then that webpage will give 3 values. I stored those 3 values in 3 variables. now I have to write that output in the same excel sheet in a particular row item value. Can someone help me with this?

[NIVED_NAMBIAR (NIVED N)]

Hi @Rahul_Tanwar

Welcome to forum

You can try this way

after extracting the data, u can use write cell activity to write the three variables in three columns

let’s say u had got 3 values , a1, b1, c1

No use three write cell activity to write the data in the write cell activity

Regards,
Nived N
Happy Automation

[Marius_Puscasu]

Hi @Rahul_Tanwar ,

Please find below a brief correlation between your statements and the UiPath Activity that might help you to archive your goal

I have one column of data in my excel sheet → use Read Range https://docs.uipath.com/activities/docs/read-range

I have to search each row of item data on a webpage → use For Each Row https://docs.uipath.com/activities/docs/for-each-row

then that webpage will give 3 values. → use Get Text https://docs.uipath.com/activities/docs/get-value

I stored those 3 values in 3 variables. → use Assign https://docs.uipath.com/studio/docs/the-assign-activity

… in a particular row item value → use Add Data Column https://docs.uipath.com/activities/docs/add-data-column

now I have to write that output in the same excel sheet → use Write Range https://docs.uipath.com/activities/docs/excel-write-range

Hope this helps
Best regards,
Marius