When working with Excel in UiPath, you can either use the Excel or Workbook Activities. Chose the one that suit your needs, here are the pros and cons:

  • Excel Activities
    • Excel needs to be installed
    • Work with graphs and diagrams
    • Read and write cell colors
    • Use macros
    • Can’t open password protected Excel files
  • Workbook Activities
    • Excel doesn’t need to be installed
    • Performance (quicker than Excel activities)
    • Can’t work with graphs and diagrams
    • Can’t read and write cell colors
    • Can’t use macros

Long story short: Chose Workbook activities unless you need to work with graphs, diagrams, macros or cell coloring.

Fig. 1: The Workbook activities in UiPath

Anders Jensen

RPA DEVELOPER, YOUTUBER & UIPATH MOST VALUED PROFESSIONAL 2021

Anders Jensen is the RPA Lead at Lessor A/S (Part of Paychex Inc) and an advanced certified UiPath RPA Instructor.

Using his extensive experience in automating interfaces such as Windows, SAP, and browsers, Anders develops enterprise RPA solutions automating work for customers and colleagues one task at a time.

In the evenings and weekends, Anders is passionate about teaching others RPA by making instructional videos on his YouTube channel.

View all posts

Add comment

Your email address will not be published. Required fields are marked *

Anders Jensen

RPA DEVELOPER, YOUTUBER & UIPATH MOST VALUED PROFESSIONAL 2021

Anders Jensen is the RPA Lead at Lessor A/S (Part of Paychex Inc) and an advanced certified UiPath RPA Instructor.

Using his extensive experience in automating interfaces such as Windows, SAP, and browsers, Anders develops enterprise RPA solutions automating work for customers and colleagues one task at a time.

In the evenings and weekends, Anders is passionate about teaching others RPA by making instructional videos on his YouTube channel.