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
- 46Activities
Creator
- 41Giang Tran
- 5admin
Last modification date
Creation date
Uploaded by
- 45Giang Tran
- 1Nhan Nguyen
Upload date
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
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
Read CSV File
Located in
- Rendered document content
Data Table (DataTable) - Represents the output DataTable that contains the information obtained from
…of the CSV file E.g: “C:\CSVFolder\clientList.csv” 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
- Raw document content
, it is selected. **Output** * **Data Table (DataTable)** - Represents the output DataTable that contains
…” **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
Excel Insert Rows
Located in
- Rendered document content
RCA.Activities.Excel.ExcelInsertRows Description This activity allows you to add more rows to insert one or more rows in a table, range, or sheet at the specified location. This only can be used
…Public (Checkbox) - Check if you want to public it. Remember to consider data security requirement before
- Raw document content
in a table, range, or sheet at the specified location. This only can be used in Excel Application Scope
…at. **Misc** * **Public (Checkbox)** - Check if you want to public it. Remember to consider data security
…="akb-toc-title" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) #end {{/velocity}}
Get Data from Clipboard
Located in
- Rendered document content
RCA.Activities.Core.GetFromClipboard Description This activity allows you to get data from
…)* – The format of the data you want to get from to Clipboard. Support format are: Text, UnicodeText, Rtf, Html
…check it, the data of this activity will be shown in the log. Be careful, consider data security before
- Title
Get Data from Clipboard
- Location
Get Data from Clipboard
- Raw document content
" %) ((( RCA.Activities.Core.GetFromClipboard == **Description** == This activity allows you to get data from Clipboard for further
…** * **Text Format (Dropdown list)*** – The format of the data you want to get from to Clipboard. Support
…and structure your code better. E.g: [997394815] Move File * **Public (Checkbox)** - If you check it, the data
Comment Out
Located in
- Rendered document content
RCA.Activities.Core.CommentOut Description This activity allows you to add different activities that won’t be executed at run time. Properties 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
- Raw document content
(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
…" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) #end {{/velocity}} )))
Continue
Located in
- Rendered document content
. E.g: [934370433] Continue 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.
- Raw document content
)** - If you check it, the data of this activity will be shown in the log. Be careful, consider data security
…" %) ((( (% class="akb-toc-title" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) #end
next page »
Page
1
2
3
4
5
RSS feed for search on [join-data-table]