Search: look-up-data-table

RCA.Activities.Core.RemoveDataRow Description This activity allows you to remove a Data Row to a specified DataTable. (* is mandatory) Properties Input Data Row (DataRow)* - The DataRow object which is to be removed. Data Table (DataTable)* - The DataTable object from which the row is removed. Row Index (Int

Remove Data Row

remove data row.jpg

Data Table

Remove Data Row

" %) ((( RCA.Activities.Core.RemoveDataRow == **Description** == This activity allows you to remove a Data Row to a specified DataTable. [[image:remove data row.jpg]] (* is mandatory) == **Properties** == **Input** * **Data Row (DataRow)*** - The DataRow object which is to be removed. * **Data Table (DataTable

. 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

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

 : A single click. Double : Two clicks in quick succession. Up : Releases the mouse button. Down : Holds down

. It is actually a XML fragment specifying attributes of the GUI element you are looking for and of some of its

. Misc Public (Checkbox) - Check if you want to public the activity. Remember to consider data security

click. ** **Double** : Two clicks in quick succession. ** **Up** : Releases the mouse button. ** **Down

of the GUI element you are looking for and of some of its parents. ** **TimeoutMS (Int32)** - The maximum

. **Misc** * **Public (Checkbox)** - Check if you want to public the activity. Remember to consider data

RCA.Activities.Excel.ExcelGetWorkbookSheet Description This activity allows you to look for a sheet based on its index and returns its name as a String variable. be used in Excel Application Scope

if you want to public it. Remember to consider data security requirement before using it. Display Name

" %) ((( RCA.Activities.Excel.ExcelGetWorkbookSheet == **Description** == This activity allows you to look for a sheet based on its index

data security requirement before using it. * **Display Name (String) **- The name of this activity

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

RCA.Activities.ComputerVision.CVTableExtract Description Extracts a table that is visible

to consider data security requirement before using this property. Display Name (String) - The name

] CV Table Extract Output Result (DataTable) - The retrieved table, stored in a DataTable variable

CV Table Extract

CV Table Extract

" %) ((( RCA.Activities.ComputerVision.CVTableExtract == **Description** == Extracts a table that is visible on the screen and stores

) **- Check if you want to public the activity. Remember to consider data security requirement before using

to organize and structure your code better. E.g: [201135155] CV Table Extract **Output** * **Result

will show a form for you to fill in. Details in the table below No Column /Label Description Type Maximum

To delete a role, you click the Delete button of the corresponding role. A confirming pop-up

to fill in. Details in the table below [[image:image-20230704162458-3.png]] |=No|=Column /Label

of the corresponding role. [[image:image-20221101164723-19.png]] A confirming pop-up will display. Hit Delete

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

in the DataTable. Data row (DataRow) - The DataRow object to be added to the DataTable. If this property is set, then the ArrayRow property is ignored. Data Table (DataTable)* - The DataTable object in which you want to add

RCA.Activities.Core.AddDataRow Description This activity allows you to add a Data Row

Add Data Row

add data row.jpg

Data Table

Add Data Row

is ignored. * **Data Table (DataTable)*** - The DataTable object in which you want to add a column

" %) ((( RCA.Activities.Core.AddDataRow == **Description** == This activity allows you to add a Data Row to a specified DataTable. [[[[image:add data row.jpg]]>>attach:add data row.jpg]] (* is mandatory) == **Properties** == **Input

RCA.Activities.Python.PythonScope Description A container that gives you the scope for Python activities and initializes the specified Python environment. When this activity ends, all objects loaded up

) - Check if you want to publicize it. Remember to consider data security requirements before using

and initializes the specified Python environment. When this activity ends, all objects loaded up to that point

to publicize it. Remember to consider data security requirements before using it. * **Display Name (String

!= 'export') (% class="akb-toc" %) ((( (% class="akb-toc-title" %) ((( Table of Content ))) {{toc depth="4

, data tables or other types of collections. (* for Mandatory) Properties Input Values (IEnumerable)*- Iterate through the data and process each piece of information individually. Able to input variable

it, the data of this activity will be shown in the log. Be careful, consider data security before using

" %) ((( RCA.Activities.Core.ForEach == **Description** == This activity allows you to loop through arrays, lists, data tables

) == **Properties** == **Input** * **Values (IEnumerable)***- Iterate through the data and process each piece

. E.g: [389861710] For Each < T > * **Public (Checkbox)** - If you check it, the data of this activity

is ignored. Eg: “Phone Number”. Data table (DataTable)* - The DataTable object from which the column is to be removed. Misc Public (Checkbox) - Check if you want to publicize it. Remember to consider data security

RCA.Activities.Core.RemoveDataColumn Description This activity allows you to remove a Data

Remove Data Column

remove data column.jpg

Data Table

Remove Data Column

Number”. * **Data table (DataTable)*** - The DataTable object from which the column is to be removed

" %) ((( RCA.Activities.Core.RemoveDataColumn == **Description** == This activity allows you to remove a Data Column to a specified DataTable. [[[[image:remove data column.jpg]]>>attach:remove data column.jpg]] (* is mandatory