Search: look-up-data-table

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

** * **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 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

. 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

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

" %) ((( 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

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

Excel Insert Columns Table

Excel Insert Columns Table

" %) ((( 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

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

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

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

** == * **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

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

" %) ((( 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

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

, 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

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

, 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

-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

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