Search: add-data-row

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

. Eg: Add Data Row

in the DataTable. Data row (DataRow) - The DataRow object to be added to the DataTable. If this property is set

Add Data Row

add data row.jpg

Add Data Row

Data Table

" %) ((( RCA.Activities.Core.AddDataRow == **Description** == This activity allows you to add a Data Row to a specified DataTable

. Eg: Add Data Row ))) {{velocity}} #if ($xcontext.action != 'export') (% class="akb-toc

should map to the type of its corresponding column in the DataTable. * **Data row (DataRow

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

Remove Data Row

Data Table

" %) ((( RCA.Activities.Core.RemoveDataRow == **Description** == This activity allows you to remove a Data Row to a specified

** * **Data Row (DataRow)*** - The DataRow object which is to be removed. * **Data Table (DataTable

edit the name of the activity to organize and structure your code better. Eg: Remove data row

want to add to the specified DataTable Object. String supported only. Data Table (DataTable

to organize and structure your code better. Eg: Add Data Column Type Argument (Type) - A reference type

RCA.Activities.Core.AddDataColumn Description This activity allows you to add a DataColumn

Add Data Column

add data column.jpg

Add Data Column

Data Table

of the activity to organize and structure your code better. **Eg**: Add Data Column * **Type Argument (Type

" %) ((( RCA.Activities.Core.AddDataColumn == **Description** == This activity allows you to add a DataColumn to a specified DataTable. [[image:add data column.jpg||class="img-thumbnail"]] (* is mandatory) == **Properties

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

whether the activity adds or removes rows. ・Add: Add rows to the document. ・Delete: Remove rows from

Excel Insert Or Delete Rows

" %) ((( RCA.Activities.Excel.ExcelInsertOrDeleteRows == **Description** == Adds or removes a specified number of rows at a certain position

of row (Int32)** - The number of rows you wish to add or remove. E.g: 1 * **Position (Int32

" == **Properties** == **Destination** * **Number of rows (Int32)** - The number of rows you wish to add

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

(String)* - The name of the sheet that you want to insert row. E.g: “Employee Name” Number of row (Int

Excel Insert Rows

" %) ((( RCA.Activities.Excel.ExcelInsertRows == **Description** == This activity allows you to add more rows to insert one or more rows

of the activity** == * **Sheet name (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

, akaBot Vision provides users with the capability to add or remove rows in a table To insert a row, you can click "+" icon To delete a row, you can click "x" icon To add a new row at the end of the table, you can click on the "Add row" button These features enable users to easily modify the table to meet

" icon * To add a new row at the end of the table, you can click on the "Add row" button These features

="wikigeneratedid" %) After importing the document successfully and the data extraction process is successfully

with this status in the “To review” tab in the user interface. [[image:image-20220420193327-1.png||data-xwiki

for each row in a specified DataTable variable. (* is mandatory) In the body of activity Foreach - Set loop variable name in - Data table to loop Body - Add activities that you want to execute in loop Properties Input Data Table (DataTable)* - The DataColumn object whose value is to be retrieved from

For Each Row

for each row.jpg

Data Table

For Each Row

) == **In the body of activity** == **Foreach** - Set loop variable name **in** - Data table to loop **Body **- Add activities that you want to execute in loop == **Properties** == **Input** * **Data Table

" %) ((( RCA.Activities.Core.ForEachRow == **Description** == This activity allows you to execute an action once for each row

the structured text. This activity enables you to select column and row separators according to which the table

the input data as a CSV. This field only supports Boolean values (True, False). The default value is False

separator. This field supports only String variables. Input Input (String)* - The field that you add

Generate Data Table

generate data table.jpg

Data Table

Generate Data Table

(String)*** - The field that you add unstructured data to convert into a table. Only String are supported

. This activity enables you to select column and row separators according to which the table is generated. [[[[image:generate data table.jpg||class="img-thumbnail"]]>>attach:generate data table.jpg]] (* is mandatory

a specified CSV File. (* is mandatory) In the body of activity File Path (String) - You can add the file

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

Path (String)** - You can add the file path of the CSV here. String supported only. == **Properties

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

. E.g: "Sheet1" Starting Cell - The cell from which to start extracting the row data. By default

: "Sheet1" Starting Cell (String)* - The cell from which to start extracting the row data. By default

of an Excel row beginning from the cell specified in the StartingCell field: and stores it in an lEnumerable

Excel Read Row

Excel Read Row

from which to start extracting the row data. By default, this is filled in with "A1". E.g: "A1

" * **Starting Cell (String)*** - The cell from which to start extracting the row data. By default

the values of an Excel row beginning from the cell specified in the StartingCell field: and stores