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
- 125Activities
- 2akaBot Studio
Last author
- 45Giang Tran
- 32Tuan Nguyen
- 22DatPT
- 20VuNH54
- 8admin
Creator
- 63Giang Tran
- 54Tuan Nguyen
- 10admin
Last modification date
Creation date
Upload date
Excel Insert Columns Table
Located in
- Rendered document content
must be made. E.g: "Sheet1" Table name (String) - Table name you want to insert. E.g: "Table1" Misc
…position in the table. (* for mandatory) In the body of activity Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Table name (String) - Table name you
- Title
Excel Insert Columns Table
- Location
Excel Insert Columns Table
- Raw document content
)** - Table name you want to insert. E.g: "Table1" * **Column name (String)** - Name of column you want
…name (String)** - Table name you want to insert. E.g: "Table1" **Misc** * **Public (Boolean
…to organize and structure your code better. E.g: [028225900] Excel Insert Columns Table ))) {{velocity
Excel Insert Rows
Located in
- Rendered document content
to insert one or more rows in a table, range, or sheet at the specified location. This only can be used
…(String)* - The name of the sheet that you want to insert row. E.g: “Employee Name” Number of row (Int) - Number of rows you want to insert in Excel sheet E.g: 5 Row position (Int) - Position where the rows
- Title
Excel Insert Rows
- Location
Excel Insert Rows
- Raw 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 in Excel Application Scope
…of the activity** == * **Sheet name (String)*** - The name of the sheet that you want to insert row. E.g
Excel Insert Image
Located in
- Rendered document content
to insert image to. E.g: “Employee Data” Range (String)* - The range you want to add image to. E.g: “K1:L1
…file you want to insert. This field accepts only strings and String variables. E.g: “C:\FolderName
…path of the image or click “…” button to choose file you want to insert. This field accepts only
- Title
Excel Insert Image
- Location
Excel Insert Image
- Raw document content
want to insert image to. E.g: “Employee Data” * **Range (String)* **- The range you want to add image
…(String)** - Input the full path of the image or click “…” button to choose file you want to insert
…path of the image or click “…” button to choose file you want to insert. This field accepts only
Excel Insert Or Delete Columns
Located in
- Rendered document content
) - The number of columns you wish to add or remove. E.g: 1 Position (Int32) - The column where the insertion
…to add or remove. E.g: 1 Position (Int32) - The column where the insertion or removal begins. E.g: 2
…if you want to public the activity. Remember to consider data security requirement before using
- Title
Excel Insert Or Delete Columns
- Location
Excel Insert Or Delete Columns
- Raw document content
)** - The column where the insertion or removal begins. E.g: 2 * **Sheet name (String)*** - The name of the sheet
…)** - The column where the insertion or removal begins. E.g: 2 **Input** * **Change Mode (Dropdown List
…to public the activity. Remember to consider data security requirement before using this property
Excel Insert Or Delete Rows
Located in
- Rendered document content
) - The number of rows you wish to add or remove. E.g: 1 Position (Int32) - The row where the insertion
…) - The number of rows you wish to add or remove. E.g: 1 Row Position (Int32) - The row where the insertion
…: "Sheet1" Misc Public (Boolean) - Check if you want to public the activity. Remember to consider data
- Title
Excel Insert Or Delete Rows
- Location
Excel Insert Or Delete Rows
- Raw document content
)** - The row where the insertion or removal begins. By default, this is filled in with 1. E.g: 2 * **Sheet
…or remove. E.g: 1 * **Row Position (Int32)** - The row where the insertion or removal begins. By default
…. Remember to consider data security requirement before using this property. * **Display Name (String
[05]Navigate To
Located in
- Rendered document content
RCA.Activities.Browser.NavigateTo Description The Navigate To activity allows you to navigate to another URL on the current browser. (* For Mandatory) In the body of the activity URL to be inserted
…to public it. Remember to consider data security requirement before using it. Default is unchecked.
- Raw document content
" width="392"]] (* For Mandatory) == **In the body of the activity** == * **URL to be inserted
…)** - Check if you want to public it. Remember to consider data security requirement before using it. Default
…="akb-toc-title" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) #end {{/velocity}} )))
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
[23]Inject Javascript
Located in
- Rendered document content
insert the JavaScript code directly here. E.g: "D:\Users\Downloads\invokeCode\invokeCode\alert.js
…to consider data security requirement before using it. Default is unchecked. Output Script Output (String
- Raw document content
(String)*** – The path of the JavaScript file you want to inject. You can also insert the JavaScript code
…Javascript * **Public (Checkbox) **- Check if you want to public it. Remember to consider data security
…}} #if ($xcontext.action != 'export') (% class="akb-toc" %) ((( (% class="akb-toc-title" %) ((( Table of Content ))) {{toc
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