RCA.Activities.Excel.WriteCell
Description
This activity allows you to write a value or formula into a specified spreadsheet cell or a range.
If the sheet does not exist, a new one is created.
(* for mandatory)
In the body of activity
- Workbook Path - The path of the Excel file you want to use.
E.g: “C:\FolderName\ClientList.xlsx” - Sheet name - The sheet you want to write the data to.
E.g: “ClientNames” - Cell content - The value or formula that you want to be written to a cell or range. Only string variables, generic variables and strings are supported.
E.g: “Hello world” or “=A2&A3” - Cell - The cell that you want to write to. String supported only.
E.g: “A20”
Properties
Input
- Workbook Path (String)* - The path of the Excel file you want to use.
E.g: “C:\FolderName\ClientList.xlsx” - Sheet name (String)* - The sheet you want to write the data to.
E.g: “ClientNames” - Value (String) - The value or formula that you want to be written to a cell or range. Only string variables, generic variables and strings are supported.
E.g: “Hello world” or “=A2&A3” - Cell (String)* - The cell that you want to write to. String supported only.
E.g: “A20”
Misc
- Public (Checkbox) - If you check it, the data of this activity will be shown in the log. Be careful, consider data security before using it.
- Display Name (String) - The name of this activity. You can edit the name of the activity to organize and structure your code better.
E.g: Write Cell