Search: add-data-row
Last modified by admin on 2022/04/24 04:58
Add Data Row
Located in
- Rendered document content
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
- Title
Add Data Row
- Attachment name
add data row.jpg
- Location
Add Data Row
…Data Table
- Raw document content
" %) ((( 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
Activities
Located in
- Rendered document content
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
- Location
Data Table
- Raw document content
* [[Add Data Column>>url:https://docs.akabot.com/bin/view/Activities/Data%20Table/Activities/Add%20Data%20Column/]] * [[Add Data Row>>url:https://docs.akabot.com/bin/view/Activities/Data%20Table/Activities/Add%20Data%20Row/]] * [[Build Data Table>>url:https://docs.akabot.com/bin/view/Activities/Data
Remove Data Row
Located in
- Rendered document content
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
- Title
Remove Data Row
- Attachment name
remove data row.jpg
- Location
Remove Data Row
…Data Table
- Raw document content
" %) ((( 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
Add Data Column
Located in
- Rendered document content
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
- Title
Add Data Column
- Attachment name
add data column.jpg
- Location
Add Data Column
…Data Table
- Raw document content
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
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
…whether the activity adds or removes rows. ・Add: Add rows to the document. ・Delete: Remove rows from
- Title
Excel Insert Or Delete Rows
- Raw document content
" %) ((( 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
Excel Insert Rows
Located in
- Rendered 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
…(String)* - The name of the sheet that you want to insert row. E.g: “Employee Name” Number of row (Int
- Title
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
…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
[1] Release Notes
Located in
- Rendered document content
-package Add Delete Column: Adds blank columns or removes existing columns from a specified sheet. Add Delete Rows: Adds empty rows or removes existing rows from a specified sheet. Add New Sheets: Creates a new sheet inside a specified Google spreadsheet Append Row: Appends a row to an existing spreadsheet
- Raw document content
: === **1. Sheets sub-package** === (% class="box" %) ((( * Add Delete Column: Adds blank columns or removes existing columns from a specified sheet. * Add Delete Rows: Adds empty rows or removes existing rows from a specified sheet. * Add New Sheets: Creates a new sheet inside a specified Google
[3] Review Document
Located in
- Rendered document content
, 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
- Raw document content
" 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
Located in
- Rendered document content
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
- Title
For Each Row
- Attachment name
for each row.jpg
- Location
Data Table
…For Each Row
- Raw document content
) == **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
Generate Data Table
Located in
- Rendered document content
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
- Title
Generate Data Table
- Attachment name
generate data table.jpg
- Location
Data Table
…Generate Data Table
- Raw document content
(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