Skip to main content

Open Spreadsheet

Description​

Opens the specified Workbook and returns the instance of that Workbook.

Properties​

Input​

  • File Path – Specify the path of the Excel Workbook.
  • Read-Only – The specified Workbook will open in Read-Only mode if checked.

Optional​

  • Continue On Error – It Specifies whether the automation should continue even when the Activity throws an error. If True, the Activity continues without throwing any exceptions. If False, the Activity throws an exception. The default value is False.
note

Catches no error if this Activity is present inside the Try-Catch block and the value of this property is True.

  • Create if not exists — If checked, a new Workbook with the specified name in the path will be created when the Workbook does not exist.

  • Password - Specify the password to open the Excel workbook if it is password protected.

Misc​

  • DisplayName – Add a display name to your Activity.
  • Private – By default, Activity will log the values of your properties inside your workflow. If private is selected, then it stops logging.

Output​

  • Spreadsheet – It displays the Opened instance of a specified Excel Workbook.

Example​

Download Example

Correlation Scope