Search: excel-get-column-name
Last modified by admin on 2022/04/24 04:58
Refine your search
Select a category and activate filters on the current results
Location
- 119Activities
- 29akaBot Center
- 5akaBot Insights
- 5akaBot Vision
- 4akaBot Agent
- … 5 more
Last author
- 46admin
- 32Nhan Nguyen
- 29VuNH54
- 21Giang Tran
- 14Nga Nguyen
- … 4 more
Creator
- 110admin
- 41Giang Tran
- 7Tuan Nguyen
- 4Nga Nguyen
- 3Nhan Nguyen
- … 2 more
Last modification date
Creation date
Object type
File type
Uploaded by
- 55admin
- 45Nhan Nguyen
- 42Giang Tran
- 24Nga Nguyen
- 9Tuan Nguyen
- … 3 more
Excel Read Cell
Located in
- Rendered document content
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
- Title
Excel Read Cell
- Location
Excel Activities
…Excel Read Cell
- Raw document content
" %) ((( 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
[2] Add New Field for Model
Located in
- Rendered document content
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
- Raw document content
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
Excel Read Row
Located in
- Rendered document content
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
- Title
Excel Read Row
- Location
Excel Activities
…Excel Read Row
- Raw document content
. 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
Excel Insert Rows
Located in
- Rendered document content
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
- Title
Excel Insert Rows
- Location
Excel Activities
…Excel Insert Rows
- Raw document content
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
Excel Read Range
Located in
- Rendered document content
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
- Title
Excel Read Range
- Location
Excel Activities
…Excel Read Range
- Raw document content
" %) ((( 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
Excel Set Border
Located in
- Rendered document content
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
- Title
Excel Set Border
- Location
Excel Activities
…Excel Set Border
- Raw document content
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
Filter Data Table
Located in
- Rendered document content
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
- Raw document content
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
Read Row
Located in
- Rendered document content
) 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
- Location
Excel Activities
- Raw document content
]] (*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
Write Cell
Located in
- Rendered document content
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
- Location
Excel Activities
- Raw document content
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 Team IT-Operation
Located in
- Rendered document content
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
- Raw document content
[[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