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
- 381Activities
- 18akaBot Vision
- 3akaBot Center
- 2akaBot Studio
- 1Data Service
- … 1 more
Last author
- 89Nga Nguyen
- 70Tuan Nguyen
- 67VuNH54
- 59Nhan Nguyen
- 46Giang Tran
- … 2 more
Creator
- 230admin
- 64Giang Tran
- 56Tuan Nguyen
- 35Nga Nguyen
- 10Nhan Nguyen
- … 2 more
Last modification date
Creation date
Object type
- 5aka Bot Center
- 3Activities
- 2Live Table
- 2UI Extension
- 2Rights
Uploaded by
- 141Nga Nguyen
- 102Nhan Nguyen
- 72Giang Tran
- 55Tuan Nguyen
- 30admin
- … 2 more
Upload date
Run Python Script
Located in
- Rendered document content
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. Eg: Run Python
- Raw document content
(Checkbox) **- Check if you want to publicize it. Remember to consider data security requirements before
…to organize and structure your code better. Eg: Run Python Script ))) {{velocity}} #if ($xcontext.action
Python Scope
Located in
- Rendered document content
) - Check if you want to publicize it. Remember to consider data security requirements before using
…and structure your code better. Eg: “Python function” Options Python Version (DropDownlist) - A list of Python
- Raw document content
to publicize 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
Load Python Script
Located in
- Rendered document content
(Checkbox) - Check if you want to publicize it. Remember to consider data security requirements before using
…and structure your code better. Eg: Load Python Script. Output Result (PythonObject) - The handlers
- Raw document content
if you want to publicize it. Remember to consider data security requirements before using it. * **Display
…and structure your code better. Eg: Load Python Script. **Output** * **Result (PythonObject) **- The handlers
Get Excel Column Name
Located in
- Rendered document content
the activity. Remember to consider data security requirement before using this property. 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
to consider data security requirement before using this property. * **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: [482156710
Excel Read Column
Located in
- Rendered document content
- 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
- Raw document content
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
Excel Read Row
Located in
- Rendered document content
. 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
- Raw document content
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
Write Range
Located in
- Rendered document content
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
- Raw document content
" %) ((( 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
Write Cell
Located in
- Rendered document content
:\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
- Raw document content
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
Read Column
Located in
- Rendered document content
(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
- Raw document content
)*** - 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
Excel Write Range
Located in
- Rendered document content
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
- Raw document content
" %) ((( 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