Close Excel WorkBook

This activity is used to close an excel file resource that has been previously opened. It is good practice to close any open resources as potential data loss and/or corruption may occur otherwise.

Properties

Input

  • Excel Document: file name for the target Excel document

  • Save Changes: a Boolean value (True/False) which specifies whether or not to save any changes made to the above-mentioned target Excel Document.

    • True: default value, meaning that any changes are saved

    • False: any changes are not saved

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

  • Close an excel file representing a financial report after performing several financial analysis calculations

  • Close an excel file representing the master data list after adding one more item

  • Close an excel file representing sales orders after adding one more item

Examples of Using Close Excel Workbook

Example

In this example, the robot will access an Excel file, change a value, and then close the Excel file.

Watch the robot in action:

‚Äč

You can see how Close 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!