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
- 46admin
- 19Nhan Nguyen
- 19VuNH54
- 13Tuan Nguyen
- 10Nga Nguyen
- … 4 more
Creator
- 90admin
- 15Giang Tran
- 6Tuan Nguyen
- 3Nga Nguyen
- 2Nhan Nguyen
Last modification date
Creation date
Object type
File type
Uploaded by
- 55admin
- 28Nhan Nguyen
- 20Nga Nguyen
- 15Giang Tran
- 8Tuan Nguyen
- … 3 more
Upload date
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
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
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
[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
Excel Application Scope
Located in
- Rendered document content
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
- Title
Excel Application Scope
- Location
Excel Activities
…Excel Application Scope
- Raw document content
" %) ((( 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
Append Range
Located in
- Rendered document content
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
- Location
Excel Activities
- Raw document content
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
Excel Insert Image
Located in
- Rendered document content
to specified Excel Sheets. This only can be used in Excel Application Scope Activity. (* is mandatory
…\sky.png” Sheet name (String) - The sheet that you want to display. E.g: “ThisIsSheetName” Range (String
…strings and String variables. E.g: “C:\FolderName\sky.png” Sheet name (String)* - The sheet that you want
- Title
Excel Insert Image
- Location
Excel Activities
…Excel Insert Image
- Raw document content
" %) ((( RCA.Activities.Excel.ExcelInsertImage == **Description** == This activity allows you to add images to specified Excel Sheets. This only can be used in Excel Application Scope Activity. (% class="wikigeneratedid" id="H
…. This field accepts only strings and String variables. E.g: “C:\FolderName\sky.png” * **Sheet name (String
Excel Write Cell
Located in
- Rendered document content
into a specified spreadsheet cell or a range. If the sheet does not exist, a new one is created with the name specified in the Sheet Name property. If a value exists, it is overwritten. Changes are immediately saved. Can only be used in the Excel Application Scope activities. (* is mandatory) In the body
- Title
Excel Write Cell
- Location
Excel Activities
…Excel Write Cell
- Raw document content
of this activity. You can edit the name of the activity to organize and structure your code better. **E.g**: Excel
…spreadsheet cell or a range. If the sheet does not exist, a new one is created with the name specified in the Sheet Name property. If a value exists, it is overwritten. Changes are immediately saved. Can only
[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