Search: excel-application-scope

Excel Application Scope

Located in

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

Located in

Last modified by Giang Tran on 2022/05/13 04:27

Rendered document content: RCA.Activities.Excel.ExcelCloseWorkbook Description The activity allows you to close an open Workbook. This only can be used in Excel Application Scope Activity. (* for mandatory) Properties
…
(WorkbookApplication)* - The workbook that you want to close. It can be an output from Excel Application Scope or any
Title: Excel Close Workbook
Location: Excel Activities
…
Excel Close Workbook
Raw document content: in Excel Application Scope Activity. [[image:image-20220505135216-1.jpeg]] (* for mandatory
…
be an output from Excel Application Scope or any other activities above. Only WorkbookApplication variables

Located in

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

Rendered document content: RCA.Activities.Excel.ExcelSaveAsWorkbook Description This activity allows you to save changes to the workbook. This only can be used in Excel Application Scope Activity. (* for mandatory) Properties
…
of the activity to organize and structure your code better. E.g: Excel Save Workbook
Title: Excel Save Workbook
Location: Excel Activities
…
Excel Save Workbook
Raw document content: can be used in Excel Application Scope Activity. [[image:image-20220505134823-1.jpeg
…
of this activity. You can edit the name of the activity to organize and structure your code better. E.g: Excel

Located in

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

Located in

Last modified by Giang Tran on 2022/05/05 06:26

Rendered document content: RCA.Activities.Excel.ExcelGetWorkbookSheets Description This activity allows you to look for a sheet based on its index and returns its name as a String variable. This only can be used in Excel Application Scope Activity. (* for mandatory) Properties Misc Public (Checkbox) - Check if you want
Title: Excel Get Workbook Sheets
Location: Excel Activities
…
Excel Get Workbook Sheets
Raw document content: (% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activities.Excel.ExcelGetWorkbookSheets == **Description** == This activity allows you to look for a sheet based on its index and returns its name as a String variable. This only can be used in Excel Application Scope Activity

Located in

Last modified by Giang Tran on 2022/05/13 04:32

Rendered document content: 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 Activity. (* for mandatory) Properties Input Index (Int)* - The index of the sheet that you want
Title: Excel Get Workbook Sheet
Location: Excel Activities
…
Excel Get Workbook Sheet
Raw document content: (% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( 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 Activity. [[image:image

Located in

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

Located in

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

Located in

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

Rendered document content: 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. (* is mandatory) In the body of the activity “Sheet Name” – Name of the sheet contains the cell which is aimed
Title: Excel Read Cell
Location: Excel Activities
…
Excel Read Cell
Raw document content: (% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( 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

Located in

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

Rendered document content: 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
Title: Excel Insert Rows
Location: Excel Activities
…
Excel Insert Rows
Raw document content: 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