Search: join-data-table
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Location
- 78Activities
Last author
- 36Giang Tran
- 15Tuan Nguyen
- 11DatPT
- 10VuNH54
- 6admin
Last modification date
Creation date
Uploaded by
- 55Giang Tran
- 23Tuan Nguyen
- 6admin
- 2DatPT
Upload date
Excel Append Range
Located in
- Rendered document content
in a Data Table variable to the end of a specified Excel spreadsheet. (* is mandatory) In the body
…, this is filled in with "Sheet1". Only String variables and strings are supported. E.g: “ClientNames” Data Table
…." Only String variables and strings are supported. E.g: “ClientNames” Data Table (DataTable)* - The data
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelAppendRange == **Description** == This activity allows adding information stored in a Data Table variable
…: “ClientNames” * **Data Table** - The data to be added. This field supports only DataTable variables
…: “ClientNames” * **Data Table (DataTable)*** - The data to be added. This field supports only DataTable
Append CSV File
Located in
- Rendered document content
of activity File path (String) - You can add the file path of the CSV here. String supported only. Data Table (DataTable) - The data table you want to append. Properties File File Path (String)* - The file path of the CSV file E.g: “C:\CSVFolder\clientList.csv” Input Data Table (DataTable)* - Specifies the DataTable
- Raw document content
of the CSV here. String supported only. * **Data Table (DataTable)** - The data table you want to append
…\clientList.csv” **Input** * **Data Table (DataTable)*** - Specifies the DataTable to be appended to the CSV
…)** - If you check it, the data of this activity will be shown in the log. Be careful, consider data security
Write CSV File
Located in
- Rendered document content
the file path of the CSV here. String supported only. Data Table (DataTable) - Specifies the DataTable to be written in the CSV file. Properties Input Data Table (DataTable)* - Specifies the DataTable
…\clientList.csv” Misc Public (CheckBox) - If you check it, the data of this activity will be shown in the log
- Raw document content
** == * **File Path (String)** - You can add the file path of the CSV here. String supported only. * **Data Table (DataTable)** - Specifies the DataTable to be written in the CSV file. == **Properties** == **Input** * **Data Table (DataTable)*** - Specifies the DataTable to be written in the CSV file
Read Range
Located in
- Rendered document content
(DataTable) - Stores the data extracted from the specified Excel range in a data table variable. Only data
…” Sheet name (String)* - The sheet you want to read. E.g: "Sheet1" Range - Range of the data. If it isn’t
…)- The sheet you want to read. E.g: "Sheet1" Range - Range of the data. If it isn’t specified, the whole
- Raw document content
range in a data table variable. Only data table variables are supported ))) {{velocity
…: "Sheet1" * **Range** - Range of the data. If it isn’t specified, the whole spreadsheet will be read. E.g
…want to read. E.g: "Sheet1" * **Range** - Range of the data. If it isn’t specified, the whole
Write Range
Located in
- Rendered document content
. Only string variables and strings are supported. Data Table - The data that you want to write
…to start writing data. Only string variables and strings are supported. Data Table (DataTable)* - The data
…RCA.Activities.Excel.WriteRange Description This activity allows you to write the data from
- Raw document content
and strings are supported. * **Data Table** - The data that you want to write to the specified range
…which to start writing data. Only string variables and strings are supported. * **Data Table (DataTable
…" %) ((( RCA.Activities.Excel.WriteRange == **Description** == This activity allows you to write the data from a DataTable variable
Append Range
Located in
- Rendered document content
are supported. E.g: “ClientNames” Data Table - The data to be added. This field supports only DataTable
…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
- Raw document content
". Only String variables and strings are supported. E.g: “ClientNames” * **Data Table** - The data
…and strings are supported. E.g: “ClientNames” * **Data Table (Datatable) *** - The data to be added
…to public it. Remember to consider data security requirement before using it. * **Display Name (String
Excel Write Range
Located in
- Rendered document content
. E.g: “A10” Data Table - The data that you want to write to the specified range, as a DataTable variable. Only DataTable variables are supported. Properties Input Data Table (DataTable)* - The data
…RCA.Activities.Excel.ExcelWriteRange Description This activity allows you to write the data from
- Raw document content
and strings are supported. E.g: “A10” * **Data Table** - The data that you want to write to the specified
…** * **Data Table (DataTable)*** - The data that you want to write to the specified range, as a DataTable
…" %) ((( RCA.Activities.Excel.ExcelWriteRange == **Description** == This activity allows you to write the data from a DataTable variable
[05]For Each
Located in
- Rendered document content
, data tables or other types of collections. (* for Mandatory) Properties Input Values (IEnumerable)*- Iterate through the data and process each piece of information individually. Able to input variable
…it, the data of this activity will be shown in the log. Be careful, consider data security before using
- Raw document content
" %) ((( RCA.Activities.Core.ForEach == **Description** == This activity allows you to loop through arrays, lists, data tables
…) == **Properties** == **Input** * **Values (IEnumerable)***- Iterate through the data and process each piece
…. E.g: [389861710] For Each < T > * **Public (Checkbox)** - If you check it, the data of this activity
Excel Get Workbook Sheets
Located in
- Rendered document content
to public it. Remember to consider data security requirement before using it. Display Name (String
…. E.g: Get Workbook Sheets Table of Content Output Sheet (List< String >) - List of string
- Raw document content
) **- Check if you want to public it. Remember to consider data security requirement before using
…" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) ))) **Output** * **Sheet (List< String
Excel Copy Paste Range
Located in
- Rendered document content
or sheet (including values, formulas, table format, and cell format) and pastes it to another location
…Destination Cell (String)* - The starting cell where you want to paste the copied data. This field supports
…the copied data into. This field supports only strings and String variables E.g: “TargetSheetName” Input
- Raw document content
, table format, and cell format) and pastes it to another location in the current workbook
…to SpeadSheet** * **Destination Cell (String)* **- The starting cell where you want to paste the copied data
…)*** - The sheet you want to paste the copied data into. This field supports only strings and String variables E.g