検索:excel-get-column-name
adminが2022/04/24 04:58に最終更新
検索を絞り込む
カテゴリーを選択して結果を絞り込む
保存場所
最終更新者
- 59admin
- 31Nhan Nguyen
- 12Nga Nguyen
- 10VuNH54
- 9Tuan Nguyen
- … あと3件
最終更新日
- 10030日以前
オブジェクトの種類
ファイルの種類
アップロードした人
- 51admin
- 42Nhan Nguyen
- 20Nga Nguyen
- 2Giang Tran
- 2Tuan Nguyen
- … あと3件
アップロード日
- 10230日以前
[1] Release Notes (en)
保存場所
- 表示されるドキュメントの内容
-package Add Delete Column: Adds blank columns or removes existing columns from a specified sheet. Add
…of a Google spreadsheet file. Get Cell Color: Extracts the background color of a cell and saves it as a Color variable Get sheets: Uses the Microsoft Graph Get worksheet API to retrieve and return an array
- ドキュメントの内容のソース
: === **1. Sheets sub-package** === (% class="box" %) ((( * Add Delete Column: Adds blank columns or removes existing columns from a specified sheet. * Add Delete Rows: Adds empty rows or removes existing
…. * Get Cell Color: Extracts the background color of a cell and saves it as a Color variable * Get sheets
Get Row Item (en)
保存場所
- 表示されるドキュメントの内容
is to be retrieved from the DataRow. Eg: 11 Column Name (String)* - The name of the column whose value
…and structure your code better. Eg: Get row item Output Value - The column value from the specified DataRow.
…RCA.Activities.Core.GetRowItem Description This activity allows you to get a value from
- タイトル
Get Row Item
- 添付ファイルの名称
get row item.jpg
- 保存場所
Get Row Item
- ドキュメントの内容のソース
is to be retrieved from the DataRow. Eg: 11 * **Column Name (String)*** - The name of the column whose value
…" %) ((( RCA.Activities.Core.GetRowItem == **Description** == This activity allows you to get a value from a DataRow variable according to a specified column. [[[[image:get row item.jpg]]>>attach:get row item.jpg
Generate Data Table (en)
保存場所
- 表示されるドキュメントの内容
the structured text. This activity enables you to select column and row separators according to which the table
…(default) - blocks the process from continuing the execution. Fixed formatting options Column Sizes (IEnumerable< Int32 >) - Specifies the size of the columns that are to be created in the table. This field
- ドキュメントの内容のソース
. This activity enables you to select column and row separators according to which the table is generated
…) - blocks the process from continuing the execution. **Fixed formatting options** * **Column Sizes (IEnumerable< Int32 >)** - Specifies the size of the columns that are to be created in the table. This field
[2] Report (en)
保存場所
- 表示されるドキュメントの内容
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
Activities (en)
保存場所
- 表示されるドキュメントの内容
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
Select File (en)
保存場所
- 表示されるドキュメントの内容
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
Remove Data Column (en)
保存場所
- 表示されるドキュメントの内容
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
Look Up Data Table (en)
保存場所
- 表示されるドキュメントの内容
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
Add Data Column (en)
保存場所
- 表示されるドキュメントの内容
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
Sort Data Table (en)
保存場所
- 表示されるドキュメントの内容
) - 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