Search: excel-copy-sheet

in an Excel workbook. Can also be used to shift an entire row or column by using the ShiftCells and ShiftOption property fields. (* for mandatory) Properties Input Sheet Name (String) - The name of the sheet contains the data you want to delete. By default, this is filled in with "Sheet1." Only String

Excel Delete Range

Excel Activities

Excel Delete Range

(% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activities.Excel.ExcelDeleteRange == **Description** == This activity allows deleting a specified range in an Excel workbook

** == **Input** * **Sheet Name (String)** - The name of the sheet contains the data you want to delete

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

Excel Activities

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

or removal begins. By default, this is filled in with 1. E.g: 2 Sheet name (String)* - The name of the sheet

the document. Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g

edit the name of the activity to organize and structure your code better. E.g: [038325762] Excel Insert

Excel Insert Or Delete Rows

Excel Activities

Excel Insert Or Delete Rows

)** - The row where the insertion or removal begins. By default, this is filled in with 1. E.g: 2 * **Sheet name (String)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1

the document. * **Sheet name (String)*** - The name of the sheet in the workbook where the change must be made

) In the body of activity Sheet name (String)* - The name of the sheet in the workbook where you want to search

(String)* - The range where you want to perform the search. E.g: "A1:H5" Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Value (String) - The value that you

Excel LookUp Range

Excel Activities

Excel LookUp Range

]] (* for mandatory) == **In the body of activity** == * **Sheet name (String)*** - The name of the sheet

where you want to perform the search. E.g: "A1:H5" * **Sheet name (String)*** - The name of the sheet

. E.g: [759682936] Excel Lookup Range **Option** * **Look in (Dropdown List) **- Select type

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

Excel Select Range

Excel Activities

Excel Select Range

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

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

Excel Set Border

Excel Activities

Excel Set Border

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

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

Excel Set Range Color

Excel Activities

Excel Set Range Color

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

that are duplicated in a specified range. (*for mandatory) In the body of activity Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Range (String

) - The range from which you want to remove duplicate rows. E.g: "A1:H5" Sheet name (String)* - The name

Excel Remove Duplicates Range

Excel Activities

Excel Remove Duplicates Range

. [[image:image-20220505141832-1.png]] (*for mandatory) == **In the body of activity** == * **Sheet name (String)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1

. E.g: "A1:H5" * **Sheet name (String)*** - The name of the sheet in the workbook where the change must

) In the body of activity Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C:\FolderName\SaleReport.xlsx” Sheet name (String)* - The sheet you want to read. E.g: "Sheet1" Starting Cell

". E.g: "A1" Properties Input Sheet name (String)* - The sheet you want to read. E.g: "Sheet1

Excel Activities

]] (*for mandatory) == **In the body of activity** == * **Workbook Path (String)*** - The path of the Excel file you want to read. E.g: “C:\FolderName\SaleReport.xlsx” * **Sheet name (String)*** - The sheet

** == **Input** * **Sheet name (String)*** - The sheet you want to read. E.g: "Sheet1" * **Starting Cell

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

Excel Read Cell

Excel Activities

Excel Read Cell

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