Search: gsuite-application-scope
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Location
- 15Activities
- 1akaBot Studio
Last author
- 9Giang Tran
- 7VuNH54
Last modification date
Creation date
Uploaded by
- 16Giang Tran
- 1VuNH54
Upload date
Excel Application Scope
Located in
- 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
- 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
Excel Close Workbook
Located in
- 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
- 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
Excel Save Workbook
Located in
- 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 Misc Public (Checkbox) - Check if you want to public it. Remember to consider data security
- Raw document content
(% 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
Excel Get Workbook Sheets
Located in
- 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
- 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
Excel Get Workbook Sheet
Located in
- 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
- 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
Excel Set Range Color
Located in
- 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
- 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
Excel Save As Workbook
Located in
- 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
- 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 Cell
Located in
- 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
- 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
Execute Macro
Located in
- 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
- Raw document content
in the Excel Application Scope activity. [[image:image-20220505134614-1.jpeg]] (* for mandatory
Excel Insert Rows
Located in
- Rendered document 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 Activity. (* for mandatory) In the body of the activity Sheet name
- Raw document content
(% 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
next page »
Page
1
2
RSS feed for search on [gsuite-application-scope]