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

Help Studio
, ,
1

The image shows a spreadsheet with auto case creation input details, including a unique GOLD number, schedule dates, time, and duration. (Captioned by AI)
The image shows a spreadsheet with auto case creation input details, including a unique GOLD number, schedule dates, time, and duration. (Captioned by AI)1088Ă—207 6.61 KB

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

2

@HELZMOTH_BJ,

  1. Use excel process scope activity - Find/Replace Value activity to find the desired column. This Find/Replace Value activity will give you the B column cell address.

  2. Use this regex to get the row number from the address string we got from step 1

strRowNumber = System.Text.RegularExpressions.Regex.Matches(strCellAddress, "\d+")(0).Value
  1. Now Use Write Cell activity and pass this "E"+strRowNumber in the property - Where to write and in What to write property, give your value to be written
3

can you please provide xaml

4

Hi @HELZMOTH_BJ
Try this,
Use Read Range to load the data into a DataTable, then use For Each Row to loop through the rows. Check the value in the first column (e.g., “Input Details”) with an If activity and update the corresponding value in the second column using Assign. Finally, use Write Range to save the changes back to Excel.

Or will provide workflow later.

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:

6

@HELZMOTH_BJ,

Share that input file, I will try to help

7

INPUT.xlsx (10.1 KB)

8

Hi @HELZMOTH_BJ

Can you try this

The image shows a sequence of steps in an automated workflow where data is read from an Excel worksheet, assigned to various index variables, and then written back to specified cells in the workbook. (Captioned by AI)
The image shows a sequence of steps in an automated workflow where data is read from an Excel worksheet, assigned to various index variables, and then written back to specified cells in the workbook. (Captioned by AI)634Ă—1460 80.8 KB

Input:

The image shows a spreadsheet with a title "Input Details" and fields for GOLD, Schedule Date (from and to), Time, and Duration, with required fields marked by asterisks. (Captioned by AI)
The image shows a spreadsheet with a title "Input Details" and fields for GOLD, Schedule Date (from and to), Time, and Duration, with required fields marked by asterisks. (Captioned by AI)1096Ă—561 9.43 KB

Output:

The image shows an Excel spreadsheet titled "Input Details" with filled-in fields for GOLD, Schedule Date, Time, and Duration. (Captioned by AI)
The image shows an Excel spreadsheet titled "Input Details" with filled-in fields for GOLD, Schedule Date, Time, and Duration. (Captioned by AI)1084Ă—496 10.1 KB

Sequence.xaml (39.5 KB)

Regards,

1 Like
9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.