Search: extract-structured-data

 - 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

to start extracting the column data. By default, this is filled in with "A1". E.g**:** "A1

" * **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

. 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

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

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

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

(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

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

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

to organize and structure your code better. E.g: Read Word File **Output** * **Text (String) **- Context or specified characters that are extracted from the file and stored in a String variable. ))) {{velocity

of the activity to organize and structure your code better. E.g: Get the data table 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. Output Data Table (DataTable)- The Table is extracted from the Word Document and stored

of this activity. You can edit the name of the activity to organize and structure your code better. E.g: Get the data table * **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. **Output** * **Data Table (DataTable

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

a range of cell data (Range) from a specified workbook (Workbook) worksheet (SheetName). Delete Sheet

of a Google spreadsheet file. Get Cell Color: Extracts the background color of a cell and saves it as a Color

range (when **Shift** is //Up// or //Left//) API to delete a range of cell data (**Range**) from

. * Get Cell Color: Extracts the background color of a cell and saves it as a Color variable * Get sheets

the name of the activity to organize and structure your code better. Eg: Clear Data Table.

DataTable. (* is mandatory) Properties Input Data Table(DataTable)* - The data table that you want to clear the data. Misc Public (Checkbox) - Check if you want to publicize it. Remember to consider data

Clear Data Table

clear data table.jpg

Data Table

Clear Data Table

to organize and structure your code better. **Eg**: Clear Data Table. ))) {{velocity}} #if ($xcontext.action

data table.jpg]]>>attach:clear data table.jpg]] (* is mandatory) == **Properties** == **Input** * **Data Table(DataTable)*** - The data table that you want to clear the data. **Misc** * **Public

of this activity. You can edit the name of the activity to organize and structure your code better. Eg: Build Data

RCA.Activities.Core.BuildDataTable Description This activity allows you to create a new Data Table with different settings. In the body of activity Data Table - Click to add/ remove columns

Build Data Table

build data table.jpg

Data Table

Build Data Table

to organize and structure your code better. **Eg**: Build Data Table **Output** * **Data Table (DataTable

" %) ((( RCA.Activities.Core.BuildDataTable == **Description** == This activity allows you to create a new Data Table with different settings. [[[[image:build data table.jpg||class="img-thumbnail"]]>>attach:build data table.jpg