検索：excel-get-column-name

. E.g: [482156710] Get Excel Column Name Output Result (String) - Stores column name in a string

RCA.Activities.Excel.GetExcelColumnName Description Based on the column's index, you can look for it and returns the name to String variable. (* for mandatory) Properties Input Column Index: (Int32

Get Excel Column Name

Get Excel Column Name

Excel Activities

] Get Excel Column Name **Output** * **Result (String) **- Stores column name in a string variable.

RCA.Activities.Excel.GetExcelColumnName == **Description** == Based on the column's index, you can look for it and returns the name to String variable. [[image:image-20230420113044-1.png

the name of the activity to organize and structure your code better. E.g: [482156710] Excel Read Column

RCA.Activities.Excel.ExcelReadColumn Description Read all data into column has determined (* for mandatory) In the body of activity Sheet name - The sheet you want to read. E.g: "Sheet1" Starting Cell

Excel Read Column

Excel Read Column

Excel Activities

your code better. E.g: [482156710] Excel Read Column **Options** * **Preserve Format (Boolean

RCA.Activities.Excel.ExcelReadColumn == **Description** == Read all data into column has

** == * **Sheet name** - The sheet you want to read. E.g: "Sheet1" * **Starting Cell** - The cell from which

columns to the document. ・Delete: Remove columns from the document. Sheet name (String)* - The name

to organize and structure your code better. E.g: [038325762] Excel Insert Or Delete Columns Options

of columns at a certain position. (* for mandatory) In the body of activity Number of columns (Int32

Excel Insert Or Delete Columns

Excel Activities

Excel Insert Or Delete Columns

)** - The column where the insertion or removal begins. E.g: 2 * **Sheet name (String)*** - The name of the sheet

**: Remove columns from the document. * **Sheet name (String)*** - The name of the sheet in the workbook

and structure your code better. E.g: [038325762] Excel Insert Or Delete Columns **Options** * **CopyOrigin

the name of the activity to organize and structure your code better. E.g: [028225900] Excel Insert Columns

want to insert. E.g: "Table1" Column name (String) - Name of column you want to insert. E.g: "Column1" Properties Input Column name (String) - Name of column you want to insert. E.g: "Column1" Position (Int32

Excel Insert Columns Table

Excel Activities

Excel Insert Columns Table

)** - Table name you want to insert. E.g: "Table1" * **Column name (String)** - Name of column you want to insert. E.g: "Column1" == **Properties** == **Input** * **Column name (String)** - Name of column you

to organize and structure your code better. E.g: [028225900] Excel Insert Columns Table ))) {{velocity

RCA.Activities.Excel.ReadColumn Description Reads the values from a column beginning

) 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

Read Column

Excel Activities

Read Column

" %) ((( RCA.Activities.Excel.ReadColumn == **Description** == Reads the values from a column beginning with the cell specified

]] (* 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 you want

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

are assigned to roles. In other words, Users were not given permission to certain resources but will get

’ information. After selecting the Role Management tab, the system displays the following page: No Column

of the Roles. Delete: allows users to delete selected role 2 Name The title of the role Default Roles

but will get the permit through a role. Depending on their roles, users have access to the resources listed

, the system displays the following page: [[image:image-20221101164359-16.png]] |=No|=Column|=Description

of the Roles. Delete: allows users to delete selected role |2|Name|The title of the role * Default Roles

, enter a name and default value for your custom column. NOTE: Make sure to choose a column name

you would like to rename. In the newly open window, enter a new column name and click Edit. Deleting

decimals. 4. Click Enter to save the workflow value. Adding Custom Columns to the Business

. In the dialogue that pops up, enter a name and default value for your custom column. (% class="box infomessage" %) ((( **NOTE**: Make sure to choose a column name with a maximum length of 50 characters. Duplicate names

. In the newly open window, enter a new column name and click **Edit**. == **Deleting Custom Columns

the information in the tab: Basic No Column/Label Description Type Maximum Is Mandatory? 1 Trigger Name Fill

No Column/Label Description Type Maximum Is Mandatory? 1 Trigger Name Fill the trigger name String 255 Yes 2

: Basic No Column/Label Description Type Maximum Is Mandatory? 1 Trigger Name Fill the trigger name

" %) |=No|=Column/Label|=Description|=Type|=Maximum|=(% style="width: 56px;" %)Is Mandatory? |1|Trigger Name|Fill

of created triggers by status, name, type, description == **Create a new trigger** == === 1. Create a File

.png||height="358" width="342"]] (% style="width:1043px" %) |=No|=Column/Label|=Description|=Type

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

]] == **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