Search: excel-get-column-name

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

* 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

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

Excel Write Range

Excel Activities

Excel Write Range

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

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

Excel Delete Range

Excel Activities

Excel Delete Range

" %) ((( 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

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

. 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

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

-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

Add Data Column Add Data Row Build Data Table Clear Data Table Filter Data Table For Each Row Generate Data Table Get Row Item Join Data Tables Look Up Data Table Merge Data Table Output Data Table Remove Data Column Remove Data Row Remove Duplicated Rows Sort Data Table

* [[Add Data Column>>url:https://docs.akabot.com/bin/view/Activities/Data%20Table/Activities/Add

://docs.akabot.com/bin/view/Activities/Data%20Table/Activities/Generate%20Data%20Table/]] * [[Get Row Item>>url:https://docs.akabot.com/bin/view/Activities/Data%20Table/Activities/Get%20Row%20Item/]] * [[Join Data Tables>>url:https

RCA.Activities.Excel.ExcelApplicationScope Description This activity allows to open an Excel workbook and provides a scope for Excel Activities. (* for mandatory) In the body of the activity Workbook Path (String) - The path of the Excel file you want to read. E.g: “C:\FolderName\Contacts.xlsx

Excel Application Scope

Excel Activities

Excel Application Scope

" %) ((( RCA.Activities.Excel.ExcelApplicationScope == **Description** == This activity allows to open an Excel workbook and provides a scope for Excel Activities. [[image:image-20220505111836-1.jpeg]] (* for mandatory) == **In the body of the activity** == * **Workbook Path (String)** - The path of the Excel file you want to read. E.g: “C

them with a semicolon (“;”). Use Asterisk to get all files. The default value is: All files E.g: Image files (.bmp, .jpg)|.bmp;.jpg| .Excel files (.xlsx)|.xlsx Misc Public (Checkbox) - If you

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

multiple file types, separate them with a semicolon (“;”). Use Asterisk to get all files. The default value is: All files E.g: Image files (.bmp, .jpg)|.bmp;.jpg| .Excel files (.xlsx)|.xlsx **Misc

, consider data security before using it. * **Display Name (String) **- The name of this activity. You can

stored in a DataTable variable to the end of a specified Excel spreadsheet. If the sheet does not exist, a new one is created with the name indicated in the Sheetname field. (* for mandatory) In the body of activity Workbook Path - The full path of the Excel spreadsheet that you want to use. If the Excel file

Excel Activities

variable to the end of a specified Excel spreadsheet. If the sheet does not exist, a new one is created with the name indicated in the Sheetname field. [[image:image-20220505140101-1.jpeg]] (* for mandatory) == **In the body of activity** == * **Workbook Path ** - The full path of the Excel spreadsheet that you want

: The column name must be valid in the Salesforce object you want to insert. Misc DisplayName - The display name of the activity. Public - If selected, the values of variables and arguments will be logged

Get Record RCA.Activities.Salesforce.GetRecord You may use this activity to retrieve a record

Get Record

Get Record

specified in this field. **Note**: The column name must be valid in the Salesforce object you want to insert. **Misc** * **DisplayName** - The display name of the activity. * **Public** - If selected

**Get Record** RCA.Activities.Salesforce.GetRecord You may use this activity to retrieve a record