Search: extract-structured-data

(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

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

to read. E.g: "Sheet1" * **Starting Cell (String)*** - The cell from which to start extracting the column data. By default, this is filled in with "A1". E.g**:** "A1" == **Properties** == **Input

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

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

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

if you want to public it. Remember to consider data security requirement before using it. Display Name (String) - The name of this activity. You can edit the name of the activity to organize and structure your

” **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: Save as Workbook **Options** * **File Format

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

the name of the activity to organize and structure your code better. E.g: [028225900] Excel Insert Columns

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

to organize and structure your code better. E.g: [028225900] Excel Insert Columns Table ))) {{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

of the activity to organize and structure your code better. E.g: Insert Image Options Image Height (Single

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 can edit the name of the activity to organize and structure your code better. E.g: Insert Image