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
Creator
- 140admin
- 45Giang Tran
- 7Tuan Nguyen
- 4Nga Nguyen
- 3Nhan Nguyen
- … 3 more
Last modification date
Creation date
Object type
File type
Upload date
Excel Activities
Located in
- Rendered document content
The Excel Activities offers deep integration with Microsoft Excel and ships with a number of activities that automate the tasks you perform in Excel. These activities enable the robots to: Read information from a cell, columns, rows or ranges, and write to other spreadsheets or workbooks. Execute macros
- Title
Excel Activities
- Location
Excel Activities
- Raw document content
The Excel Activities offers deep integration with Microsoft Excel and ships with a number of activities that automate the tasks you perform in Excel. These activities enable the robots to: * ((( Read information from a cell, columns, rows or ranges, and write to other spreadsheets or workbooks. ))) * Execute
Read Range
Located in
- Rendered document content
) - 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
- Location
Excel Activities
- Raw document content
" %) ((( 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
Get Row Item
Located in
- Rendered document content
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
- Title
Get Row Item
- Attachment name
get row item.jpg
- Location
Get Row Item
- Raw document content
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
Write Range
Located in
- Rendered document content
) 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
- Location
Excel Activities
- Raw document content
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
Activities
Located in
- Rendered document content
Composite Request Insert Record Update Record Delete Record Get Record Get List View Records Upset Record Create Bulk API Job Get Bulk API Job Start or Abort Bulk API Job Get Bulk API Job Result Upload File Download File Assign File Salesforce Application Scope Execute SOQL Execute Report Format Column
- Raw document content
/Salesforce/Activities/Execute%20Report/]] * [[Format Column Names>>https://docs.akabot.com/bin/view
…%20Record/]] * [[Get Record>>https://docs.akabot.com/bin/view/Activities/Salesforce/Activities/Get%20Record/]] * [[Get List View Records>>https://docs.akabot.com/bin/view/Activities/Salesforce/Activities/Get%20List
Release Notes
Located in
- Rendered document content
Record Delete Record Get Record Get List View Records Upset Record Create Bulk API Job Get Bulk API Job Start or Abort Bulk API Job Get Bulk API Job Result Upload File Download File Assign File Salesforce Application Scope Execute SOQL Execute Report Format Column Names Format Labels and Values Lightning REST API
- Raw document content
* Format Column Names * Format Labels and Values * Lightning REST API Request * Search ))) ))) {{velocity
…* Insert Record * Update Record * Delete Record * Get Record * Get List View Records * Upset Record * Create Bulk API Job * Get Bulk API Job * Start or Abort Bulk API Job * Get Bulk API Job Result * Upload
Excel Write Range
Located in
- Rendered document content
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
- Title
Excel Write Range
- Location
Excel Activities
…Excel Write Range
- Raw document content
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
Excel Delete Range
Located in
- Rendered document content
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
- Title
Excel Delete Range
- Location
Excel Activities
…Excel Delete Range
- Raw document content
" %) ((( 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
Generate Data Table
Located in
- Rendered document content
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
- Raw document content
. 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
[2] Report
Located in
- Rendered document content
by going to Report tab > Select Agent tab. No Column Description 1 Agent Name The name of the Agent
…being connected to Center. Here, you can get information such as the number of successful tasks
…that was run by the selected Agent or Workflows You can get your reports by Agent and Workflow. To access
- Raw document content
-20221101161308-7.png]] |=No|=Column|=Description |1|Agent Name|The name of the Agent which activities
…are currently being connected to Center. Here, you can get information such as the number of successful tasks
…that was run by the selected Agent or Workflows You can get your reports by **Agent** and **Workflow