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
- 124Activities
- 5akaBot Vision
Last author
- 41Giang Tran
- 24Nhan Nguyen
- 22VuNH54
- 16DatPT
- 15Tuan Nguyen
- … 1 more
Creator
- 55Giang Tran
- 44admin
- 23Tuan Nguyen
- 7Nhan Nguyen
Last modification date
Creation date
Object type
Uploaded by
- 64Giang Tran
- 42Nhan Nguyen
- 23Tuan Nguyen
- 12admin
- 3VuNH54
- … 1 more
Upload date
Filter Data Table
Located in
- Rendered document content
Input Data Table (DataTable)* - The DataTable variable that you want to filter. This field supports
…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: Filter DataTable
- Title
Filter Data Table
- Attachment name
filter data table.jpg
- Location
Data Table
- Raw document content
button so that you can access the wizard and customize your settings at any time. [[[[image:filter data table.jpg||class="img-thumbnail"]]>>attach:filter data table.jpg]] (* is mandatory) == **In the body
….png||height="341" width="482"]] == **Properties** == **Input** * **Data Table (DataTable
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
Append Range
Located in
- Rendered document content
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
- Raw document content
". 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
Excel Select Sheet
Located in
- Rendered document content
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 code better
- Raw document content
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: Select Sheet
Read CSV File
Located in
- Rendered document content
of the CSV file E.g: “C:\CSVFolder\clientList.csv” 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: Read CSV
Excel Close Workbook
Located in
- Rendered document content
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: Close Workbook Use Workbook Workbook
- Raw document content
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: Close Workbook
Log Message
Located in
- Rendered document content
) - If you check it, the data of this activity will be shown in the log. Be careful, consider data security
…to organize and structure your code better. E.g: [477455298] Log Message
- Raw document content
: “Warning! This is an error message” **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
Get Row Item
Located in
- Rendered document content
: “ColumnNameThatNeed”. Data Row* - The DataRow object from which a value is to be retrieved. Misc Public (Checkbox) - Check if you want to publicize it. Remember to consider data security requirements before using
…and structure your code better. Eg: Get row item Output Value - The column value from the specified DataRow.
- Location
Data Table
- Raw document content
: “ColumnNameThatNeed”. * **Data Row*** - The DataRow object from which a value is to be retrieved. **Misc** * **Public (Checkbox) **- Check if you want to publicize it. Remember to consider data security requirements
…of the activity to organize and structure your code better. Eg: Get row item **Output** * **Value
Excel Get Workbook Sheets
Located in
- Rendered document content
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 code better
- Raw document content
) **- Check if you want to public it. Remember to consider data security requirement before using
…and structure your code better. E.g: Get Workbook Sheets ))) (% class="akb-toc" %) ((( (% class="akb-toc-title
[08]Refresh
Located in
- Rendered document content
to organize and structure your code better. E.g: [5666565] Refresh Public (Checkbox) - Check if you want to public it. Remember to consider data security requirement before using it. Default is un check.
- Raw document content
and structure your code better. E.g: [5666565] Refresh * **Public (Checkbox)** - Check if you want to public it. Remember to consider data security requirement before using it. Default is un check. ))) {{velocity