Search: gsuite-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
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 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

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
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
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
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
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: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
Raw document content: in the Excel Application Scope activity. [[image:image-20220505134614-1.jpeg]] (* for mandatory

Located in

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

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

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