Search: insert-data-table
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Location
- 373Activities
- 15akaBot Vision
- 10akaBot Center
- 3akaBot Insights
- 2Data Service
- … 5 more
Last author
- 87Nga Nguyen
- 70Tuan Nguyen
- 63VuNH54
- 58Nhan Nguyen
- 49admin
- … 3 more
Creator
- 239admin
- 65Giang Tran
- 54Tuan Nguyen
- 35Nga Nguyen
- 9Nhan Nguyen
- … 2 more
Last modification date
Creation date
Object type
- 4Activities
- 1Overview
- 1aka Bot Vision
Uploaded by
- 141Nga Nguyen
- 100Nhan Nguyen
- 72Giang Tran
- 55Tuan Nguyen
- 49admin
- … 3 more
Look Up Data Table
Located in
- Rendered document content
supports only strings and String variables. E.g: “WordIWantToSearch” Data Table (DataTable
…to organize and structure your code better. Eg: Look up the data table Output Cell Value - Optional
…for. This field supports only strings and String variables. Eg: “Name of column” Data Column (DataColumn
- Title
Look Up Data Table
- Attachment name
look up data table.jpg
- Location
Data Table
…Look Up Data Table
- Raw document content
only strings and String variables. E.g: “WordIWantToSearch” * **Data Table (DataTable
…the data table **Output** * **Cell Value** - Optional. The value found in the cell that has the Row
…in the Target Column property category. [[[[image:look up data table.jpg||class="img-thumbnail
[4] Capture Custom Table Data
Located in
- Rendered document content
. Adding a new table In order to create a new table, click [Add Field], select Data Type = “table
…A basic element in the extraction schema is the data field. However, akaBot Vision enables the capture of even more complex structures like tables. Adding a predefined table field If you are missing
- Title
[4] Capture Custom Table Data
- Location
Capturing Custom Table Data in akaBot Vision
…Customizing Data Extract
- Raw document content
, click [Add Field], select Data Type = “table” and then input the value you want to create a new table
…="wikigeneratedid" id="HParagraph1" %) A basic element in the extraction schema is the data field. However, akaBot Vision enables the capture of even more complex structures like tables. == **Adding a predefined table
Excel Insert Rows
Located in
- Rendered document content
to insert one or more rows in a table, range, or sheet at the specified location. This only can be used
…(String)* - The name of the sheet that you want to insert row. E.g: “Employee Name” Number of row (Int) - Number of rows you want to insert in Excel sheet E.g: 5 Row position (Int) - Position where the rows
- Title
Excel Insert Rows
- Location
Excel Insert Rows
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelInsertRows == **Description** == This activity allows you to add more rows to insert one or more rows in a table, range, or sheet at the specified location. This only can be used in Excel Application Scope
…of the activity** == * **Sheet name (String)*** - The name of the sheet that you want to insert row. E.g
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
…file you want to insert. This field accepts only strings and String variables. E.g: “C:\FolderName
…path of the image or click “…” button to choose file you want to insert. This field accepts only
- Title
Excel Insert Image
- Location
Excel Insert Image
- Raw document content
want to insert image to. E.g: “Employee Data” * **Range (String)* **- The range you want to add image
…(String)** - Input the full path of the image or click “…” button to choose file you want to insert
…path of the image or click “…” button to choose file you want to insert. This field accepts only
[3] Review Document
Located in
- Rendered document content
, akaBot Vision provides users with the capability to add or remove rows in a table To insert a row, you can click "+" icon To delete a row, you can click "x" icon To add a new row at the end of the table
…After importing the document successfully and the data extraction process is successfully finished
- Raw document content
or remove rows in a table * To insert a row, you can click "+" icon * To delete a row, you can click "x
…="wikigeneratedid" %) After importing the document successfully and the data extraction process is successfully
…with this status in the “To review” tab in the user interface. [[image:image-20220420193327-1.png||data-xwiki
Sandbox
Located in
- Rendered document content
of the XWiki Syntax you can use in wiki pages (headings, images, tables). Headings XWiki offers 6 levels
…1 Numbered list Item Subitem Item Subitem Mixed list Item 1 Item 2 Item 3 Item 4 Item 5 Tables You can create tables right into wiki pages: Table with headers in the top row table header table
- Raw document content
>>XWiki.XWikiSyntax]] you can use in wiki pages (headings, images, tables). = Headings = XWiki offers 6 levels
…. Item 1 11. Item 2 11*. Item 3 11*. Item 4 1. Item 5 = Tables = You can create tables right into wiki pages: == Table with headers in the top row == |= table header |= table header |= table header | cell
Execute Non Query
Located in
- Rendered document content
statement on a database. For UPDATE, INSERT, and DELETE statements, the return value is the number of rows
…) In the body of activity Configure Connection - Set connection string, data source, data provider. Edit
…if you want to publicize it. Remember to consider data security requirements before using it. Display
- Raw document content
. For UPDATE, INSERT, and DELETE statements, the return value is the number of rows affected by the command
…]] (* 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
Excel Insert Or Delete Columns
Located in
- Rendered document content
) - The number of columns you wish to add or remove. E.g: 1 Position (Int32) - The column where the insertion
…to add or remove. E.g: 1 Position (Int32) - The column where the insertion or removal begins. E.g: 2
…if you want to public the activity. Remember to consider data security requirement before using
- Title
Excel Insert Or Delete Columns
- Location
Excel Insert Or Delete Columns
- Raw document content
)** - The column where the insertion or removal begins. E.g: 2 * **Sheet name (String)*** - The name of the sheet
…)** - The column where the insertion or removal begins. E.g: 2 **Input** * **Change Mode (Dropdown List
…to public the activity. Remember to consider data security requirement before using this property
Excel Insert Or Delete Rows
Located in
- Rendered document content
) - The number of rows you wish to add or remove. E.g: 1 Position (Int32) - The row where the insertion
…) - The number of rows you wish to add or remove. E.g: 1 Row Position (Int32) - The row where the insertion
…: "Sheet1" Misc Public (Boolean) - Check if you want to public the activity. Remember to consider data
- Title
Excel Insert Or Delete Rows
- Location
Excel Insert Or Delete Rows
- Raw document content
)** - The row where the insertion or removal begins. By default, this is filled in with 1. E.g: 2 * **Sheet
…or remove. E.g: 1 * **Row Position (Int32)** - The row where the insertion or removal begins. By default
…. Remember to consider data security requirement before using this property. * **Display Name (String
Open Browser
Located in
- Rendered document content
it. (* for Mandatory) In the body of activity URL (String) - Insert a specified URL in the container. Ex: “https
…(Browser)* - Insert the specified browser in which activities could be active. URL (String)* - Provide
…want to publicize it. Remember to consider data security requirements before using it. Display Name
- Raw document content
-20220506110901-1.png]] (* for Mandatory) **In the body of activity** * **URL (String)** - Insert
…Browser (Browser)*** - Insert the specified browser in which activities could be active. * **URL (String
…to consider data security requirements before using it. * **Display Name (String)** - The name