Open Excel WorkBook

This activity is used to open an excel file resource for reading or writing. An internal reference object is created to be used to indicate this particular resource.

Properties

mceclip0.png

Input

  • Excel Document: file name for the target Excel document

  • Document Path: the relative path to the excel type file document. Absolute paths can also be used, but this defaults to the current working directory of the robot process.

Misc

  • Display Name: action display name in your implementation project

  • Wait Before: number milliseconds robot to wait before executing the action.

  • Wait After: number milliseconds robot to wait until moving to the next action.

  • Abort on Error: True/False

  • Retry Times: Specifies the number of times to retry an action if it doesn't end successfully. Default value 0 (no retry); Use -1 if you want to retry indefinitely.

Use Case

Potential Use Cases

  • Open an Excel document downloaded from an external source

  • Open an Excel document received by email

  • Open an empty Excel document in order to paste data and manipulate it in a report

Examples of Using Open Excel Workbook

Example

In this example, the robot will access an Excel file and capture a cell value.

Watch the robot in action:

You can see how the Open Excel Workbook activity is used in an example that incorporates multiple activities. You can check and download the example from here:

The article doesn't fully answer your question, or you want to find out more? Ask your question in comments, on our community forum, or contact our support team or your account manager. Whatever works for you, your question will find its answer soon!