Search: 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. (* is mandatory

to organize and structure your code better. E.g: “Set Border” Options Border Weight (Dropdown list box

Excel Set Border

Excel Set Border

Excel Activities

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

of the activity to organize and structure your code better. E.g: **“Set Border”** **Options** * **Border

of a specified cell or cell range using a Color variable. Can only be used within the Excel Application Scope

in specified sheet you want to set color. String supported only. E.g: “A1:K10” Color (System.Drawing.Color

. E.g: Set Range Color

Excel Set Range Color

Excel Set Range Color

Excel Activities

using a Color variable. Can only be used within the Excel Application Scope activity. [[image:image

(String)*** - The range of data in specified sheet you want to set color. String supported only. E.g: “A1

of the activity to organize and structure your code better. E.g: Set Range Color ))) {{velocity

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 workbook and provides a scope for Excel Activities. (* for mandatory) In the body of the activity

Excel Application Scope

Excel Activities

Excel Application Scope

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

" %) ((( RCA.Activities.Excel.ExcelApplicationScope == **Description** == This activity allows to open an Excel workbook and provides a scope for Excel Activities. [[image:image-20220505111836-1.jpeg]] (* for mandatory) == **In the body

RCA.Activities.Excel.ReadRange Description This activity allows you to read the Excel range

Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C:\FolderName\SaleReport.xlsx

) - The path of the Excel file you want to read. E.g: “C:\FolderName\SaleReport.xlsx” Sheet name (String

Excel Activities

" %) ((( RCA.Activities.Excel.ReadRange == **Description** == This activity allows you to read the Excel range and store

) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel file you want to read

: "A1:B2" == **Properties** == **Input** * **Workbook Path (String) **- The path of the Excel

) In the body of activity Workbook Path - The path of the Excel file you want to write to. E.g: “C:\FolderName

Workbook Path (String)* - The path of the Excel file you want to write to. E.g: “C:\FolderName

. By default, this check box is selected (set to True).

Excel Activities

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

Path (String)*** - The path of the Excel file you want to write to. E.g: “C:\FolderName\ClientList.xlsx

are also extracted. By default, this check box is selected (set to True). ))) {{velocity

automation projects. The activities are grouped into different categories such as: Excel, XML, ControlFlow

and the relationship between a set of predefined activities in akaBot Studio. To create a new workflow project, you

category, set the project to be published to Orchestrator 8. Add Activity To add activity Step 1

into different categories such as: Excel, XML, ControlFlow, Primitives, Care, HTTP... |4|Designer|Display you

and the relationship between a set of predefined activities in akaBot Studio. To create a new workflow project, you

project window opens * ((( Step 3: In the Publish Location category, set the project to be published