Clear Worksheet
This activity is used to clear a specific worksheet in the whole workbook.
Technical Reference:
|
|
INPUT |
SheetName: Specify the name of the sheet in which the data has to be cleared. |
|
WorksheetPassword: Specify the password if the worksheet is password protected. |
||
|
MISC |
Display Name: Displays the name of the activity. You can also customize the activity name to help troubleshoot issues faster. This name will be used for logging purposes. |
|
|
SkipOnError: It specifies whether to continue executing the workflow even if it throws an error. This supports only Boolean value “True or False.” True: Continues to execute the workflow irrespective of any error thrown. False: Stops the workflow if it throws any error |
||
|
Version: It specifies the version of the excel automation feature in use |
||
|
OUTPUT |
Result: Define a Boolean value to validate the success state of the activity. This is not a mandatory field. |
*Mandatory field to execute the workflow
The following activity illustrates on how we can use clear worksheet activity to clear a specific worksheet from the workbook. Here we are going to clear the data from the worksheet “Test” from the “Test Excel” workbook.Example:op a get excel object activity to the workflow.
2. Enter the file path of the excel file in which the data from worksheet has to be cleared.
3. Drag and drop a clear worksheet activity into the Get Excel object activity.
4. Click on the clear worksheet activity.
5. Specify the name of the worksheet to be cleared.
6. Execute the activity.
The bot executes the activity and deletes the data from the worksheet named “Test” from the workbook “Test Excel”.