Search: join-data-table

in a Data Table variable to the end of a specified Excel spreadsheet. (* is mandatory) In the body

, this is filled in with "Sheet1". Only String variables and strings are supported. E.g: “ClientNames” Data Table

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

" %) ((( RCA.Activities.Excel.ExcelAppendRange == **Description** == This activity allows adding information stored in a Data Table variable

: “ClientNames” * **Data Table** - The data to be added. This field supports only DataTable variables

: “ClientNames” * **Data Table (DataTable)*** - The data to be added. This field supports only DataTable

(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

. 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

. 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

, 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

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

Public (Checkbox) - Check if you want to public it. Remember to consider data security requirement before

in a table, range, or sheet at the specified location. This only can be used in Excel Application Scope

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

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

to insert image to. E.g: “Employee Data” Range (String)* - The range you want to add image to. E.g: “K1:L1” Misc Public (Checkbox) - Check if you want to public it. Remember to consider data security

position of the image. You can edit the margin of the picture. E.g: 10 Table of Content

want to insert image to. E.g: “Employee Data” * **Range (String)* **- The range you want to add image

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

the margin of the picture. E.g: 10 ))) (% class="akb-toc" %) ((( (% class="akb-toc-title" %) ((( Table

Public (Checkbox) - Check if you want to public it. Remember to consider data security requirement before

. ・False -The page does not meet the requirement. Table of Content

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

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

-builds hundreds of activities to perform the actions of automations on web, on desktop, working with data

: In the akaBot Studio click File menu, chose Options. Step 2: In the table Options, click References Directories

of automation projects. These activities enable robots: Manipulate the data by adding/extracting/reading

on web, on desktop, working with data base, generating the PDF files, sending emails… This document aims

Options. * Step 2: In the table Options, click References Directories tab, click Add button and chose

enable robots: * Manipulate the data by adding/extracting/reading information. * Directly interaction