Search: get-data-from-clipboard

the activity. Remember to consider data security requirement before using this property. Display Name (String

. E.g: [482156710] Get Excel Column Name Output Result (String) - Stores column name in a string

Get Excel Column Name

Get Excel Column Name

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

] Get Excel Column Name **Output** * **Result (String) **- Stores column name in a string variable.

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

. If the starting cell is not specified, the data is written starting from the A1 cell. (* for mandatory

, this is filled in with "Sheet1." E.g: “ClientNames” Starting Cell – The cell from which to start writing data

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

, the data is written starting from the A1 cell. (% class="wikigeneratedid" id="H" %) [[image:image

: “ClientNames” * **Starting Cell **– The cell from which to start writing data. Only string variables

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

. If the starting cell isn't specified, the data is written starting from the A1 cell. If the sheet does not exist

” Starting Cell - The cell from which to start writing data. Only string variables and strings are supported

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

, the data is written starting from the A1 cell. If the sheet does not exist, a new one is created

. E.g: “Sheet1” * **Starting Cell **- The cell from which to start writing data. Only string variables

and descriptions must match the ones from the database table. Table Name - The SQL table in which the data

the ones from the database table. Table Name (String)*- The SQL table in which the data is to be inserted

) In the body of activity Configure Connection - Set connection string, data source, data provider. Data

Insert Data Table

Insert Data Table

and descriptions must match the ones from the database table. * **Table Name **- The SQL table in which the data

]] (* for Mandatory) == **In the body of activity** == * **Configure Connection **- Set connection string, data source, data provider. [[image:https://docs.akabot.com/bin/download/Activities/Database/Activities

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

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

RCA.Activities.Excel.ExcelReadColumn Description Read all data into column has determined

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

RCA.Activities.Excel.ExcelReadColumn == **Description** == Read all data into column has

** == * **Sheet name** - The sheet you want to read. E.g: "Sheet1" * **Starting Cell** - The cell from which

. 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

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

in the SQL parameter. ・TableDirect - Invokes all records from a table. Output Data Table (DataTable

Configure Connection - Set connection string, data source, data provider. Edit Query - SQL command to be executed. This field must be completed according to the selection from the CommandType property. E.g

in the SQL parameter. ・TableDirect - Invokes all records from a table. **Output** * **Data Table (DataTable

connection string, data source, data provider. [[image:https://docs.akabot.com/bin/download/Activities

to the selection from the CommandType property. E.g: “SELECT * FROM ContactList” == **Properties** == **Common

from continuing the execution. Misc Public (Checkbox) - If you check it, the data of this activity will be shown in the log. Be careful, consider data security before using it. Display Name (String) - The name

or characters from a file and then store it in a String variable. Properties Common Continue On Error

== **Description** == This activity allows to read all or specified context or characters from a file

(default): blocks the process from continuing the execution. **Misc** * **Public (Checkbox) **- If you check it, the data of this activity will be shown in the log. Be careful, consider data security before

(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

RCA.Activities.Excel.ReadColumn Description Reads the values from a column beginning

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

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

to read. E.g: "Sheet1" * **Starting Cell (String)*** - The cell from which to start extracting the column

) In the body of activity Configure Connection - Set connection string, data source, data provider. Edit Query - SQL command to be executed. This field must be completed according to the selection from the CommandType property. E.g: “DELETE * FROM ContactList” Properties Common Continue On Error (Boolean

]] (* for Mandatory) == **In the body of activity** == * **Configure Connection **- Set connection string, data source, data provider. [[image:https://docs.akabot.com/bin/download/Activities/Database/Activities

Query** - SQL command to be executed. This field must be completed according to the selection from