I’m a UiPath trainee, my TL gave me a task.
In a folder there is more than 10 excel files, in these excel file having employee details.
I want read the specific Data ( Emp_Name, Designation, Salary etc) and write into another excel file. These data are place different cells.
Thanks for your quick response. @KarthikByggari
Also i have a another question.
Like this same logic, we have a employee(s) details in separate separate Excel files (more than 20) in a folder, i wanna read data from different cells [Example: D1, D23, E5, E14] in each XL files and write these data into a another one excel file. Kindly guide me for this.
Hi @muthu.m
For this you can get the files fro folder using Directory.Getfiles(“Your Path of variable”) And iterate each file using for each loop. In the for each loop read that cells using the Read Cell activity.