Search: excel-select-range

RCA.Activities.Excel.ExelSetBorder Description The activity allows you to set the borders through different ranges in Excel. This only can be used in Excel Application Scope Activity. (* is mandatory

. E.g: “Employee Infomation” Range (String)* - The Range that you want to border. E.g: “A1:K10” Misc

Excel Set Border

Excel Activities

Excel Set Border

" %) ((( RCA.Activities.Excel.ExelSetBorder == **Description** == The activity allows you to set the borders through different ranges in Excel. This only can be used in Excel Application Scope Activity. (% class="wikigeneratedid" id="H

Infomation” * **Range (String)*** - The Range that you want to border. E.g: “A1:K10” **Misc

into a specified spreadsheet cell or a range. If the sheet does not exist, a new one is created. (* for mandatory) In the body of activity Workbook Path - The path of the Excel file you want to use. E.g: “C

content - The value or formula that you want to be written to a cell or range. Only string variables

Excel Activities

spreadsheet cell or a range. If the sheet does not exist, a new one is created. [[image:image-20220505135743

of the Excel file you want to use. E.g: “C:\FolderName\ClientList.xlsx” * **Sheet name** - The sheet you want

to be written to a cell or range. Only string variables, generic variables and strings are supported. E.g

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 Activity. (* for mandatory) In the body of the activity Sheet name

) - Number of rows you want to insert in Excel sheet E.g: 5 Row position (Int) - Position where the rows

Excel Insert Rows

Excel Activities

Excel Insert Rows

in a table, range, or sheet at the specified location. This only can be used in Excel Application Scope

: “Employee Name” * **Number of row (Int) **- Number of rows you want to insert in Excel sheet E.g: 5

the macro level for the current Excel file. By default, EnableAll is selected. The drop-down contains three

Excel Macro settings Read Only (Checkbox): Opens the specified workbook in Read-Only mode. Selecting

RCA.Activities.Excel.ExcelApplicationScope Description This activity allows to open an Excel

Excel Application Scope

Excel Activities

Excel Application Scope

)** - Specifies the macro level for the current Excel file. By default, EnableAll is selected. The drop-down

. Selecting this check box enables you to perform data extraction operations in an Excel file which is locked

)**- When selected, the Excel file is opened in the foreground while performing actions on it. When

What's New [Added] Added Excel Set Range Format activity: This activity allows user to format cells and ranges according to a specific format. [Added] Screen Status Check Activity: This activity

and automate Excel tasks using Visual Basic for Applications. Insert VBA Activity: This activity allows you

** == * [Added] Added Excel Set Range Format activity: This activity allows user to format cells and ranges

for working with VBA code within your automation workflows, empowering you to customize and automate Excel

new VBA code into a workbook or a specific module. It helps you extend the functionality of your Excel

. The numbers at the top are totals that have accumulated during your selected date range. Below these numbers

This statistic shows the total number of documents uploaded to akaBot Vision in the date range. 2. Successfully

includes documents that were imported before the specified time frame the user set at the "Date Range

accumulated during your selected date range. Below these numbers, the time series represent the quantities

, the values on the x-axis represent time ranges as defined by a selected granularity. [[image:1704973235630

to akaBot Vision in the date range. == **2. Successfully Processed** == This statistic shows the total

RCA.Activities.Excel.ExcelReadCell Description This activity allows to read value of an Excel cell and store it in a variable. It is only be used inside the Excel Application Scope activity

to be read. If there is no amendment, “Sheet1” is automatically selected. “Cell” - Specified cell need has

Excel Read Cell

Excel Activities

Excel Read Cell

" %) ((( RCA.Activities.Excel.ExcelReadCell == **Description** == This activity allows to read value of an Excel cell and store it in a variable. It is only be used inside the Excel Application Scope activity. [[image:image-20220505112903-1

selected. * **“Cell” **- Specified cell need has to identify to read. If there is no amendment, “A1

in the top-right corner and select Administration. Go to the Roles and select Create new button. 4. A new dialog box opens, enter role name and select the level of impact on the system. Note: The increasing influence ranges from left to right, from none to delete. 5. Select Save to confirm

-right corner and select **Administration**. 1. Go to the **Roles **and select **Create new** button

. A new dialog box opens, enter role name and select the level of impact on the system. (% class="box infomessage" %) ((( **Note: **The increasing influence ranges from left to right, from none to delete

types of charts ranging from the most basic ones. Tableau Chart Catalog: A compilation of 100 basic to advanced types of charts, including a wide range of creative charts to serve various purposes. Duplicating

, as a CSV file, as an Excel file, or as a PowerPoint file. Step 1: To export a view, click on the Download

/profile/josh.weyburne/viz/CookBook/VizCookbook]]: A compilation of 52 different types of charts ranging

=no]]: A compilation of 100 basic to advanced types of charts, including a wide range of creative charts to serve

in different formats: as a PDF file, as an image file, as a CSV file, as an Excel file, or as a PowerPoint file

RCA.Activities.Core.SelectFile Description This activity opens a dialog, allows you to select a file and returns full path of the selected file. Properties Input Filter (String) – Used to specify the type of file you want to select. This filter should contain a description of the filter

Select File

Select File

" %) ((( RCA.Activities.Core.SelectFile == **Description** == This activity opens a dialog, allows you to select a file and returns full path of the selected file. [[image:image-20220505093334-1.jpeg]] == **Properties** == **Input** * **Filter (String) **– Used to specify the type of file you want to select. This filter should contain