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?
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
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
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.