Search: remove-data-row

) - 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)** - The row where the insertion or removal begins. By default, this is filled in with 1. E.g: 2 * **Sheet

) - The range from which you want to remove duplicate rows. E.g: "A1:H5" Properties Input Range (String) - The range from which you want to remove duplicate rows. E.g: "A1:H5" Sheet name (String)* - The name

RCA.Activities.Excel.ExcelRemoveDuplicatesRange Description Deletes all the rows

Excel Remove Duplicates Range

Excel Remove Duplicates Range

" * **Range (String)** - The range from which you want to remove duplicate rows. E.g: "A1:H5" == **Properties** == **Input** * **Range (String)** - The range from which you want to remove duplicate rows

" %) ((( RCA.Activities.Excel.ExcelRemoveDuplicatesRange == **Description** == Deletes all the rows that are duplicated in a specified range

Options Filter Rows Mode - Specifies whether to filter the table by keeping or removing the target rows

variable by specifying conditions in the Filter Wizard window. The activity can keep or delete rows

. (* is mandatory) In the body of activity Filter Wizard - Set filter for rows, set output columns Properties

Filter Data Table

filter data table.jpg

Data Table

Mode** - Specifies whether to filter the table by keeping or removing the target rows. * **Select

conditions in the Filter Wizard window. The activity can keep or delete rows or columns according

button so that you can access the wizard and customize your settings at any time. [[[[image:filter data

, 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

After importing the document successfully and the data extraction process is successfully finished

or remove rows in a table * To insert a row, you can click "+" icon * To delete a row, you can click "x

="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

. 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

(String)* - The cell from which to start extracting the row data. By default, this is filled in with "A1

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

RCA.Activities.Excel.ReadRow Description Reads the values from a row beginning with the cell

Read Row

Read Row

extracting the row data. By default, this is filled in with "A1". E.g: "A1" == **Properties

(String)*** - The cell from which to start extracting the row data. By default, this is filled in with "A1

" %) ((( RCA.Activities.Excel.ReadRow == **Description** == Reads the values from a row beginning with the cell specified

DataTable variable in an existing Table. Returns the number of rows affected. If the constraints on the table aren't met, the activity will fail and all the written rows will be saved. (* for Mandatory) In the body of activity Configure Connection - Set connection string, data source, data provider. Data

Insert Data Table

Insert Data Table

in an existing Table. Returns the number of rows affected. If the constraints on the table aren't met, the activity will fail and all the written rows will be saved. [[image:image-20220506105511-1.png]] (* for Mandatory) == **In the body of activity** == * **Configure Connection **- Set connection string, data

it. Result (Boolean) - The result after removing item from existing data. TypeArgument (Dropdown List

you to remove item in a specified collection (* for Mandatory) Properties Misc Collection (ICollection<T>)* - The collection from which to remove the Item. Display Name (String) - The name

[04]Remove From Collection

[03]Remove From Collection

requirement before using it. * **Result (Boolean) **- The result after removing item from existing data

" %) ((( System.Activities.Statements.RemoveFromCollection<System.Int32> == **Description** == This activity allows you to remove item in a specified

** * **Collection (ICollection<T>)*** - The collection from which to remove the Item. * **Display Name (String

). Edit Grid Templates Customize headers and rows of grid data 4. Manage components in Form Designer

the ability to collect user data UI components are divided into 5 main groups, based on their functions

Table Tabs Well Data Include components used to collect data Hidden Container Data map Data grid Edit

headers and rows of grid data == **4. Manage components in Form Designer** == [[image:image

provide users the ability to collect user data [[image:1695034818758-663.png||height="379" width="1014

|((( * HTML element * Content * Columns * Field set * Panel * Table * Tabs * Well ))) |Data|Include components

RCA.Activities.Excel.ExcelInsertOrDeleteColumns Description Adds or removes a specified number

) - The number of columns you wish to add or remove. E.g: 1 Position (Int32) - The column where the insertion or removal begins. E.g: 2 Sheet name (String)* - The name of the sheet in the workbook where the change must

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

of columns (Int32)** - The number of columns you wish to add or remove. E.g: 1 * **Position (Int32)** - The column where the insertion or removal begins. E.g: 2 * **Sheet name (String)*** - The name of the sheet