Search: excel-get-workbook-sheets

Excel Read Cell

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: " %) ((( 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.jpeg]] (* is mandatory) == **In the body of the activity** == * **“Sheet Name”** – Name

Located in

Last modified by VuNH54 on 2023/04/20 10:42

Rendered document content: . If the starting cell isn't specified, the data is written starting from the A1 cell. If the sheet does not exist
…
range are overwritten. Changes are immediately saved. Can only be used in the Excel Application Scope activities. (* is mandatory) In the body of activity Sheet Name - The sheet you want to write
Title: Excel Write Range
Location: Excel Activities
…
Excel Write Range
Raw document content: , the data is written starting from the A1 cell. If the sheet does not exist, a new one is created
…
are immediately saved. Can only be used in the Excel Application Scope activities. [[image:image-20220505114134-2.jpeg]] (* is mandatory) == **In the body of activity** == * **Sheet Name **- The sheet you want

Located in

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

Rendered document content: 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 that contains the cell you want to color. E.g: “Name of the sheet” Range (String)* - The range of data
Title: Excel Set Range Color
Location: Excel Activities
…
Excel Set Range Color
Raw document content: using a Color variable. Can only be used within the Excel Application Scope activity. [[image:image-20220505133337-1.jpeg]] (* for mandatory) == **Properties** == **Input** * **Sheet name (String)* **- The name of the sheet that contains the cell you want to color. E.g: “Name of the sheet” * **Range

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: " %) ((( 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. [[image:image-20220505134614-1.jpeg]] (* for mandatory

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: in Excel. This only can be used in Excel Application Scope Activity. (% class="wikigeneratedid" id="H" %) [[image:image-20220505133607-1.jpeg]] (* is mandatory) == **Properties** == **Input** * **Sheet name (String)* **- The name of the sheet that contains the cell you want to border. E.g: “Employee

Located in

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

Rendered document content: RCA.Activities.Excel.ExcelSelectRange Description The activity allows you to select and execute a specified range from an Excel spreadsheet, in order to perform further actions. (* for mandatory) Properties Input Sheet name (String) - The name of the sheet from which to select the specified range
Title: Excel Select Range
Location: Excel Activities
…
Excel Select Range
Raw document content: an Excel spreadsheet, in order to perform further actions. [[image:image-20220505133120-1.jpeg]] (* for mandatory) == **Properties** == **Input** * **Sheet name (String) **- The name of the sheet from

Located in

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

Rendered document content: or graphs from a specified Excel file as images. (* for mandatory) Properties Input Image Format
…
(String)* - Directory to save file. E.g: “C:\DestinationSaveFolderName\” Sheet Name (String) - The name of the sheet that contains the chart you want to export. E.g: “SheetHasChartName” Misc Public (Checkbox
Location: Excel Activities
Raw document content: Excel file as images. (% class="wikigeneratedid" id="H" %) [[image:image-20220505134428-1.jpeg
…
)* **- Directory to save file. E.g: “C:\DestinationSaveFolderName\” * **Sheet Name (String)** - The name of the sheet that contains the chart you want to export. E.g: “SheetHasChartName” **Misc** * **Public