Search: excel-application-scope

Last modified by admin on 2022/04/24 04:58

Results 1 - 10 of 17 next page » Page 1 2

Excel Write Range

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

Excel Write Cell

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

Excel Save As Workbook

Last modified by VuNH54 on 2023/04/20 09:45
Rendered document content
RCA.Activities.Excel.ExcelSaveAsWorkbook Description The activity allows you to save changes as a new file. This only can be used in Excel Application Scope Activity. (* for mandatory) In the body of activity File Path (String)* - Input the full path of the file or click “…” button to choose an existed
Title
Excel Save As Workbook
Location
Excel Activities
Excel Save As Workbook
Raw document content
(% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activities.Excel.ExcelSaveAsWorkbook == **Description** == The activity allows you to save changes as a new file. This only can be used in Excel Application Scope Activity. [[image:image-20220505135028-1.jpeg]] (* for mandatory

Excel Read Range

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

Excel Insert Image

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

Excel Application Scope

Last modified by VuNH54 on 2023/04/19 16:56
Rendered document content
of the activity to organize and structure your code better. E.g: Excel Application Scope Options Break Links
. This variable can be used in another Excel Application Scope activity. Only WorkbookApplication variables
workbook and provides a scope for Excel Activities. (* for mandatory) In the body of the activity
Title
Excel Application Scope
Location
Excel Application Scope
Excel Activities
Raw document content
and structure your code better. E.g: Excel Application Scope **Options** * **Break Links (Checkbox)** - Break
in a WorkbookApplication variable. This variable can be used in another Excel Application Scope activity. Only
" %) ((( RCA.Activities.Excel.ExcelApplicationScope == **Description** == This activity allows to open an Excel workbook and provides a scope

[2] How to use akaBot Studio

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

Activities

Last modified by admin on 2022/07/01 15:42
Rendered document content
Append Range Excel Append Range Excel Application Scope Excel Close Workbook Excel Copy Paste Range Excel Copy Sheet Excel Delete Range Excel Get Workbook Sheet Excel Get Workbook Sheets Excel Insert Columns Table Excel Insert Or Delete Columns Excel Insert Or Delete Rows Excel Insert Rows Excel
Location
Excel Activities
Raw document content
/Excel%20Activities/Activities/Append%20Range/]] * [[Excel Append Range>>url:https://docs.akabot.com/bin/view/Activities/Excel%20Activities/Activities/Excel%20Append%20Range/]] * [[Excel Application Scope>>url:https://docs.akabot.com/bin/view/Activities/Excel%20Activities/Activities/Excel%20Application%20Scope

Execute Macro

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

Excel Set Range Color

Last modified by Giang Tran on 2022/05/13 06:48
Rendered document content
RCA.Activities.Excel.ExcelSetRangeColor Description This activity allows changing color of a specified cell or cell range using a Color variable. Can only be used within the Excel Application Scope activity. (* for mandatory) Properties Input Sheet name (String)* - The name of the sheet
Title
Excel Set Range Color
Location
Excel Activities
Excel Set Range Color
Raw document content
(% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activities.Excel.ExcelSetRangeColor == **Description** == This activity allows changing color of a specified cell or cell range using a Color variable. Can only be used within the Excel Application Scope activity. [[image:image
next page » Page 1 2
RSS feed for search on [excel-application-scope]
Created by admin on 2022/04/17 14:38