How to write value corresponding to any specific column name where all column has One header

Help Studio
, ,
5

Hi @HELZMOTH_BJ

You can also use this method

Read the excel from 2nd row using range property and then make the changes to the required column and write back to the excel

If i have to add a value to 3rd column:

This image shows an automation workflow in UiPath that reads data from an Excel file, adds a data row, and then writes the updated data back to the file in a different range. (Captioned by AI)
This image shows an automation workflow in UiPath that reads data from an Excel file, adds a data row, and then writes the updated data back to the file in a different range. (Captioned by AI)512×586 17.6 KB

Input and output:

image
image421×166 2.49 KB

image
image457×179 2.75 KB

Hope this helps!

Please do mark it as a solution if it helps!
Happy learning :wink: