I have one XLS file with content as multiple rows have the full name. And this have to be copied to another XLS sheet in First, Second and last name. I have the formula to separate but how I can do this automate using UiPath, any help or suggestion?
Programatic way.
- Get the 1st excel into DataTable and Create 2nd Datatable with 3 cols (first middle last)
- User For Each to iterate all the names
- Inside For Each split the Name by space delimiter (Lenth will 2 and 3 if it has Middle Name)
- Use Add DataRow to insert above values(#)3 into 2nd Datatable.
4)Use Write Range(include headers) to write to 2nd excel sheet.
Or if you have macro ready
- Use Excel Application Scope with Excel Sheet 1
- Use Execute Macro Activity to load the names into 2nd sheet.