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 – If checked, opens the specified Workbook in Read-Only mode.

Optional​

  • Continue On Error – Specifies if the automation should continue even when the activity throws an error. This field only supports Boolean values (True, False). The default value is False.

    Note: If this activity is included in Try Catch and the value of this property is True, no error is caught when the project is executed.

  • Create if not exists - If checked, creates the new Workbook with the name specified in the path when Workbook is not found.

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