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
Last author
- 45admin
- 16Nhan Nguyen
- 16VuNH54
- 14Nga Nguyen
- 11Tuan Nguyen
- … 4 more
Creator
- 90admin
- 13Giang Tran
- 4Nga Nguyen
- 4Tuan Nguyen
- 3VuNH54
- … 2 more
Last modification date
Creation date
Object type
Uploaded by
- 53admin
- 25Nhan Nguyen
- 24Nga Nguyen
- 13Giang Tran
- 6Tuan Nguyen
- … 3 more
Upload date
Get Excel Column Name
Located in
- Rendered document content
. 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
- Title
Get Excel Column Name
- Location
Get Excel Column Name
…Excel Activities
- Raw document content
] 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
Excel Read Column
Located in
- Rendered document content
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
- Title
Excel Read Column
- Location
Excel Read Column
…Excel Activities
- Raw document content
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
Excel Insert Or Delete Columns
Located in
- Rendered document content
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
- Title
Excel Insert Or Delete Columns
- Location
Excel Activities
…Excel Insert Or Delete Columns
- Raw document content
)** - 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
Excel Insert Columns Table
Located in
- Rendered document content
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
- Title
Excel Insert Columns Table
- Location
Excel Activities
…Excel Insert Columns Table
- Raw document content
)** - 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
Read Column
Located in
- Rendered document content
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
- Title
Read Column
- Location
Excel Activities
…Read Column
- Raw document content
" %) ((( 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
[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
[2] Role Management
Located in
- Rendered document content
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
- Raw document content
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
[4] Business dataset
Located in
- Rendered document content
, 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
- Raw document content
. 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
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
[3] How to use Desktop Trigger
Located in
- Rendered document content
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
- Raw document content
" %) |=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