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
- 141Activities
- 30akaBot Center
- 6akaBot Insights
- 6akaBot Vision
- 5akaBot Agent
- … 10 more
Last author
- 76admin
- 32Nhan Nguyen
- 30VuNH54
- 21Giang Tran
- 17Nga Nguyen
- … 4 more
Last modification date
Creation date
Object type
File type
Uploaded by
- 56admin
- 45Nhan Nguyen
- 42Giang Tran
- 24Nga Nguyen
- 9Tuan Nguyen
- … 3 more
Upload date
Build Data Table
Located in
- Rendered document content
Table with different settings. In the body of activity Data Table - Click to add/ remove columns, update column name/ column type Properties Misc Public (Checkbox) - Check if you want to publicize it. Remember to consider data security requirements before using it. Display Name (String) - The name
- Raw document content
]] == **In the body of activity** == **Data Table **- Click to add/ remove columns, update column name/ column type
…using it. * **Display Name (String) **- The name of this activity. You can edit the name of the activity
[1] Release Notes
Located in
- Rendered document content
RCA.Activities.Office365 v1.0.0 1. Sharepoint List Activity: Activity Description Get List
…to a SharePoint List. Delete List Items Retrieve a single SharePoint list item from the specified list. Get List Info Uses the Microsoft Graph Get list API to get information about the specified SharePoint List
- Raw document content
|=Description |Get List Items|Retrieve SharePoint List Items from the specified list. |Add List Item|((( Add
…the specified list. |Get List Info|Uses the Microsoft Graph Get list API to get information about the specified SharePoint List. |For Each List|Uses the Microsoft Graph Get lists and Get list APIs to perform an activity
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