Search: join-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
- 13Activities
- 1akaBot Studio
Creator
- 14Giang Tran
Last modification date
Creation date
Upload date
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
…." Only String variables and strings are supported. E.g: “ClientNames” Data Table (DataTable)* - The data
- 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 Insert Columns Table
Located in
- Rendered document content
position in the table. (* for mandatory) In the body of activity Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Table name (String) - Table name you
…must be made. E.g: "Sheet1" Table name (String) - Table name you want to insert. E.g: "Table1" Misc
- Title
Excel Insert Columns Table
- Location
Excel Insert Columns Table
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelInsertColumnsTable == **Description** == Adds a specified column at a certain position in the table. [[image:image
…)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" * **Table name (String)** - Table name you want to insert. E.g: "Table1" * **Column name (String)** - Name of column you want
Write Range
Located in
- Rendered document content
. Only string variables and strings are supported. Data Table - The data that you want to write
…to start writing data. Only string variables and strings are supported. Data Table (DataTable)* - The data
…RCA.Activities.Excel.WriteRange Description This activity allows you to write the data from
- Raw document content
and strings are supported. * **Data Table** - The data that you want to write to the specified range
…which to start writing data. Only string variables and strings are supported. * **Data Table (DataTable
…" %) ((( RCA.Activities.Excel.WriteRange == **Description** == This activity allows you to write the data from a DataTable variable
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 Write Range
Located in
- Rendered document content
. E.g: “A10” Data Table - The data that you want to write to the specified range, as a DataTable variable. Only DataTable variables are supported. Properties Input Data Table (DataTable)* - The data
…RCA.Activities.Excel.ExcelWriteRange Description This activity allows you to write the data from
- Raw document content
and strings are supported. E.g: “A10” * **Data Table** - The data that you want to write to the specified
…** * **Data Table (DataTable)*** - The data that you want to write to the specified range, as a DataTable
…" %) ((( RCA.Activities.Excel.ExcelWriteRange == **Description** == This activity allows you to write the data from a DataTable variable
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
…position of the image. You can edit the margin of the picture. E.g: 10 Table of Content
- 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
…the margin of the picture. E.g: 10 ))) (% class="akb-toc" %) ((( (% class="akb-toc-title" %) ((( Table
[2] How to use akaBot Studio
Located in
- Rendered document content
-builds hundreds of activities to perform the actions of automations on web, on desktop, working with data
…: In the akaBot Studio click File menu, chose Options. Step 2: In the table Options, click References Directories
…of automation projects. These activities enable robots: Manipulate the data by adding/extracting/reading
- Raw document content
on web, on desktop, working with data base, generating the PDF files, sending emails… This document aims
…Options. * Step 2: In the table Options, click References Directories tab, click Add button and chose
…enable robots: * Manipulate the data by adding/extracting/reading information. * Directly interaction
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
data. By default, this is filled in with "A1". E.g**:** "A1" == **Properties** == **Input
…)*** - The cell from which to start extracting the column data. By default, this is filled in with "A1". E.g: "A1
…to consider data security requirement before using this property. * **Display Name (String) **- The name
Excel Application Scope
Located in
- Rendered document content
: “AlphaPower123” Misc Public (CheckBox)- Check if you want to public it. Remember to consider data security
…this check box enables you to perform data extraction operations in an Excel file which is locked for editing
…are supported. Use Existing Workbook Existing Workbook (WorkbookApplication) - Use the data from an Excel file
- Raw document content
)**- Check if you want to public it. Remember to consider data security requirement before using
…. Selecting this check box enables you to perform data extraction operations in an Excel file which is locked
…) **- Use the data from an Excel file that was previously stored in a WorkbookApplication variable. Only
next page »
Page
1
2
RSS feed for search on [join-data-table]