Search: excel-get-column-name

or columns according to the logical conditions that are specified in the wizard. The body of the activity

. (* is mandatory) In the body of activity Filter Wizard - Set filter for rows, set output columns Properties

to consider data security requirements before using it. Display Name (String) - The name of this activity. You

conditions in the Filter Wizard window. The activity can keep or delete rows or columns according

of activity** == **Filter Wizard **- Set filter for rows, set output columns [[image:image-20230419143358-1

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

can edit the name of the activity to organize and structure your code better. E.g: Excel Read Row

of an Excel row beginning from the cell specified in the StartingCell field: and stores it in an lEnumerable<object> variable. (* is mandatory) In the body of activity Sheet name - The sheet you want to read

Excel Read Row

Excel Activities

Excel Read Row

. You can edit the name of the activity to organize and structure your code better. E.g: Excel Read Row

the values of an Excel row beginning from the cell specified in the StartingCell field: and stores

of activity** == * **Sheet name** - The sheet you want to read. E.g: "Sheet1" * **Starting Cell** - The cell

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

of an Excel range and store it in a DataTable variable. If the range is not specified, the whole spreadsheet

only be used in the Excel Application Scope activity. (* is 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

Excel Read Range

Excel Activities

Excel Read Range

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

as a cell, the whole spreadsheet starting from that cell is read. Can only be used in the Excel Application

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

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

for you to fill in the information Column/ Label Description Name Enter the custom name of the OU you

are in the table below. Column         Description Name Enter the name of the agent group you want to create

of an OU, you can click the eye button Then you will see the detail page Column/ Label Description

[[image:image-20230425154231-5.png]] |Column/ Label|Description |Name|Enter the custom name of the OU you want

.png]] Then you will see the detail page [[image:image-20230425154231-3.png]] |Column/ Label|Description |Name|The name of the OU |User    |The list of all the Users assigned in this OU. This list

) 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

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

. (* for mandatory) In the body of activity Workbook Path - The path of the Excel file you want to use. E.g: “C:\FolderName\ClientList.xlsx” Sheet name - The sheet you want to write the data to. E.g: “ClientNames” Cell

Excel Activities

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

: “A20” == **Properties** == **Input** * **Workbook Path (String)*** - The path of the Excel file you want to use. E.g: “C:\FolderName\ClientList.xlsx” * **Sheet name (String)*** - The sheet you want

for you to fill in the information Column/ Label Description Name Enter the custom name of the OU you

in. Details are in the table below. Column         Description Name Enter the name of the agent group you

of an OU, you can click the eye button Then you will see the detail page Column/ Label Description

[[image:image-20230308181201-5.png]] |Column/ Label|Description |Name|Enter the custom name of the OU you want

. [[image:image-20230308181334-26.png]] |**Column         **|**Description** |**Name**|Enter the name

-20230308181201-2.png]] Then you will see the detail page [[image:image-20230308181201-3.png]] |Column/ Label

to be added to the DataTable. The type of each object should map to the type of its corresponding column

a column. This field supports only DataTable objects. Misc Public (Checkbox) - Check if you want to publicize it. Remember to consider data security requirements before using it. Display Name (String

should map to the type of its corresponding column in the DataTable. * **Data row (DataRow

is ignored. * **Data Table (DataTable)*** - The DataTable object in which you want to add a column

to publicize it. Remember to consider data security requirements before using it. * **Display Name (String