How to use Uipath to extract a string from an excel cell and write (copy&paste) into new excel workbook

Help Activities
, ,
1

Hi newbie here with totally zero background in computer coding, bear with me please

Would like to seek your advice how to achieve the followings: (i have checked with chatGPT but it was a bad idea; it confused me)

  1. I have an appended excel sheet (Excel A) with rows and multiple columns.
  2. With the UiPath, I need it look for keyword “PROJ_ID” at 1st column, and then copy and write the string from 2 rows below the keyword to new excel sheet (Excel B).
  3. The robot shall keep repeat Step-2 above in 1st column to keep searching for next “PROJ_ID” under same column until no more “PROJ_ID” can be found at 1st column.
  4. After step 3, the robot shall go to 2nd column and look for keyword “PROJ_NAME”, and then copy the string from 2 rows below the keyword to new excel sheet.

see images below for better illustration:

image

2

Hello @LYS

Do you need to read only a specific cell? or the entire excel and write to the other excel?

if only specific cell, then use Read cell activity and write cell on the second excel to the write the data.

If entire excel data need to run, then use Read Range activity and Write range to write to another excel.

Thanks

3

Hi @Rahul_Unnikrishnan

Thanks for the reply. Yes, i need to read the entire Excel A and then write to Excel B. Below is the activities I built but stucked. I want to look for keyword (PROJ_ID) then copy and paste the string from 2 cells below to Excel B. thanks =)

image
image621×812 16.2 KB

4

have you got the solution