In this series, we will guide you to use different actions available in Excel advanced package.
Before we get into the details about the bot, let’s understand the basics of the Excel advanced package.
The Excel advanced package contains actions that enable you to automate many of the repetitive tasks when working with Microsoft Excel spreadsheets.
You can automate tasks related to the workbook, worksheet, rows, columns, and cell operations. You can use these actions when Microsoft Excel is installed on the device that you want to use to automate the Microsoft Excel-related tasks.
Actions in the Excel advanced package support Microsoft Office 2016 through Microsoft Office 2019 and .xls, .xlsx, .xlsb, and .xlsm formats. You can also use some of the actions with the .csv format.
To use the actions in Excel advanced package, use the following sequence
Coming back to this episode, we will discuss about how to use the following 5 actions to build a Profit Calculation Bot. As part of the exercise, we will add 2 columns ‘Margins in Percentage’ and ‘Profit’, add values in both these columns for each transaction, and then hide the column ‘Margins in Percentage’ and protect the spreadsheet using a password.
Here are the 5 actions used to build this bot along with Open and Close actions which are mandatory to work with the Excel Advanced Package.
Conclusion:: Excel Advanced package is a very powerful package and consists of more than 50 actions and can assist you to automate a lot of your repetitive tasks using Excel. This is one of the most used A2019 package and a must-learn for anyone building bots with Excel.
Here is another tutorial on Excel that showcases how to “Work With Large Excel Datasets in a Bot”
You can download the bot code and the Excel spreadsheet used in this bot here.