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
Excel Write Cell
Located in
- Rendered document content
Public (Checkbox) - Check if you want to public it. Remember to consider data security requirement before
…to organize and structure your code better. E.g: Excel Write Cell
- Raw document content
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. **E.g**: Excel
Excel Save As Workbook
Located in
- Rendered document content
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
- Raw 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: Save as Workbook **Options** * **File Format
Excel Read Range
Located in
- Rendered document content
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. E.g: Read Range
- 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**: Read Range ))) {{velocity}} #if ($xcontext.action != 'export
Excel Insert Image
Located in
- Rendered document content
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
- Raw document content
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
Excel Insert Or Delete Columns
Located in
- Rendered document content
if you want to public the activity. Remember to consider data security requirement before using
…to organize and structure your code better. E.g: [038325762] Excel Insert Or Delete Columns Options
- Raw document content
to public the activity. Remember to consider data security requirement before using this property
…and structure your code better. E.g: [038325762] Excel Insert Or Delete Columns **Options** * **CopyOrigin
Excel Insert Columns Table
Located in
- Rendered document content
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
- Raw document content
) **- 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
Excel Append Range
Located in
- Rendered document content
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
- Raw document content
" %) ((( 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
Excel Application Scope
Located in
- Rendered document content
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
- Raw document content
. 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
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
Insert Data Table
Located in
- Rendered document content
can edit the name of the activity to organize and structure your code better. Eg: Insert Data Table
…) In the body of activity Configure Connection - Set connection string, data source, data provider. Data
…and descriptions must match the ones from the database table. Table Name - The SQL table in which the data
- Title
Insert Data Table
- Location
Insert Data Table
- Raw document content
to organize and structure your code better. Eg: Insert Data Table **Output** * **Affected Records (Int32
…]] (* for Mandatory) == **In the body of activity** == * **Configure Connection **- Set connection string, data source, data provider. [[image:https://docs.akabot.com/bin/download/Activities/Database/Activities