RCA.Activities.Excel.AppendRange
Description
This activity allows you to add the information stored in a DataTable variable to the end of a specified Excel spreadsheet. If the sheet does not exist, a new one is created with the name indicated in the Sheetname field.
(* for mandatory)
In the body of activity
- Workbook Path - The full path of the Excel spreadsheet that you want to use. If the Excel file to be used is located in the project folder, its relative path can be used. Only String variables and strings are supported.
E.g: “C:\FolderName\ClientList.xlsx” - Sheet Name - The name of the sheet in which to add the specified range. By default, this is filled in with "Sheet1". Only String variables and strings are supported.
E.g: “ClientNames” - Data Table - The data to be added. This field supports only DataTable variables.
Properties
Input
- Workbook Path (String)* - The full path of the Excel spreadsheet that you want to use. If the Excel file to be used is located in the project folder, its relative path can be used. Only String variables and strings are supported.
E.g: “C:\FolderName\ClientList.xlsx” - Sheet Name (String)* - The name of the sheet in which to add the specified range. By default, this is filled in with "Sheet1". Only String variables and strings are supported.
E.g: “ClientNames” - Data Table (Datatable) * - The data to be added. This field supports only DataTable variables.
Misc
- Public (Checkbox) - Check if you want to public it. Remember to consider data security requirement 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: “append excel range”