Search: excel-get-column-name

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

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

for field Step 4: Click "Add Column" button to add column for table Step 5: Input column name

on the line of "Form Field" Step 2: Input the field name on "Label" field and choose data type for field

, click "Add Field" button on the line of "Form Field" Step 2: Input the table name on "Label" field

column name and data type for each column ))) [[image:image-20221028164801-15.png||cursorshover="true

the field name on "Label" field and choose data type for field on "Data Type" field ))) [[image:image

the table name on "Label" field and choose data type is "Table". ))) [[image:image-20221028164141-11.png

) 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

columns :

name : platform.panels.StudioApplication

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

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

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