Skip to main content

Write Cell

RCA.Activities.Excel.WriteCell

Description​

This activity allows you to write a value or formula into a specified spreadsheet cell or range.
If the sheet does not exist, a new one is created.

image-20220505135743-1.jpeg

* indicates required fields.

In the Body of Activity​

  • Workbook Path: The path of the Excel file to use.
    Example: "C:\FolderName\ClientList.xlsx"
  • Sheet Name: The sheet to write data to.
    Example: "ClientNames"
  • Cell Content: The value or formula to write into a cell or range. Only string variables, generic variables, and strings are supported.
    Example: "Hello world" or "=A2&A3"
  • Cell: The cell to write to. Only string values are supported.
    Example: "A20"

Properties​

Input

  • Workbook Path (String)*: The path of the Excel file to use.
    Example: "C:\FolderName\ClientList.xlsx"
  • Sheet Name (String)*: The sheet to write data to.
    Example: "ClientNames"
  • Value (String): The value or formula to write into a cell or range. Only string variables, generic variables, and strings are supported.
    Example: "Hello world" or "=A2&A3"
  • Cell (String)*: The cell to write to. Only string values are supported.
    Example: "A20"

Misc

  • Public (Checkbox): If selected, the activity data will be logged. Consider data security before using this property.
  • Display Name (String): The name of this activity. You can edit it to better organize and structure your workflow.
    Example: Write Cell