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
- 52admin
- 16Nhan Nguyen
- 16VuNH54
- 14Nga Nguyen
- 11Tuan Nguyen
- … 5 more
Creator
- 97admin
- 13Giang Tran
- 4Nga Nguyen
- 4Tuan Nguyen
- 3JP Comtor
- … 3 more
Last modification date
Creation date
Object type
Uploaded by
- 57admin
- 25Nhan Nguyen
- 24Nga Nguyen
- 16Giang Tran
- 9VuNH54
- … 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
Excel列を挿入 (ja)
Located in
- Rendered document content
RCA.Activities.Excel.ExcelInsertColumnsTable 説明 指定された列をテーブル内の特定の位置に追加します。 *は必須。 アクティビティの内容
…:"Column1" プロパティ 入力 列名(文字列):挿入する列の名前。 例:"Column1" 位置(整数):追加する位置。 シート名(文字列)*:変更する必要があるワークブック内のシートの名前。 例
…してください。 表示名(文字列):アクティビティ名。アクティビティ名を編集して、コードをより適切に整理および構造化で名称きます。 例:[028225900]Excel列を挿入
- Title
Excel列を挿入
- Raw document content
(% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activities.Excel
…" * **列名(文字列)**:挿入する列の名前。 例:"Column1" == **プロパティ** == **入力** * **列名(文字列)**:挿入する列の名前。 例:"Column1" * **位置
…)**:アクティビティ名。アクティビティ名を編集して、コードをより適切に整理および構造化で名称きます。 例:[028225900]Excel列を挿入 ))) {{velocity}} #if ($xcontext
- Location
Excel Activities
…Excel Insert Columns Table
[4] APIレソース (ja)
Located in
- Rendered document content
.akabot.io/api/roles/{name}のURLにGETリクエストを送信します。 ヘッダー: レスポンス: 2.GetUsers ユーザーコレクションを取得します。サポート
…|desc)形式でのソート基準 例:name,asc レスポンス ReturnType:Collection(Environment) 例) Make a GET request to the
…: レスポンス: True 27.GetQueue キューコレクションを取得します。サポートされているメソッド:Get パラメータ 名称 形式 必須 説明 name Long False キューID
- Raw document content
されているメソッド:Get パラメータ |名称|形式|必須|説明 |name|文字列|true|ロール名 レスポンス ReturnType:Collection(Resource) 例) http:~/~/botcenter.akabot.io/api/roles/{name}のURLにGETリクエストを送信します。 [[image:image-20230307144502-1.png]] ヘッダー
…:#000000" %)** 2.GetUsers**(%%) == ユーザーコレクションを取得します。サポートされているメソッド:Get パラメータ |名称|形式|必須|説明
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
[1.2] APIリファレンス (ja)
Located in
- Rendered document content
-Type: application/json メソッド:GET リクエストヘッダー:Authorization: Bearer {apiKey} 入力パラメータ: 属性 形式 説明 必須 id
…={documentName}&dateFrom={dateFrom}&dateTo={dateTo}&sort=createdDate,desc Content-Type: application/json メソッド:GET
…します。 URL: {serverEndpoint}/api/documents/{id} Content-Type: application/json メソッド:GET リクエストヘッダー
- Raw document content
/{id}?exportType={exportType} * Content-Type: application/json * メソッド:GET * リクエストヘッダー:Authorization
…={dateFrom}&dateTo={dateTo}&sort=createdDate,desc * Content-Type: application/json * メソッド:GET * リクエストヘッダー
…/%7bid]]} * Content-Type: application/json * メソッド:GET * リクエストヘッダー:Authorization: Bearer {apiKey
[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