This activity helps the user to provide the text or value as input to the specified range
of cells in the provided input excel sheet. This activity works within the Excel scope
activity.

Technical Reference

	INPUT	Datatable: Indicates to provide the “Datatable” variable that stores the input value to be written in the provided input excel sheet. This parameter accepts values in “Datatable” datatype.
		IncludeColumnHeaders: Indicates to include the “Column Headers” in the excel sheet while entering the data in the provided input excel sheet. If left blank, the column headers will not be considered.
		Range: Indicates to provide the “Range” to write the data in the specified input excel sheet. This parameter accepts values in the “String” datatype.
		SheetName: Indicates to provide the “SheetName” to write the data 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 “WriteRange” 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 “ReadRanges” activity’s example.

2.       Now, placing the "WriteRange" activity within the scope activity.

a.       In this case, I have stored the data from another sheet and providing the same
data into a new sheet in the existing excel sheet using “WriteRange” activity.

b.       Double click on the activity to provide the sheet name.

i.      Here I am providing the sheet name as “Report”.

c.       Navigating to the “Datatable” property to provide the input variable that
contains the value.

i.      Here I am using the “Table” variable. Refer the “ReadRanges” activity.

d.       Moving to the next property, “Range”.

i.      I am going to enter the data from the first cell, hence providing the
value as “A1”.

ii.      This will help to enter the data from the cell to the number of cells
until the data applies.

The bot will execute the workflow and writes the data in the new sheet
“Report” from A1. Below is the sample of the automation output image.