Skip to main content

Spreadsheet Exists

Description​

Specify whether a spreadsheet with the given name exists or not in a specified Workbook.

Properties​

Input​

  • Sheet Name - The name of the Spreadsheet to be checked for existence.
  • Spreadsheet – The Excel Workbook instance from which you want to be checked for spreadsheet existence.

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.

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.

Output​

  • Sheet Exists – Returns true when a Spreadsheet with the given name exists; otherwise, false.

Example​

Download Example

Sheet Exists