Search: excel-application-scope

Excel Set Border

Located in

Last modified by Giang Tran on 2022/05/13 06:28

Rendered document content: 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) Properties Input Sheet name (String)* - The name of the sheet that contains the cell you want to border
Title: Excel Set Border
Location: Excel Activities
…
Excel Set Border
Raw document content: (% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( 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

Located in

Last modified by VuNH54 on 2023/04/20 09:37

Rendered document content: only be used in the Excel Application Scope activity. (* is mandatory) In the body of activity
…
RCA.Activities.Excel.ExcelReadRange Description This activity allows you to read the value of an Excel range and store it in a DataTable variable. If the range is not specified, the whole spreadsheet
Title: Excel Read Range
Location: Excel Activities
…
Excel Read Range
Raw document content: as a cell, the whole spreadsheet starting from that cell is read. Can only be used in the Excel Application Scope activity. [[image:image-20220505113128-1.jpeg]] (* is mandatory) == **In the body of activity
…
" %) ((( RCA.Activities.Excel.ExcelReadRange == **Description** == This activity allows you to read the value of an Excel range and store

Located in

Last modified by Giang Tran on 2022/05/13 06:50

Rendered document content: RCA.Activities.Excel.ExecuteMacro Description This activity allows you to execute the macro within a workbook. The Workbook file needs to be a Macro-Enabled Workbook. Changes are immediately saved. Can only be used in the Excel Application Scope activity. (* for mandatory) Properties Common
Location: Excel Activities
Raw document content: in the Excel Application Scope activity. [[image:image-20220505134614-1.jpeg]] (* for mandatory

Located in

Last modified by VuNH54 on 2023/04/19 17:20

Rendered document content: to specified Excel Sheets. This only can be used in Excel Application Scope Activity. (* is mandatory
…
) - The height of the image that you want to insert in Excel. E.g: 50 Image Width (Single) - The width of the image that you want to insert in Excel. E.g: 50 Offset Left (Single) - It returns to the left position
Title: Excel Insert Image
Location: Excel Activities
…
Excel Insert Image
Raw document content: " %) ((( RCA.Activities.Excel.ExcelInsertImage == **Description** == This activity allows you to add images to specified Excel Sheets. This only can be used in Excel Application Scope Activity. (% class="wikigeneratedid" id="H
…
**Options** * **Image Height (Single)** - The height of the image that you want to insert in Excel. E.g: 50

Located in

Last modified by VuNH54 on 2023/04/20 10:39

Rendered document content: . Can only be used in the Excel Application Scope activities. (* is mandatory) In the body
…
- The Excel cell or range that you want to write to. If the range isn't specified, the whole spreadsheet
…
: “Hello world” or “=B1+C2” Properties Input Cell (String)* - The Excel cell or range that you want
Title: Excel Write Cell
Location: Excel Activities
…
Excel Write Cell
Raw document content: be used in the Excel Application Scope activities. [[image:image-20220505113619-1.jpeg]] (* is mandatory
…
: “ClientName” * **Cell** - The Excel cell or range that you want to write to. If the range isn't specified
…
)*** - The Excel cell or range that you want to write to. If the range isn't specified, the whole spreadsheet

Located in

Last modified by VuNH54 on 2023/04/20 10:42

Rendered document content: range are overwritten. Changes are immediately saved. Can only be used in the Excel Application Scope
…
of the activity to organize and structure your code better. E.g: Write Range Excel Options Add Headers (Checkbox
Title: Excel Write Range
Location: Excel Activities
…
Excel Write Range
Raw document content: are immediately saved. Can only be used in the Excel Application Scope activities. [[image:image-20220505114134-2
…
Range Excel **Options** * **Add Headers (Checkbox) **- When selected, column headers are also written

Located in

Last modified by VuNH54 on 2023/04/13 15:54

Rendered document content: is a solution for application integration, business processes automation. It provides a wide range of activities
…
automation projects. The activities are grouped into different categories such as: Excel, XML, ControlFlow
…
information. Directly interaction with websites, windows applications…to simulate the human actions
Raw document content: . akaBot Studio is a solution for application integration, business processes automation. It provides
…
into different categories such as: Excel, XML, ControlFlow, Primitives, Care, HTTP... |4|Designer|Display you
…
with websites, windows applications…to simulate the human actions. [[image:image-20220506164447-33.png