Important! Read this.
We have launched a new documentation website. If you're using Enterpise Edition 10 (or higher) or Express/Business Edition 2.4.1 (or higher), visit this page.
We have moved to a new documentation platform. This section is no longer supported. For the up-to-date information, see Excel.
The Excel action group is intended for automating Excel spreadsheet manipulations, such as getting/setting cell values, switching between sheets, saving, etc. These actions are NOT automatically recorded when you work in Excel during a recording process.
All Excel Actions are executed in the background, so the application window does not appear on the screen.
The main benefits of using Excel actions are as follows.
All Excel Actions can only be used, if your spreadsheet is opened by the Open spreadsheet action. If you open the spreadsheet with the Launch Application or Enter Keystrokes actions and add the Excel actions to the recording, these actions will be skipped during playback or execution in Control Tower.
|Actions Library||Actions Description|
Mind that if the script using Excel actions is running, you can still continue using Excel. However, you cannot use the same file that the RPA script is using during the runtime.
The maximum file size for the Excel function is 12 MB. Mind that the number of strings depends on their length, for example, it is 240,000 lines for 8 columns. Though, we do not recommend to use such large files when working with the Excel action. It is better to split a large file into several smaller ones and process them one by one.
While a bot is executing Excel actions, the following rules should be observed.
Excel actions are limited to .xls and .xlsx file types only.
Files of other types, for example, .csv or .xml, are not supported. To work with them, either convert to .xls and .xlsx, or open a file manually and grab the data by copying and pasting to clipboard, and then save to a variable.
To perform cell operations (get/set/delete value, get row/column), a bot can use either cell coordinates (A1, BQ503) or cell position (start of column, cell above, etc.) as a unique cell identifier. The position is counted starting from the currently selected cell (D7 on the example below).
|Current (current cell)|
Start of document
|2||Start of column|
|3||Start of row|
|4||End of column|
|5||End of row|
|8||Cell to the left|
|9||Cell to the right|
When working with a spreadsheet you can use Loops and Conditions to repeat the Excel actions (for example, Set Cell Value) as long as it is defined by a Loop or Condition.
|Excel Action with Loop||Excel Action with Condition|
Some actions cannot be added within Condition under Open Spreadsheet
As all Excel actions are executed in the background, you cannot add the following actions under a Condition or Loop nested in the Open Spreadsheet section:
You can use Excel together with Loops to iterate through Excel documents, extract data from them, and paste into your document.
The action opens a specified Excel spreadsheet (.xls or .xlsx) in background for further data manipulations.
The action saves a currently opened spreadsheet to the same or to a new file.
The Save Spreadsheet action can be avoided if the Open Spreadsheet action has the Save file after last action flag enabled.
Save as a new file – on clicking Save as new, all actions are performed in a new file, the initial file is closed without saving.
The action switches to a specific sheet in the Excel file (makes it active) by its name or order number.
Note that Excel file is opened on the last active sheet (where the last save was made).
The action allows to choose a cell for the following manipulations or actions using coordinates or position.
You can use the action to start your iteration through the spreadsheet from a defined cell, as the MS Excel saves the selected cell, and it can differ from the one you want to start with.
The action sets value for a specific cell by coordinates or position.
The action gets value of a specific cell and sets it to a variable for further usage.
Starting from RPA Express 2.2.0, the Get Cell Value action is enabled to work for calculated values (formulas).
The action deletes value of a target cell.
The action gets value of a specific spreadsheet row on an active sheet and sets it to a List variable for further usage.
The action gets value of a specific spreadsheet column on an active sheet and sets it to a List variable for further usage.
The action gets values from cells of a specific spreadsheet range on an active sheet and copies them to a Table variable for further usage.
The action gets values from a Table variable and copies them to cells of a defined spreadsheet range on an active sheet.