Search: extract-structured-data

(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

is cleared **Output** * **DataTable (DataTable)** - Stores the data extracted from the specified Excel

: "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 project folder) 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 of this activity. You can edit the name of the activity to organize and structure your code better. E.g: [674340923

) **- If you check it, the data of this activity will be shown in the log. Be careful, consider data security

of the activity to organize and structure your code better. E.g: [674340923] Read Text File **Output** * **Content (String) **- The extracted text from the file stored in a string variable. ))) {{velocity

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

this check box enables you to perform data extraction operations in an Excel file which is locked for editing

: “AlphaPower123” Misc Public (CheckBox)- Check if you want to public it. Remember to consider data security

of the activity to organize and structure your code better. E.g: Excel Application Scope Options Break Links

. Selecting this check box enables you to perform data extraction operations in an Excel file which is locked

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

and structure your code better. E.g: Excel Application Scope **Options** * **Break Links (Checkbox)** - Break

(String) - The name of this activity. You can edit the name of the activity to organize and structure your code better. E.g: [571047923] State Machine 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.

of the activity to organize and structure your code better. E.g: [571047923] State Machine * **Public (CheckBox) **- If you check it, the data of this activity will be shown in the log. Be careful, consider data security

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 - The data to be added. This field supports only DataTable variables. Properties Input Sheet Name (String

" %) ((( 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

from the toolbox Properties 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 of this activity. You can edit the name of the activity to organize and structure your code better. E.g: [765026544

it, the data of this activity will be shown in the log. Be careful, consider data security before using

and structure your code better. E.g: [765026544] OCR Scope **Options** * **Language (Dropdown list

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

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

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

: “A20” Misc Public (Checkbox) - If you check it, the data of this activity will be shown in the log

to write the data to. E.g: “ClientNames” * **Cell content **- The value or formula that you want

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

only. E.g: “A20” **Misc** * **Public (Checkbox)** - If you check it, the data of this activity

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