Search: excel-write-range

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

) - Number of rows you want to insert in Excel sheet E.g: 5 Row position (Int) - Position where the rows

Excel Insert Rows

Excel Activities

Excel Insert Rows

in a table, range, or sheet at the specified location. This only can be used in Excel Application Scope

: “Employee Name” * **Number of row (Int) **- Number of rows you want to insert in Excel sheet E.g: 5

as a new file. This only can be used in Excel Application Scope Activity. (* for mandatory) In the body

file that you want to write over it. This field accepts only strings and String variables. E.g: “C

or click “…” button to choose an existed file that you want to write over it. This field accepts only

Excel Save As Workbook

Excel Activities

Excel Save As Workbook

be used in Excel Application Scope Activity. [[image:image-20220505135028-1.jpeg]] (* for mandatory

to choose an existed file that you want to write over it. This field accepts only strings and String

)*** - Input the full path of the file or click “…” button to choose an existed file that you want to write

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

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

RCA.Activities.Excel.ReadRange Description This activity allows you to read the Excel range and store in a DataTable variable. If the range isn’t specified, the whole spreadsheet starting from

(DataTable) - Stores the data extracted from the specified Excel range in a data table variable. Only data

Read Range

Excel Activities

Read Range

" %) ((( RCA.Activities.Excel.ReadRange == **Description** == This activity allows you to read the Excel range and store in a DataTable variable. If the range isn’t specified, the whole spreadsheet starting from that cell is read

) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel file you want to read

RCA.Activities.Excel.WriteCell Description This activity allows you to write a value or formula into a specified spreadsheet cell or a range. If the sheet does not exist, a new one is created. (* for mandatory) In the body of activity Workbook Path - The path of the Excel file you want to use. E.g: “C

Write Cell

Excel Activities

Write Cell

" %) ((( RCA.Activities.Excel.WriteCell == **Description** == This activity allows you to write a value or formula into a specified spreadsheet cell or a range. If the sheet does not exist, a new one is created. [[image:image-20220505135743

of the Excel file you want to use. E.g: “C:\FolderName\ClientList.xlsx” * **Sheet name** - The sheet you want

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

RCA.Activities.Excel.ExcelDeleteRange Description This activity allows deleting a specified range in an Excel workbook. Can also be used to shift an entire row or column by using the ShiftCells

variables and strings are supported. E.g: “Employee Data” Range (String)* - The range you want to delete

Excel Delete Range

Excel Delete Range

Excel Activities

" %) ((( RCA.Activities.Excel.ExcelDeleteRange == **Description** == This activity allows deleting a specified range in an Excel workbook

Data” * **Range (String)* **- The range you want to delete. This field supports only strings

Range **Options** * **ShiftCells (Checkbox) **- If you check it, cell formatting is shifted