Search: gsuite-application-scope

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

Excel Application Scope

Excel Application Scope

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

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

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

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 Misc Public (Checkbox) - Check if you want to public it. Remember to consider data security

(% class="akb-page-with-toc" %) ((( (% class="akb-page-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. [[image:image-20220505134823-1.jpeg

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

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

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

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

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

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

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

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

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

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

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

in the Excel Application Scope activity. [[image:image-20220505134614-1.jpeg]] (* for mandatory

RCA.Activities.Excel.ExcelInsertRows Description This activity allows you to add more rows to insert one or more rows in a table, range, or sheet at the specified location. This only can be used in Excel Application Scope Activity. (* for mandatory) In the body of the activity Sheet name

(% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activities.Excel.ExcelInsertRows == **Description** == This activity allows you to add more rows to insert one or more rows in a table, range, or sheet at the specified location. This only can be used in Excel Application Scope