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.
