Search: extract-structured-data
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Location
- 105Activities
Creator
- 63admin
- 41Giang Tran
- 1Nhan Nguyen
Last modification date
Creation date
Object type
Uploaded by
- 59Nhan Nguyen
- 45Giang Tran
- 4admin
Upload date
Read Range
Located in
- Rendered document content
(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
- Raw document content
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
Read Row
Located in
- Rendered document content
(String)* - The cell from which to start extracting the row data. By default, this is filled in with "A1
…" Starting Cell (String)* - The cell from which to start extracting the row data. By default, this is filled
…to consider data security requirement before using this property. Display Name (String) - The name
- Raw document content
extracting the row data. By default, this is filled in with "A1". E.g: "A1" == **Properties
…(String)*** - The cell from which to start extracting the row data. By default, this is filled in with "A1
…. Remember to consider data security requirement before using this property. * **Display Name (String
Get Event Info
Located in
- Rendered document content
RCA.Activities.Core.GetEventInfo Description This activity allows extracting different types
…. (* for Mandatory) 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
- Raw document content
" %) ((( RCA.Activities.Core.GetEventInfo == **Description** == This activity allows extracting different types of information
…)** - 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: Get Even Info * **Type Argument (Dropdown list
Excel Set Range Color
Located in
- Rendered document content
that contains the cell you want to color. E.g: “Name of the sheet” Range (String)* - The range of data
…)* - The extracted color stored as a system drawing color variable. E.g: Color.Red For list of color: https
…to public it. Remember to consider data security requirement before using it. Display Name (String
- Raw document content
(String)*** - The range of data in specified sheet you want to set color. String supported only. E.g: “A1:K10” * **Color (System.Drawing.Color)*** - The extracted color stored as a system drawing color
…]] **Misc** * **Public (Checkbox) **- Check if you want to public it. Remember to consider data security
Execute XPath
Located in
- Rendered document content
. This field supports only strings and string variables. 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
- Raw document content
. **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: Execute XPath
Get Elements
Located in
- Rendered document content
RCA.Activities.IE.GetElements Description Extracts the UI element on Internet Explorer. Activity
…it. Remember to consider data security requirements 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. Ex: [2424234
- Raw document content
" %) ((( RCA.Activities.IE.GetElements == **Description** == Extracts the UI element on Internet Explorer. Activity is only valid
…) **- Check if you want to publicize it. Remember to consider data security requirements before using
…and structure your code better. Ex: [2424234] Get Elements. **Output** * **Elements (IEElement
Get Text
Located in
- Rendered document content
RCA.Activities.IE.GetText Description The Get Text activity extracts on a webpage and saves
…) - Check if you want to publicize it. Remember to consider data security requirements before using
…and structure your code better. Ex: [71577779] Get Text Options From Element (IEElement) - Variable
- Raw document content
" %) ((( RCA.Activities.IE.GetText == **Description** == The Get Text activity extracts on a webpage and saves it in a String
…(Checkbox)** - Check if you want to publicize it. Remember to consider data security requirements before
…of the activity to organize and structure your code better. Ex: [71577779] Get Text **Options** * **From
Get Element
Located in
- Rendered document content
RCA.Activities.IE.GetElement Description Extracts multiple UI elements on Internet Explorer
…it. Remember to consider data security requirements 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. Ex: [34534534
- Raw document content
" %) ((( RCA.Activities.IE.GetElement == **Description** == Extracts multiple UI elements on Internet Explorer. Activity is only
…it. Remember to consider data security requirements 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. Ex: [34534534
Output Data Table
Located in
- Rendered document content
can edit the name of the activity to organize and structure your code better. Eg: Output data table
…RCA.Activties.Core.OutputDataTable Description This activity allows you to write a Data Table to a string using the CSV format. (* is mandatory) Properties Input Data Table (DataTable)* - The data
- Title
Output Data Table
- Attachment name
ouput data table.jpg
- Location
Data Table
…Output Data Table
- Raw document content
and structure your code better. **Eg**: Output data table **Output** * **Text **- The output of the Data
…" %) ((( RCA.Activties.Core.OutputDataTable == **Description** == This activity allows you to write a Data Table to a string using the CSV format. [[image:ouput data table.jpg]] (* is mandatory) == **Properties** == **Input
Remove Duplicated Rows
Located in
- Rendered document content
duplicate rows in the data table. (* is mandatory) Properties Input Data Table (DataTable)* - The data table you want to check. Misc Public (Checkbox) - Check if you want to publicize it. Remember to consider data security requirements before using it. Display Name (String) - The name of this activity. You
- Location
Data Table
- Raw document content
" %) ((( RCA.Activities.Core.RemoveDuplicatedRows == **Description** == This activity allows you to remove duplicate rows in the data table
…** == **Input** * **Data Table (DataTable)* **- The data table you want to check. **Misc** * **Public (Checkbox) **- Check if you want to publicize it. Remember to consider data security requirements before