検索:excel-get-column-name
adminが2022/04/24 04:58に最終更新
検索を絞り込む
カテゴリーを選択して結果を絞り込む
保存場所
- 141Activities
- 30akaBot Center
- 6akaBot Insights
- 6akaBot Vision
- 5akaBot Agent
- … あと10件
最終更新者
- 76admin
- 32Nhan Nguyen
- 30VuNH54
- 21Giang Tran
- 17Nga Nguyen
- … あと4件
作成者
- 140admin
- 45Giang Tran
- 7Tuan Nguyen
- 4Nga Nguyen
- 3Nhan Nguyen
- … あと3件
最終更新日
- 10030日以前
作成日
- 13930日以前
ファイルの種類
アップロードした人
- 56admin
- 45Nhan Nguyen
- 42Giang Tran
- 24Nga Nguyen
- 9Tuan Nguyen
- … あと3件
アップロード日
- 10230日以前
Excel Activities (en)
保存場所
- 表示されるドキュメントの内容
The Excel Activities offers deep integration with Microsoft Excel and ships with a number of activities that automate the tasks you perform in Excel. These activities enable the robots to: Read information from a cell, columns, rows or ranges, and write to other spreadsheets or workbooks. Execute macros
- タイトル
Excel Activities
- 保存場所
Excel Activities
- ドキュメントの内容のソース
The Excel Activities offers deep integration with Microsoft Excel and ships with a number of activities that automate the tasks you perform in Excel. These activities enable the robots to: * ((( Read information from a cell, columns, rows or ranges, and write to other spreadsheets or workbooks. ))) * Execute
Read Range (en)
保存場所
- 表示されるドキュメントの内容
) - 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
- 保存場所
Excel Activities
- ドキュメントの内容のソース
" %) ((( 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
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
Write Range (en)
保存場所
- 表示されるドキュメントの内容
) 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
- 保存場所
Excel Activities
- ドキュメントの内容のソース
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
Activities (en)
保存場所
- 表示されるドキュメントの内容
Composite Request Insert Record Update Record Delete Record Get Record Get List View Records Upset Record Create Bulk API Job Get Bulk API Job Start or Abort Bulk API Job Get Bulk API Job Result Upload File Download File Assign File Salesforce Application Scope Execute SOQL Execute Report Format Column
- ドキュメントの内容のソース
/Salesforce/Activities/Execute%20Report/]] * [[Format Column Names>>https://docs.akabot.com/bin/view
…%20Record/]] * [[Get Record>>https://docs.akabot.com/bin/view/Activities/Salesforce/Activities/Get%20Record/]] * [[Get List View Records>>https://docs.akabot.com/bin/view/Activities/Salesforce/Activities/Get%20List
Release Notes (en)
保存場所
- 表示されるドキュメントの内容
Record Delete Record Get Record Get List View Records Upset Record Create Bulk API Job Get Bulk API Job Start or Abort Bulk API Job Get Bulk API Job Result Upload File Download File Assign File Salesforce Application Scope Execute SOQL Execute Report Format Column Names Format Labels and Values Lightning REST API
- ドキュメントの内容のソース
* Format Column Names * Format Labels and Values * Lightning REST API Request * Search ))) ))) {{velocity
…* Insert Record * Update Record * Delete Record * Get Record * Get List View Records * Upset Record * Create Bulk API Job * Get Bulk API Job * Start or Abort Bulk API Job * Get Bulk API Job Result * Upload
Excel Write Range (en)
保存場所
- 表示されるドキュメントの内容
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
- タイトル
Excel Write Range
- 保存場所
Excel Activities
…Excel Write Range
- ドキュメントの内容のソース
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
Excel Delete Range (en)
保存場所
- 表示されるドキュメントの内容
in an Excel workbook. Can also be used to shift an entire row or column by using the ShiftCells and ShiftOption property fields. (* for mandatory) Properties Input Sheet Name (String) - The name
…want to public it. Remember to consider data security requirement before using it. Display Name (String
- タイトル
Excel Delete Range
- 保存場所
Excel Activities
…Excel Delete Range
- ドキュメントの内容のソース
" %) ((( RCA.Activities.Excel.ExcelDeleteRange == **Description** == This activity allows deleting a specified range in an Excel workbook. Can also be used to shift an entire row or column by using the ShiftCells and ShiftOption property
…** == **Input** * **Sheet Name (String)** - The name of the sheet contains the data you want to delete
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