Articles → AUTOMATION ANYWHERE → Excel Command In Automation Anywhere 10.5

Excel Command In Automation Anywhere 10.5

In this article, we will work on Excel command in automation anywhere

Purpose

Excel command performs action on excel file like open, save, close, read, write etc.

In this example, we will work on following excel.

Click to Enlarge

We will perform following action on this excel

You can perform all the above operations from the Excel command.

Click to Enlarge

First, drag and drop ‘Open Spreadsheet’ and you will get a window where we will specify the file name.

Click to Enlarge

Second and third step includes setting up the values of cells.

Click to Enlarge

Then save and close excel. So the code will be

Click to Enlarge

Now run the above task and check the excel. You will get following output.

Query/Feedback