This activity helps the user to provide the “ListofString” values or variable into the
provided input excel sheet. This activity works within the Excel scope activity.

Technical Reference

	INPUT	Cell: Indicates to provide the “Cell” reference to write the data from it. This parameter accepts values in the “String” datatype.
		ListData: Indicates to provide the “List data” that need to be inserted in the provided input excel sheet.   You can either hardcode the value in an “List of String” variable or enter the value in “List”.   This parameter accepts values in the “List of String” datatype. Refer the below example to view the creation of variable.
		SheetName: Indicates to provide the “SheetName” to write the converted 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 “ListToExcel” 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, before moving to the activity, I am going to declare a variable in the
“Variables” section as “NameList” in “ListofString” datatype.

a.       Click on the Variables pane and enter the name " NameList." Then, in the
"Variable Types" column, select "Browse for Types" from the dropdown menu.

b.       The .Net window for data types will appear on the screen, enter the type name
as “System.Collections.Generic.List.String” and then click on “OK” button.

c.       Now, I am providing the default VB expression as
“new List(of string)(new string(){“Hazel”,“Amanda”,"shazriya","George","Grey"})”.

3.       Now, placing the " ListToExcel " activity within the scope activity.

a.       In this case, I am going to add a few names to the “Report” sheet under the
“Name” column using the variable created above.

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

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

c.       Next, navigating to the “Cell” in the properties to provide the cell reference
to enter the data.

i.      Here I am providing the cell value as “A11:A15” in the box.

d.       Now, moving to “ListData” to provide the list of string variable that stores the
input data.

i.      Here, I am using the variable “NameList”. Refer the “2^nd” step.

4.       Now, execute the workflow.

Below is a sample of the output of the activity.