EXCEL Automation using Artificial Intelligence

Help
#1

Hi Friends,

I am new for UI path, now i am focus on AI development using our UI path. i have the scenario that.

  1. Excel file 1 have the data’s with name and designation field is empty.
  2. Excel file 2 have the source data which is combined excel file 1 names and its designation.
  3. Read the excel file 2 source data and get the designations only then paste it into the excel file 1 designation filed based on the names.

Kindly find the examples Excel file 1 and Excel file 2.

image

#2

Hi ArunUday,
Welcome to the community…!
You can easily solve the above problem by :-
1.Read the source column as a string using read cell activity and store it in a string.
1.Using for each to loop through the row of names in excel 1.
2. for each name, use a regex to locate the designation and extract it from the group, like for example, Ramanna\s(\b\w*) is the regex, in which matches.groups(1).value will give you sqa text…

#3

Thank u pankaj.sharma

We tried as per your steps, but finally its throws the following error.

System.Linq.Enumerable+d__94`1[System.Text.RegularExpressions.Match]

Can you give a sample UI sequence for this…?

#4

hi ArunUday,
Please find attached the working .xaml file.
I have created a dummy excel with dummy names in “Names” sheet and “NamesDaesignation” sheet having the date for designation.

Kind regards,
PaknajForumExcelAutomationUsingAI.xaml (10.1 KB) Excel_UsingAI.xlsx (9.0 KB)