Search: excel-application-scope

Excel Close Workbook

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 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 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

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 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