OpenBots contains a list of commands that allow for unique interactions with Microsoft Excel. These interactions range from simple commands that open a pre-existing Excel Workbook to commands that allow for more advanced data manipulation. Excel is a program that is utilized by millions of businesses around the world, and OpenBots makes Excel automation quick and easy.
Basic Excel Commands
- Accessing Excel Workbook in OpenBots
When learning a new set of commands, it is best to start with the basics! This guide will help users learn more about getting started with Excel automation commands! - Basic Excel Practice Problem
This practice problem will cover the new commands covered in the previous chapter. Please review the previous chapter before attempting this problem.
Semi-Complex Excel Commands
- Overwriting Data in Excel File
Now that the basics of opening and saving an Excel Workbook have been covered, it is time to move onto data manipulation. In this guide, the user will learn more about how to edit and manipulate the data in one Excel file. - Loading Data into New Worksheet
What if the Excel Workbook that needs to be edited contains multiple worksheets? The commands covered here will allow for data manipulation across multiple worksheets in the same file. - Deleting data in a worksheet
Not every column/row in an Excel Workbook may be needed. Deleting these columns and rows will be covered here in this guide. - Accessing Multiple Workbooks
What if data needs to be manipulated in multiple workbooks? The guide below will discuss how this can be done. - Practice Problem 2
This practice problem will cover the new commands covered in the previous chapter. Please review the previous chapter before attempting this problem.
