Search: insert-data-table

Trigger Choose a trigger at the table below, then click this button to edit that trigger 3 Enable/ Disable/ Delete trigger Choose a trigger at the table below, then click this button to enable/disable/delete

the protocol: IMAP/ POP3 Dropdown Yes 3 Host Insert your email host Email Yes 4 Port Choose the port

at the table below, then click this button to edit that trigger |3|(% style="width:264px" %)**Enable/ Disable/ Delete trigger**|(% style="width:816px" %)Choose a trigger at the table below, then click this button

" %)Host|(% style="width:489px" %)Insert your email host|(% style="width:169px" %)Email|(% style="width

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

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

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

(DataTable) - Stores the data extracted from the specified Excel range in a data table variable. Only data

” Sheet name (String)* - The sheet you want to read. E.g: "Sheet1" Range - Range of the data. If it isn’t

)- The sheet you want to read. E.g: "Sheet1" Range - Range of the data. If it isn’t specified, the whole

range in a data table variable. Only data table variables are supported ))) {{velocity

: "Sheet1" * **Range** - Range of the data. If it isn’t specified, the whole spreadsheet will be read. E.g

want to read. E.g: "Sheet1" * **Range** - Range of the data. If it isn’t specified, the whole

) In the body of the activity URL to be inserted (String)* - The URL that you want to open in the browser

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

** == * **URL to be inserted (String)*** - The URL that you want to open in the browser. The URL must be quoted

” **Misc** * **Public (Checkbox)** - Check if you want to public it. Remember to consider data security

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

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

Public (Checkbox) - Check if you want to publicize it. Remember to consider data security requirements

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

Add Data Column

add data column.jpg

Data Table

Add Data Column

to the specified DataTable Object. String supported only. * **Data Table (DataTable)*** - The DataTable object

DataTable. [[image:add data column.jpg||class="img-thumbnail"]] (* is mandatory) == **Properties

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

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

. Only string variables and strings are supported. Data Table - The data that you want to write

to start writing data. Only string variables and strings are supported. Data Table (DataTable)* - The data

RCA.Activities.Excel.WriteRange Description This activity allows you to write the data from

and strings are supported. * **Data Table** - The data that you want to write to the specified range

which to start writing data. Only string variables and strings are supported. * **Data Table (DataTable

" %) ((( RCA.Activities.Excel.WriteRange == **Description** == This activity allows you to write the data from a DataTable variable

are supported. E.g: “ClientNames” Data Table - The data to be added. This field supports only DataTable

in with "Sheet1". Only String variables and strings are supported. E.g: “ClientNames” Data Table (Datatable) * - The data to be added. This field supports only DataTable variables. Misc Public (Checkbox) - Check if you

". Only String variables and strings are supported. E.g: “ClientNames” * **Data Table** - The data

and strings are supported. E.g: “ClientNames” * **Data Table (Datatable) *** - The data to be added

to public it. Remember to consider data security requirement before using it. * **Display Name (String

as default: Do not send the ouput Restful API (POST Method): Send the output through the API you insert

not send the ouput **Restful API (POST Method)**: Send the output through the API you insert

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

. 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