Search: join-data-table

Last modified by admin on 2022/04/24 04:58

Results 1 - 10 of 46 next page » Page 1 2 3 4 5

Append CSV File

Last modified by Giang Tran on 2023/09/25 16:27
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

Last modified by Giang Tran on 2023/09/25 16:27
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

Last modified by Giang Tran on 2022/05/13 06:53
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

Last modified by Giang Tran on 2022/05/05 06:26
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

Last modified by Giang Tran on 2022/05/13 04:28
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

Last modified by Giang Tran on 2023/09/25 16:27
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

Last modified by Giang Tran on 2022/05/13 06:22
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

Last modified by Giang Tran on 2022/05/13 03:42
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

Last modified by Giang Tran on 2022/05/13 03:32
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

Last modified by Giang Tran on 2022/05/13 03:30
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]
Created by admin on 2022/04/17 14:38