Are you ready for Beginners Learning Challenge #4: Excel application ? Letβs enhance your UiPath skills further with the help of our @pathrudu , @AutomationX_by_Kiran and @loredana_ifrim .
Take an Excel File, Where it has 3 sheets. First sheet has 4 columns (F.Name, L.Name, DOB, Address) of information and Second sheet has 3 columns (F.Name, Salary, PF) information
Merged the information into a third sheet with 6 columns. PFA sample sheet. Make sure you are using Excel as a Database approach.
Event Date: Today onwards!
Deadline : Quiz submissions must be submitted no later than the 2024-04-04T20:59:00Z, your time-zone!
Scoring System
All submissions earn one star for participation, regardless of correctness.
Correct solutions/Quiz answers receive 5 stars .
The most creative/best practice solution earns an additional maximum 5 stars .
Feel free to dive into our Beginners Learning Challenge #4 above and begin sharing your creative submissions.
Problem Statement :
Take an Excel File, Where it has 3 sheets. First sheet has 4 columns (F.Name, L.Name, DOB, Address) of information and Second sheet has 3 columns (F.Name, Salary, PF) information
Merged the information into a third sheet with 6 columns. PFA sample sheet. Make sure you are using Excel as a Database approach.
It was asked that we need to consider the excel file as a db. Hence in my solution I am connecting to the excel file just like we connect to our db by using Connection String and Provider Name.