Search: excel-get-column-name

for a sheet based on its index and returns its name as a String variable. This only can be used in Excel

to public it. Remember to consider data security requirement before using it. Display Name (String) - The name of this activity. You can edit the name of the activity to organize and structure your code better

Excel Get Workbook Sheets

Excel Get Workbook Sheets

Excel Activities

and returns its name as a String variable. This only can be used in Excel Application Scope Activity

it. * **Display Name (String)** - The name of this activity. You can edit the name of the activity to organize and structure your code better. E.g: Get Workbook Sheets ))) (% class="akb-toc" %) ((( (% class="akb-toc-title

for a sheet based on its index and returns its name as a String variable. be used in Excel Application Scope

code better. E.g: Get Workbook Sheet Output Sheet (String) - List of string that contains sheet names

if you want to public it. Remember to consider data security requirement before using it. Display Name

Excel Get Workbook Sheet

Excel Get Workbook Sheet

Excel Activities

and returns its name as a String variable. be used in Excel Application Scope Activity. [[image:image

data security requirement before using it. * **Display Name (String) **- The name of this activity. You can edit the name of the activity to organize and structure your code better. E.g: Get Workbook

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

RCA.Activities.Excel.ReadRange Description This activity allows you to read the Excel range

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

Excel Activities

" %) ((( RCA.Activities.Excel.ReadRange == **Description** == This activity allows you to read the Excel range and store

) == **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

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

want to public it. Remember to consider data security requirement before using it. Display Name (String

Excel Delete Range

Excel Activities

Excel Delete 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 and ShiftOption property

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

to the workbook. This only can be used in Excel Application Scope Activity. (* for mandatory) Properties

requirement before using it. Display Name (String) - The name of this activity. You can edit the name of the activity to organize and structure your code better. E.g: Excel Save Workbook

Excel Save Workbook

Excel Activities

Excel Save Workbook

it. Remember to consider data security requirement before using it. * **Display Name (String) **- The name of this activity. You can edit the name of the activity to organize and structure your code better. E.g: Excel

can be used in Excel Application Scope Activity. [[image:image-20220505134823-1.jpeg

Workbook. This only can be used in Excel Application Scope Activity. (* for mandatory) Properties

requirement before using it. Display Name (String) - The name of this activity. You can edit the name

(WorkbookApplication)* - The workbook that you want to close. It can be an output from Excel Application Scope or any

Excel Close Workbook

Excel Activities

Excel Close Workbook

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

data security requirement before using it. * **Display Name (String) **- The name of this activity. You can edit the name of the activity to organize and structure your code better. E.g: Close Workbook

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

in Excel Application Scope Activity. (* for mandatory) In the body of the activity Sheet name (String)* - The name of the sheet that you want to insert row. E.g: “Employee Name” Number of row (Int) - 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

of the activity** == * **Sheet name (String)*** - The name of the sheet that you want to insert row. E.g: “Employee Name” * **Number of row (Int) **- Number of rows you want to insert in Excel sheet E.g: 5

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

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

using it. Display Name (String) - The name of this activity. You can edit the name of the activity

Excel Set Border

Excel Activities

Excel Set Border

in Excel. This only can be used in Excel Application Scope Activity. (% class="wikigeneratedid" id="H

name (String)* **- The name of the sheet that contains the cell you want to border. E.g: “Employee

before using it. * **Display Name (String) **- The name of this activity. You can edit the name

) 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