In this example, you build a bot that prints a message based on whether a cell has a value or is empty. Use the actions from the Excel basic or Excel advanced, If, and Message Box packages.

1. Open a new bot.
   1. From Automation Anywhere web interface, select Bots > My bots.
   2. Click Create TaskBot.
   3. Enter a bot name and click Create and Edit.
2. Use the Open action from the Excel basic or the Excel advanced package to open the Excel sheet.
   1. Double-click or drag the Open action.
   2. Enter a session name.
   3. Click Browse to provide the file path to the empty Excel worksheet on the desktop.
   4. Click Apply.
3. Use the Get single cell action to assign the value of a cell to a string variable.
   1. Double-click or drag the Get single cell action from the same package that you used for the Open action.
   2. Provide the session name that you used in the Open action.
   3. Select the Active cell option.
   4. In the Store cell contents to field, create the variable Output.
   5. Click Apply.
4. Use the If action to configure the conditional statement.
   1. Double-click or drag the If action.
   2. Select String from the Condition drop-down list.
   3. In the Source value field, insert the variable Output.
   4. Select Equals to as the Operator.
   5. Leave the Target value field empty.
   6. Click Apply.
5. Insert a Message box into the If container.
   1. Drag the Message box action.
   2. In the Enter the message to display field, enter Cell is empty.
   3. Click Apply.
6. Use the Else and Message box actions to configure the alternative sequence of actions.
   1. Drag the Else action next to the If action.
   2. Drag the Message box action into the Else container.
   3. In the Enter the message to display field, enter Cell is not empty.
   4. Click Apply.
7. Click Save.
8. Run the bot.
   As the bot runs, the message box appears with the message Cell is empty.
9. Enter a value into the cell located at A1 in the Excel sheet and save the sheet.
10. Run the bot.
    As the bot runs, the message box appears with the message Cell is not empty.