Search: generate-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

position in the table. (* for mandatory) In the body of activity Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Table name (String) - Table name you

must be made. E.g: "Sheet1" Table name (String) - Table name you want to insert. E.g: "Table1" Misc

Excel Insert Columns Table

Excel Insert Columns Table

" %) ((( RCA.Activities.Excel.ExcelInsertColumnsTable == **Description** == Adds a specified column at a certain position in the table. [[image:image

)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" * **Table name (String)** - Table name you want to insert. E.g: "Table1" * **Column name (String)** - Name of column you want

. 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

:\FolderName\ClientList.xlsx” Sheet name - The sheet you want to write the data to. E.g: “ClientNames” Cell

, generic variables and strings are supported. E.g: “Hello world” or “=A2&A3” Cell - The cell that you want

want to write the data to. E.g: “ClientNames” Value (String) - The value or formula that you want

to write the data to. E.g: “ClientNames” * **Cell content **- The value or formula that you want to be written to a cell or range. Only string variables, generic variables and strings are supported. E.g

to write the data to. E.g: “ClientNames” * **Value (String) **- The value or formula that you want

to be written to a cell or range. Only string variables, generic variables and strings are supported. E.g

string variables, generic variables and strings are supported. E.g: “Hello world” or “=B1+C2” Misc Public (Checkbox) - Check if you want to public it. Remember to consider data security requirement before

or formula that you want to be written to a cell or range. Only string variables, generic variables

want to be written to a cell or range. Only string variables, generic variables and strings

it. Remember to consider data security requirement before using it. * **Display Name (String)** - The name

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

-builds hundreds of activities to perform the actions of automations on web, on desktop, working with data base, generating the PDF files, sending emails… This document aims to guide you how to use the akaBot

should follow below actions: Step 1: Click ‘New’ Step 2: Choose type workflow: Blank or General Business

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

should follow below actions: **Step 1**: Click ‘New’ **Step 2**: Choose type workflow: Blank or General

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

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

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

. Remember to consider data security requirement before using this property. Display Name (String) - The name

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

)*** - The cell from which to start extracting the column data. By default, this is filled in with "A1". E.g: "A1

to consider data security requirement before using this property. * **Display Name (String) **- The name