Search: excel-get-column-name

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

from the column collection of the DataTable. Eg: 12. Column Name (String)* - The name of the column

Column to a specified DataTable. (* is mandatory) Properties Input Column (DataColumn)* - A DataColumn object to be removed from the column collection of the DataTable. If this property is set

Remove Data Column

remove data column.jpg

Remove Data Column

of the DataTable. Eg: 12. * **Column Name (String)*** - The name of the column to be removed from the column

edit the name of the activity to organize and structure your code better. Eg: “Remove Data Column

" %) ((( RCA.Activities.Core.RemoveDataColumn == **Description** == This activity allows you to remove a Data Column to a specified

only Int32 variables. Eg: 1 Column Name (String) - The name of the column you want to search for. This field supports only strings and String variables. Eg: “Name of column” Data Column (DataColumn

: 1 Column Name (String) - Specifying a Column name here returns the value of the cell found

supports only Int32 variables. Eg: 1 * **Column Name (String)** - The name of the column you want to search for. This field supports only strings and String variables. Eg: “Name of column” * **Data Column

and the value from the RowIndex property. This field supports only Int32 variables. Eg: 1 * **Column Name

to a specified DataTable. (* is mandatory) Properties Input Column (DataColumn)* - A DataColumn object that is to be appended to the column collection of the DataTable. Column Name (String)* - The name of the new column you

)* - The DataTable object in which you want to add a column. This field supports only DataTable objects. Misc

Add Data Column

add data column.jpg

Add Data Column

** == **Input** * **Column (DataColumn)*** - A DataColumn object that is to be appended to the column collection of the DataTable. * **Column Name (String)*** - The name of the new column you want to add

in which you want to add a column. This field supports only DataTable objects. **Misc** * **Public

to the workbook. This only can be used in Excel Application Scope Activity. (* for mandatory) Properties

requirement before using it. Display Name (String) - The name of this activity. You can edit the name of the activity to organize and structure your code better. E.g: Excel Save Workbook

Excel Save Workbook

Excel Activities

Excel Save Workbook

it. Remember to consider data security requirement before using it. * **Display Name (String) **- The name of this activity. You can edit the name of the activity to organize and structure your code better. E.g: Excel

can be used in Excel Application Scope Activity. [[image:image-20220505134823-1.jpeg

) - The index of the column you want to sort. Eg: 3 Column Name (String) - Name of the sorting column. Eg: “Column name here”. Data Column (DataColumn) - The variable containing the column you want to sort

in ascending or descending order, based on the values of a specified column. (* is mandatory) Properties

) **- The index of the column you want to sort. Eg: 3 * **Column Name (String)** - Name of the sorting column. Eg: “Column name here”. * **Data Column (DataColumn)** - The variable containing the column you want to sort

order, based on the values of a specified column. [[[[image:sort data table.jpg||class="img-thumbnail