This activity allows the user to delete a specific range of cells within the input Excel
sheet, and it operates within the Excel scope activity.
Technical Reference
|
|
INPUT |
Range: Indicates to provide the “Range” from the excel sheet that needs to be deleted. This parameter accepts values in the “String” datatype. |
|
SheetName: Indicates to provide the “SheetName” from the range needs to be deleted in the worksheet. This parameter accepts values in the “String” datatype. |
||
|
MISC |
DisplayName: Displays the name of the activity. The activity name can be customized, which aids in troubleshooting. |
|
|
SkipOnError: Specify the "Boolean" value as "True" or "False."
True: Continue executing the workflow regardless of any errors thrown. False: Halt the workflow if it encounters any errors. None: If the option is left blank, the activity will, by default, behave as if "False" were chosen. |
||
|
Version: It indicates the version of the feature being used. |
||
|
OUTPUT |
Result: It provides the ability to view the execution status of the activity. It returns values in "Boolean."
True: Indicates that the activity has been executed successfully without any errors. False: Indicates that the activity has been unsuccessful due to an unexpected error being thrown. |
* Represents mandatory fields to execute the workflow
Here’s an example of how “DeleteRange” activity works –
In the following example, I am using the “Excel sheet” which is used to automate in
the Use case. To get a better understanding, click here.
This report encompasses employee particulars like Name, Position, Age, Office,
Start date, and Salary.
1. Here, I am continuing from the “WriteRange” activity’s example.
2. Now, placing the "DeleteRange" activity within the scope activity.
a. In this case, I am deleting the “Start date” from the excel sheet.
b. Double click on the activity to enter the below details.
i. Here I am providing the “Range” as “E1:E10” where the “StartDate” column
is located.
c. Enter the “SheetName” box as “Report”.
3. Now, execute the workflow.
The bot will delete the “StartDate” column in the provided input excel worksheet.