Microsoft Excel is the ubiquitous software that helps us to organize data into spreadsheets that contain rows and columns of data. Almost anyone who owns a Windows-based personal computer has probably used it to keep track of data, perform calculations, or create graphs and charts.
With the extensive use of Excel in our everyday lives, it is not surprising that Blue Prism is shipped with a library that opens up the world of Excel to robots. Using the library, the robots are able to perform some of the common things that we do with Excel:
- Open workbooks
- Read/write spreadsheets
- Read/write cell values
- Run macros
- Format cells
In this chapter, we will use some of these actions to enhance the purchasing process to read off the shopping list from an Excel spreadsheet. We will start by importing the Excel VBO that contains the Blue Prism libraries that interact with...
