Search: excel-read-range

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

) 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

RCA.Activities.Excel.ReadColumn Description Reads the values from a column beginning

Read Column

Excel Activities

Read Column

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

" %) ((( RCA.Activities.Excel.ReadColumn == **Description** == Reads the values from a column beginning with the cell specified

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

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

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

RCA.Activities.Excel.ReadRow Description Reads the values from a row beginning with the cell

Read Row

Excel Activities

Read Row

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

" %) ((( RCA.Activities.Excel.ReadRow == **Description** == Reads the values from a row beginning with the cell specified

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

) In the body of activity Workbook Path - The path of the Excel file you want to write to. E.g: “C:\FolderName\ClientList.xlsx” Sheet name - The name of the sheet in which the range that you want to write to is. By default

to the specified range, as a DataTable variable. Only DataTable variables are supported. Properties Input

Write Range

Excel Activities

Write Range

of the Excel file you want to write to. E.g: “C:\FolderName\ClientList.xlsx” * **Sheet name** - The name of the sheet in which the range that you want to write to is. By default, this is filled in with "Sheet1." E.g

and strings are supported. * **Data Table** - The data that you want to write to the specified range

to specified Excel Sheets. This only can be used in Excel Application Scope Activity. (* is mandatory

\sky.png” Sheet name (String) - The sheet that you want to display. E.g: “ThisIsSheetName” Range (String) - The range you want to add image to. E.g: “K1:L1” Properties Input Image path (String)* - Input the full

Excel Insert Image

Excel Activities

Excel Insert Image

" %) ((( RCA.Activities.Excel.ExcelInsertImage == **Description** == This activity allows you to add images to specified Excel Sheets. This only can be used in Excel Application Scope Activity. (% class="wikigeneratedid" id="H

) **- The sheet that you want to display. E.g: “ThisIsSheetName” * **Range (String) **- The range you want to add

. E.g: “append excel range”

stored in a DataTable variable to the end of a specified Excel spreadsheet. If the sheet does not exist

of activity Workbook Path - The full path of the Excel spreadsheet that you want to use. If the Excel file

Append Range

Excel Activities

Append Range

. E.g: “append excel range” ))) {{velocity}} #if ($xcontext.action != 'export') (% class="akb-toc

variable to the end of a specified Excel spreadsheet. If the sheet does not exist, a new one is created

) == **In the body of activity** == * **Workbook Path ** - The full path of the Excel spreadsheet that you want

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

variables and strings are supported. Workbook Path (String)* - The path of the Excel file you want to read

are disabled in the specified Excel file. No macros can be run. ・ReadFromExcelSettings - Reads the current

Excel Application Scope

Excel Activities

Excel Application Scope

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

(String)*** - The path of the Excel file you want to read. E.g: “C:\FolderName\Contacts.xlsx” * **Password

macros are disabled in the specified Excel file. No macros can be run. ・ReadFromExcelSettings - Reads

 - The Excel cell or range that you want to write to. If the range isn't specified, the whole spreadsheet is read. If the range is specified as a cell, the whole spreadsheet starting from that cell is read. Only

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

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 whole spreadsheet is read. If the range is specified as a cell, the whole spreadsheet starting from

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

RCA.Activities.Excel.ExcelCopyPasteRange Description This activity allows to copy a range

, this is filled in with "Sheet1." Only String variables and strings are supported. E.g: “Sheet name” Source Range (String)* - The range of the data you want to copy. This field supports only strings and String variables

Excel Copy Paste Range

Excel Copy Paste Range

Excel Activities

" %) ((( RCA.Activities.Excel.ExcelCopyPasteRange == **Description** == This activity allows to copy a range or sheet (including values, formulas

: “Sheet name” * **Source Range (String)*** - The range of the data you want to copy. This field supports only strings and String variables. E.g: “Source range” **Misc** * **Public (Checkbox) **- Check

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