Microsoft Excel spreadsheet software has become an integral part of most business organizations for analyzing , budgeting, or organizing client sales lists.
Having Said that , Most of the Automations require an Interaction to Excel.
This video is a Recording of Webinar conducted as Part of Community Initiative of UiPath. If you are an Beginner to Excel Automation and Ready to take up the Automation, Go Ahead and watch the Recording.
The Video is having 2 Parts
Part # 1: Explaining all the below activities of excel
Reading excel in UiPath
Excel vs workbook activities
Write data in excel
Insert/delete rows in excel
Insert/delete columns in excel
Copy sheet – excel
Delete range in excel - UiPath
Copy – values / formula / formats
Get workbook sheets in excel
Look up range in excel
Append range – UiPath
Part# 2 - Workshop
Practical explanation of Real-Time Scenarios - Attendees can Follow and Build Along. There would be a Sample Excel Provided to follow along with the Presenter.
Refresh multiple pivots in excel
Append data to dynamic range
Split CSV data to multiple excel
Utilize joins in excel
Feel Free to comment your email Id in Comments
Drop me a note on email@example.com for the Files / xamls explained here.
Playlist for all Excel Project Scenarios Link
Playlist for all Excel Automation Activities and their usage