Search: insert-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
- 71Activities
- 1akaBot Studio
Last author
- 45Giang Tran
- 14VuNH54
- 13DatPT
Creator
- 63Giang Tran
- 9admin
Last modification date
Creation date
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
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
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
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
Write Cell
Located in
- Rendered document content
:\FolderName\ClientList.xlsx” Sheet name - The sheet you want to write the data to. E.g: “ClientNames” Cell
…want to write the data to. E.g: “ClientNames” Value (String) - The value or formula that you want
…: “A20” Misc Public (Checkbox) - If you check it, the data of this activity will be shown in the log
- Raw document content
to write the data to. E.g: “ClientNames” * **Cell content **- The value or formula that you want
…to write the data to. E.g: “ClientNames” * **Value (String) **- The value or formula that you want
…only. E.g: “A20” **Misc** * **Public (Checkbox)** - If you check it, the data of this activity
Read Column
Located in
- Rendered document content
(String)* - The cell from which to start extracting the column data. By default, this is filled
…" Starting Cell (String)* - The cell from which to start extracting the column data. By default
…. Remember to consider data security requirement before using this property. Display Name (String) - The name
- Raw document content
data. By default, this is filled in with "A1". E.g**:** "A1" == **Properties** == **Input
…)*** - The cell from which to start extracting the column data. By default, this is filled in with "A1". E.g: "A1
…to consider data security requirement before using this property. * **Display Name (String) **- The name
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
Excel Write Cell
Located in
- Rendered document content
Public (Checkbox) - Check if you want to public it. Remember to consider data security requirement before
- Raw document content
it. Remember to consider data security requirement before using it. * **Display Name (String)** - The name
…-toc-title" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) #end {{/velocity}} )))
Excel Save As Workbook
Located in
- Rendered document content
if you want to public it. Remember to consider data security requirement before using it. Display Name
- Raw document content
” **Misc** * **Public (Checkbox)** - Check if you want to public it. Remember to consider data security
…" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) #end {{/velocity}} )))
Excel Read Range
Located in
- Rendered document content
to consider data security requirement before using it. Display Name (String) - The name of this activity. You
- Raw document content
) **- Check if you want to public it. Remember to consider data security requirement before using
…') (% class="akb-toc" %) ((( (% class="akb-toc-title" %) ((( Table of Content ))) {{toc depth="4" start="2