List To Excel | Robility Docs

List To Excel

This activity is used to add a list of values into an excel sheet.

Technical Reference:

	INPUT	Cell: Specify the range of cells to which the details has to be entered.
		ListData: Declare a variable here to get the list of data to be entered into the excel file.
		Password: Provide the password if the workbook is password protected.
		Sheetname: Specify the sheet name to which the list of data has to be added.
	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.

The following activity illustrates on how we can use the List to Excel activity to add a list of names to the “Test” worksheet.

Example:

1. Drag and drop a get excel object activity to the workflow.

2. Enter the file path of the excel file in which a worksheet has to be created.

3. Drag and drop a list to excel activity into the Get Excel object activity.

4. Click on the list to excel activity.

5. Specify the from to rage to which the data has to be added. E.g., A6:A10

6. Declare a variable in the ListData box as list<Strings>. Refer variable creation above on how to add data. Here it is List.

7. Specify the name of the sheet to which the list of names has to be added. Here it is “Test.”

8. Execute the activity.

The bot executes the activity and enters the list of names to the sheet named “Test”.