Search: look-up-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
- 56Activities
- 1akaBot Studio
Last author
- 39Giang Tran
- 13DatPT
- 5VuNH54
Creator
- 50Giang Tran
- 7admin
Last modification date
Creation date
Upload date
Get Files
Located in
- Rendered document content
is unknown. E.g: 4/4/2021 9:00 AM Creation Time (To) (DateTime) – Looks for files that are created up to this date. Change to DateTime.Now to look for files up to the current run time of the bot. E.g: 4/7/2021 9
…To (DateTime) – Looks for files that have the last modification date and time up to this date. If not specified
- Raw document content
** * **Creation Time (From) (DateTime)** – Looks for files create from this date onward. Left blank if the created time is unknown. E.g: 4/4/2021 9:00 AM * **Creation Time (To) (DateTime)** – Looks for files that are created up to this date. Change to //DateTime.Now// to look for files up to the current run time
Excel LookUp Range
Located in
- Rendered document content
] Excel Lookup Range Option Look in (Dropdown List) - Select type of value to look up into range
…. Remember to consider data security requirement before using this property. Display Name (String) - The name
- Raw document content
. E.g: [759682936] Excel Lookup Range **Option** * **Look in (Dropdown List) **- Select type of value to look up into range that has been selected: Formulas, Values, Comments **Output
…. Remember to consider data security requirement before using this property. * **Display Name (String
Excel Get Workbook Sheets
Located in
- Rendered document content
RCA.Activities.Excel.ExcelGetWorkbookSheets Description This activity allows you to look
…to public it. Remember to consider data security requirement before using it. Display Name (String
…. E.g: Get Workbook Sheets Table of Content Output Sheet (List< String >) - List of string
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelGetWorkbookSheets == **Description** == This activity allows you to look for a sheet based on its index
…) **- Check if you want to public it. Remember to consider data security requirement before using
…" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) ))) **Output** * **Sheet (List< String
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
Append CSV File
Located in
- Rendered document content
of activity File path (String) - You can add the file path of the CSV here. String supported only. Data Table (DataTable) - The data table you want to append. Properties File File Path (String)* - The file path of the CSV file E.g: “C:\CSVFolder\clientList.csv” Input Data Table (DataTable)* - Specifies the DataTable
- Raw document content
of the CSV here. String supported only. * **Data Table (DataTable)** - The data table you want to append
…\clientList.csv” **Input** * **Data Table (DataTable)*** - Specifies the DataTable to be appended to the CSV
…)** - If you check it, the data of this activity will be shown in the log. Be careful, consider data security
Write CSV File
Located in
- Rendered document content
the file path of the CSV here. String supported only. Data Table (DataTable) - Specifies the DataTable to be written in the CSV file. Properties Input Data Table (DataTable)* - Specifies the DataTable
…\clientList.csv” Misc Public (CheckBox) - If you check it, the data of this activity will be shown in the log
- Raw document content
** == * **File Path (String)** - You can add the file path of the CSV here. String supported only. * **Data Table (DataTable)** - Specifies the DataTable to be written in the CSV file. == **Properties** == **Input** * **Data Table (DataTable)*** - Specifies the DataTable to be written in the CSV file
Excel Get Workbook Sheet
Located in
- Rendered document content
RCA.Activities.Excel.ExcelGetWorkbookSheet Description This activity allows you to look for a sheet based on its index and returns its name as a String variable. be used in Excel Application Scope
…if you want to public it. Remember to consider data security requirement before using it. Display Name
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelGetWorkbookSheet == **Description** == This activity allows you to look for a sheet based on its index
…data security requirement before using it. * **Display Name (String) **- The name of this activity
…" %) ((( (% class="akb-toc-title" %) ((( Table of Content ))) {{toc depth="4" start="2"/}} ))) #end
Excel Copy Paste Range
Located in
- Rendered document content
or sheet (including values, formulas, table format, and cell format) and pastes it to another location
…Destination Cell (String)* - The starting cell where you want to paste the copied data. This field supports
…the copied data into. This field supports only strings and String variables E.g: “TargetSheetName” Input
- Raw document content
, table format, and cell format) and pastes it to another location in the current workbook
…to SpeadSheet** * **Destination Cell (String)* **- The starting cell where you want to paste the copied data
…)*** - The sheet you want to paste the copied data into. This field supports only strings and String variables E.g
Read CSV File
Located in
- Rendered document content
Data Table (DataTable) - Represents the output DataTable that contains the information obtained from
…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
- Raw document content
, it is selected. **Output** * **Data Table (DataTable)** - Represents the output DataTable that contains
…” **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
[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
…, by default a sequence activity will be shown up in the Designer panel allowing you to start developing your
…1: Click ‘Options’ Step 2: Press to up or down size milliseconds between debug ste Step 3: Press
- Raw document content
on web, on desktop, working with data base, generating the PDF files, sending emails… This document aims
…activity will be shown up in the Designer panel allowing you to start developing your project
…to up or down size milliseconds between debug ste** Step 3**: Press button ‘Ok’ to submit the change