This article describes the RPA Excel functionality to write data to a specific cell in a workbook.

For a full list of available functions, please read EXCEL functions.

Description

The EXCEL write function allows you to write data to a specific cell in an Excel workbook.

Setting it up

To use the EXCEL write function, follow these instructions:

Once on a process map:

Navigate to the process where you would like to add the EXCEL write function
Click on the green button’s drop-down (right side of the green button labelled “Process”)
On the menu that appears, click on the “+ Activity” item, which will make a new form appear
From here you can select the EXCEL write option
Click "Add" once you are done

Parameter	Required	Type	Default	Description
File path	Yes	Text	–	Full path to the Excel file.
Sheet	Yes	Text	–	Name of the target sheet.
Cell	No	Text	–	Cell reference (e.g. A1). If omitted, writes to the active cell.
Content	Yes	Text	–	The value or text to write into the cell.
Clear cell first	No	Boolean	Off	Clear the cell contents before writing.
Enter as formula	No	Boolean	Off	Treat the content as an Excel formula.
Keep as text	No	Boolean	Off	Force the value to be stored as text, not a number.

This action does not produce any output variables.

Error	Description
File not found	The specified file path does not exist.
Sheet not found	The specified sheet name does not exist in the workbook.