๐Ÿ“ˆ Advanced Excel Data Manipulation (RPA Fridays #15+16)

1st part:

Excel automation is still a very common use case. Come and see some of the advanced operations with Excel sheets and tables. I will show you how to: rename and duplicate sheets, automatically fill a range with data or formula, and how to sort a range. I will also show you how to create and adjust charts. All this by using UiPath, specifically doing a small hack and taking advantage of UiPath StudioX activities. In the second part of this topic, I will reveal even more!

Watch the video:

Download the workflow:

2nd part

Excel automation is still a very common use case. Come and see some of the advanced operations with Excel sheets and tables. I will show you how to: Filter the data, Run a macro, Save as PDF, export as CSV, and more! All this using UiPath Studio, specifically doing a small hack and taking advantage of UiPath StudioX activities.

Watch the webinar

Download the workflow

Learn more! :man_student: :woman_student:

RPA Fridays #1 - Basic Excel data manipulation - YouTube
RPA Fridays #2 - Download new music - YouTube
RPA Fridays #3 - Email trigger and data extraction - YouTube
RPA Fridays #4 - Robot playing the Word chain game - YouTube
RPA Fridays #5 - Take screenshots of all windows - YouTube
RPA Fridays #6 - UiPath Slack activities (project: Current weather on request) - YouTube
RPA Fridays #7 - Using the power of Google Vision in UiPath (5 examples) - YouTube
RPA Fridays #8 - Super powerful automation - 5x faster execution using recursive workflows - YouTube
RPA Fridays #9 - Robot that plays Arkanoid - YouTube
RPA Fridays #10 - UiPath Object Repository - YouTube
RPA Fridays #11 - Anti-procrastination robot - YouTube
RPA Fridays #12 - Movie picker robot - YouTube
RPA Fridays #13 - Travel itinerary robot (UiPath Google Maps) - YouTube
RPA Fridays #14 - Robot triggered from web input - YouTube
RPA Fridays #15 - Advanced Excel Data Manipulation (1/2) - YouTube
RPA Fridays #16 - Advanced Excel Data Manipulation (2/2) - YouTube
RPA Fridays #17 - YouTube reporting robot - YouTube
RPA Fridays #18 - UiPath process started from other one. Start process from CMD. Background process? - YouTube
RPA Fridays #19 - Advanced automatic reply bot - YouTube
RPA Fridays #20 - The very first game made in UiPath - YouTube
RPA Fridays #21 - News in UiPath 2021.8 Release - YouTube
RPA Fridays #22 - Excel data validation - YouTube
RPA Fridays #23 - UiPath Outlook Calendar activities - YouTube
RPA Fridays #24 - UiPath Project: Data validation through e-mail - YouTube

1 Like