Chapter 11: Automating Excel
You must be feeling like an XML automation guru now. In the previous chapter, we covered all the actions available in the XML package, giving hands-on experience with reading and updating XML files as well as running XPath functions against your XML datasets.
In this chapter, we will be looking into using automation with Microsoft Excel. We will go through several walk-throughs, looking at how we can build bots to automate Excel workbooks and worksheets. Automation Anywhere 2019 has two packages offering loads of Excel actions. These packages are Excel basic and Excel advanced. Starting with the basics will enable you to feel confident with opening, closing, and saving workbooks. You will also learn how to read datasets ...
Get Robotic Process Automation with Automation Anywhere now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
