Chapter 6
Automating Excel, PDF, and Email Documents
Section 1
Excel Automation
Excel files are often used for data collection, organization, analysis and for sharing. This work in many business environments is manual, tedious and error prone. RPA UiPath provides automating such tasks involving Excel file data. - Use Application Integration Excel Activities to manipulate the excel data. Commonly used excel actions are available in the form of activities. For this MS Excel must be installed - Use File Direct Access Workbook Excel Activities to manipulate the excel data. Only basic actions are available in the form of activities. MS Excel installation is not required - Understand that UiPath provides activities for executing Excel Macros, VBA, Table operations, creating pivot table, etc