Search: excel-select-range

(String)* - The name of the sheet from which to select the specified range. By default, this is filled

RCA.Activities.Excel.ExcelSelectSheet Description The activity allows you to select and execute

. E.g: Select Sheet

Excel Select Sheet

Excel Select Sheet

Excel Activities

" %) ((( RCA.Activities.Excel.ExcelSelectSheet == **Description** == The activity allows you to select and execute a specified sheet

) == **Properties** == **Input** * **Sheet name (String)* **- The name of the sheet from which to select the specified range. By default, this is filled in with "Sheet1." Only String variables and strings

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

. E.g: “Employee Infomation” Range (String)* - The Range that you want to border. E.g: “A1:K10” Misc

Excel Set Border

Excel Activities

Excel Set Border

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

Infomation” * **Range (String)*** - The Range that you want to border. E.g: “A1:K10” **Misc

of a specified cell or cell range using a Color variable. Can only be used within the Excel Application Scope

that contains the cell you want to color. E.g: “Name of the sheet” Range (String)* - The range of data

. E.g: Set Range Color

Excel Set Range Color

Excel Set Range Color

Excel Activities

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

)* **- The name of the sheet that contains the cell you want to color. E.g: “Name of the sheet” * **Range

 - The Excel cell or range that you want to write to. If the range isn't specified, the whole spreadsheet

: “Hello world” or “=B1+C2” Properties Input Cell (String)* - The Excel cell or range that you want

into a specified spreadsheet cell or a range. If the sheet does not exist, a new one is created with the name

Excel Write Cell

Excel Activities

Excel Write Cell

: “ClientName” * **Cell** - The Excel cell or range that you want to write to. If the range isn't specified

)*** - The Excel cell or range that you want to write to. If the range isn't specified, the whole spreadsheet

spreadsheet cell or a range. If the sheet does not exist, a new one is created with the name specified

range are overwritten. Changes are immediately saved. Can only be used in the Excel Application Scope

of the activity to organize and structure your code better. E.g: Write Range Excel Options Add Headers (Checkbox) - When selected, column headers are also written to the specified range. By default, this check box

Excel Write Range

Excel Write Range

Excel Activities

Range Excel **Options** * **Add Headers (Checkbox) **- When selected, column headers are also written to the specified range. By default, this check box is not selected. ))) {{velocity}} #if ($xcontext.action

with the value specified in the Sheetname property. All cells within the specified range are overwritten. Changes

the lowest version of the Exchange server that is used. The options displayed in this field range from 2007

. This means that if you have a 2016 exchange server, you can select the Exchange2013 option. Server (String

the lowest version of the Exchange server that is used. The options displayed in this field range from 2007

. This means that if you have a 2016 exchange server, you can select the Exchange2013 option. * **Server

RCA.Activities.Excel.ExcelExportChart Description This activity allows you to export charts or graphs from a specified Excel file as images. (* for mandatory) Properties Input Image Format (DropDownList)* - Select the file type that you want to save the exported chart/graph as. It contains 3 types

Excel Activities

Excel file as images. (% class="wikigeneratedid" id="H" %) [[image:image-20220505134428-1.jpeg]] (* for mandatory) == **Properties** == **Input** * **Image Format (DropDownList)* **- Select the file

) – Specifies the lowest version of the Exchange server that is used. The options displayed in this field range

of service you support. This means that if you have a 2016 exchange server, you can select the Exchange2013

) - Specifies whether to retrieve only unread messages. By default, this check box is selected. Order By Date

. The options displayed in this field range from 2007 to the 2013 version. Please note that the version number

can select the Exchange2013 option. * **Server (String)*** - The email server host that is to be used

. By default, this check box is selected. * **Order By Date (OrderByDate)** - Order mail messages by date

that is used. The options displayed in this field range from 2007 to the 2013 version. Please note

exchange server, you can select the Exchange2013 option. Server (String)* - The email server host

the lowest version of the Exchange server that is used. The options displayed in this field range from 2007

. This means that if you have a 2016 exchange server, you can select the Exchange2013 option. * **Server

) In the body of activity Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C

, this is filled in with "A1". E.g: "A1" Workbook Path (String)* - The path of the Excel file you want to read. E.g

] Read Column Options Preserve Format (Boolean) - Selecting this check box keeps the formatting

Excel Activities

]] (* for mandatory) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel file

" * **Workbook Path (String)*** - The path of the Excel file you want to read. E.g: “C:\FolderName

] Read Column **Options** * **Preserve Format (Boolean) **- Selecting this check box keeps