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

is to be retrieved from the DataRow. Eg: 11 Column Name (String)* - The name of the column whose value

and structure your code better. Eg: Get row item Output Value - The column value from the specified DataRow.

RCA.Activities.Core.GetRowItem Description This activity allows you to get a value from

Get Row Item

get row item.jpg

Get Row Item

is to be retrieved from the DataRow. Eg: 11 * **Column Name (String)*** - The name of the column whose value

" %) ((( RCA.Activities.Core.GetRowItem == **Description** == This activity allows you to get a value from a DataRow variable according to a specified column. [[[[image:get row item.jpg]]>>attach:get row item.jpg

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

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

Excel Activities

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

Path (String)*** - The path of the Excel file you want to write to. E.g: “C:\FolderName\ClientList.xlsx” * **Sheet name (String)*** - The name of the sheet in which the range that you want to write

range are overwritten. Changes are immediately saved. Can only be used in the Excel Application Scope activities. (* is mandatory) In the body of activity Sheet Name - The sheet you want to write

are supported. Sheet Name (String)* - The sheet you want to write on. By default, this is filled in with "Sheet1

Excel Write Range

Excel Activities

Excel Write Range

Range Excel **Options** * **Add Headers (Checkbox) **- When selected, column headers are also written

are immediately saved. Can only be used in the Excel Application Scope activities. [[image:image-20220505114134-2.jpeg]] (* is mandatory) == **In the body of activity** == * **Sheet Name **- The sheet you want

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

the structured text. This activity enables you to select column and row separators according to which the table

(default) - blocks the process from continuing the execution. Fixed formatting options Column Sizes (IEnumerable< Int32 >) - Specifies the size of the columns that are to be created in the table. This field

. This activity enables you to select column and row separators according to which the table is generated

) - blocks the process from continuing the execution. **Fixed formatting options** * **Column Sizes (IEnumerable< Int32 >)** - Specifies the size of the columns that are to be created in the table. This field

RCA.Activities.Excel.ExcelApplicationScope Description This activity allows to open an Excel workbook and provides a scope for Excel Activities. (* for mandatory) In the body of the activity Workbook Path (String) - The path of the Excel file you want to read. E.g: “C:\FolderName\Contacts.xlsx

Excel Application Scope

Excel Activities

Excel Application Scope

" %) ((( RCA.Activities.Excel.ExcelApplicationScope == **Description** == This activity allows to open an Excel workbook and provides a scope for Excel Activities. [[image:image-20220505111836-1.jpeg]] (* for mandatory) == **In the body of the activity** == * **Workbook Path (String)** - The path of the Excel file you want to read. E.g: “C

them with a semicolon (“;”). Use Asterisk to get all files. The default value is: All files E.g: Image files (.bmp, .jpg)|.bmp;.jpg| .Excel files (.xlsx)|.xlsx Misc Public (Checkbox) - If you

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

multiple file types, separate them with a semicolon (“;”). Use Asterisk to get all files. The default value is: All files E.g: Image files (.bmp, .jpg)|.bmp;.jpg| .Excel files (.xlsx)|.xlsx **Misc

, consider data security before using it. * **Display Name (String) **- The name of this activity. You can