Search: insert-data-table

) - 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

Excel Insert Or Delete Columns

Excel Insert Or Delete Columns

)** - 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

) - 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

Excel Insert Or Delete Rows

Excel Insert Or Delete Rows

)** - 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

it. (* for Mandatory) In the body of activity URL (String) - Insert a specified URL in the container. Ex: “https

(Browser)* - Insert the specified browser in which activities could be active. URL (String)* - Provide

want to publicize it. Remember to consider data security requirements before using it. Display Name

-20220506110901-1.png]] (* for Mandatory) **In the body of activity** * **URL (String)** - Insert

Browser (Browser)*** - Insert the specified browser in which activities could be active. * **URL (String

to consider data security requirements before using it. * **Display Name (String)** - The name

Add Data Column Add Data Row Build Data Table Clear Data Table Filter Data Table For Each Row Generate Data Table Get Row Item Join Data Tables Look Up Data Table Merge Data Table Output Data Table Remove Data Column Remove Data Row Remove Duplicated Rows Sort Data Table

Data Table

/Activities/Add%20Data%20Row/]] * [[Build Data Table>>url:https://docs.akabot.com/bin/view/Activities/Data%20Table/Activities/Build%20Data%20Table/]] * [[Clear Data Table>>url:https://docs.akabot.com/bin/view/Activities/Data%20Table/Activities/Clear%20Data%20Table/]] * [[Filter Data Table>>url:https://docs.akabot.com

duplicate rows in the data table. (* is mandatory) Properties Input Data Table (DataTable)* - The data table you want to check. Misc Public (Checkbox) - Check if you want to publicize it. Remember

Rows. Output Output Data Table(DataTable) - The column value from the specified DataRow.

Data Table

" %) ((( RCA.Activities.Core.RemoveDuplicatedRows == **Description** == This activity allows you to remove duplicate rows in the data table

** == **Input** * **Data Table (DataTable)* **- The data table you want to check. **Misc** * **Public

** * **Output Data Table(DataTable) **- The column value from the specified DataRow. ))) {{velocity

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.

" 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}} )))

and choose data type is "Table". Step 3: (This step is optional) Turn on button "Required" to set require

and data type for each column Step 6: Click "Save" button Table of Content

and Table Field 1. Add Form Field Step 1: On Add Learning Instance screen, click "Add Field" button

the table name on "Label" field and choose data type is "Table". ))) [[image:image-20221028164141-11.png

types of fields: Form Field and Table Field == **1. Add Form Field** == (% class="box infomessage

the field name on "Label" field and choose data type for field on "Data Type" field ))) [[image:image

and automate Excel tasks using Visual Basic for Applications. Insert VBA Activity: This activity allows you to insert new VBA code into a workbook or a specific module. It helps you extend the functionality of your

(if no selector is chosen). Table of Content

tasks using Visual Basic for Applications. ** Insert VBA Activity: This activity allows you to insert

="akb-toc" %) ((( (% class="akb-toc-title" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) )))

of the activity to organize and structure your code better. E.g: Get the data table Public (Checkbox) - If you

using it. Output Data Table (DataTable)- The Table is extracted from the Word Document and stored

RCA.Activities.Word.GetTable Description This activity allows you to retrieve a table from

Get Table

Get Table

the data table * **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** * **Data Table (DataTable

== **Description** == This activity allows you to retrieve a table from a Word Document and return

(CheckBox) - If you check it, the data of this activity will be shown in the log. Be careful, consider data

on top of all other windows. Output Result (String) - The value inserted by the user in the input

) **- The title of the dialog. E.g: "Color Picker" **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

windows. **Output** * **Result (String)** - The value inserted by the user in the input dialog stored