Search: output-data-table

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

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

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

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
is cleared **Output** * **DataTable (DataTable)** - Stores the data extracted from the specified Excel 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

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

Excel Get Workbook Sheets

Last modified by Giang Tran on 2022/05/05 06:26
Rendered document content
. E.g: Get Workbook Sheets Table of Content Output Sheet (List< String >) - List of string
to public it. Remember to consider data security requirement before using it. Display Name (String
Raw document content
" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) ))) **Output** * **Sheet (List< String
) **- Check if you want to public it. Remember to consider data security requirement before using

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

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, CommaSepreatedValue, Xaml. Output Output Text (String) - The output of the text that you get from this activity
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 format are: Text, UnicodeText, Rtf, Html, CommaSepreatedValue, Xaml. **Output** * **Output Text

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

Check False

Last modified by Giang Tran on 2022/05/13 03:25
Rendered document content
] Check False 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. Output Result (Boolean) - The output of the check.
Raw document content
it, the data of this activity will be shown in the log. Be careful, consider data security before using it. **Output** * **Result (Boolean)** - The output of the check. ))) {{velocity}} #if ($xcontext.action != 'export') (% class="akb-toc" %) ((( (% class="akb-toc-title" %) ((( Table of Content ))) {{toc

Check True

Last modified by Giang Tran on 2022/05/13 03:26
Rendered document content
] Check True 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. Output Result (Boolean) - The output of the text
Raw document content
it, the data of this activity will be shown in the log. Be careful, consider data security before using it. **Output** * **Result (Boolean)** - The output of the text that you get from this activity
" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) #end {{/velocity}}

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}}
next page » Page 1 2 3 4 5
RSS feed for search on [output-data-table]
Created by admin on 2022/04/17 14:38