検索:excel-get-column-name
adminが2022/04/24 04:58に最終更新
検索を絞り込む
カテゴリーを選択して結果を絞り込む
保存場所
- 122Activities
- 29akaBot Center
- 6akaBot Insights
- 6akaBot Vision
- 5akaBot Agent
- … あと10件
最終更新者
- 75admin
- 31Nhan Nguyen
- 24VuNH54
- 21Giang Tran
- 14Nga Nguyen
- … あと4件
最終更新日
- 10030日以前
作成日
- 13930日以前
オブジェクトの種類
ファイルの種類
アップロードした人
- 55admin
- 42Giang Tran
- 42Nhan Nguyen
- 20Nga Nguyen
- 3DatPT
- … あと3件
アップロード日
- 10230日以前
Format Column Names (en)
保存場所
- 表示されるドキュメントの内容
RCA.Activities.Salesforce.FormatColumnNames This activity replaces the column names within a designated DataTable variable. Properties Input Data: Specifies the DataTable variable whose column names
…a DataTable variable containing two columns: ColumnName: Represents the expected column names present
- タイトル
Format Column Names
- 保存場所
Format Column Name
- ドキュメントの内容のソース
RCA.Activities.Salesforce.FormatColumnNames This activity replaces the column names within
…column names need replacement. Only DataTable variables are supported in this field. * **Mapping
…column names present in the DataTable variable specified in the Data field. ** **FieldName: **Specifies
Excel Insert Or Delete Columns (en)
保存場所
- 表示されるドキュメントの内容
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
- タイトル
Excel Insert Or Delete Columns
- 保存場所
Excel Activities
…Excel Insert Or Delete Columns
- ドキュメントの内容のソース
)** - 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 (en)
保存場所
- 表示されるドキュメントの内容
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
- タイトル
Excel Insert Columns Table
- 保存場所
Excel Activities
…Excel Insert Columns Table
- ドキュメントの内容のソース
)** - 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 Get Workbook Sheets (en)
保存場所
- 表示されるドキュメントの内容
for a sheet based on its index and returns its name as a String variable. This only can be used in Excel
…to public it. Remember to consider data security requirement before using it. Display Name (String) - The name of this activity. You can edit the name of the activity to organize and structure your code better
- タイトル
Excel Get Workbook Sheets
- 保存場所
Excel Get Workbook Sheets
…Excel Activities
- ドキュメントの内容のソース
and returns its name as a String variable. This only can be used in Excel Application Scope Activity
…it. * **Display Name (String)** - The name of this activity. You can edit the name of the activity to organize and structure your code better. E.g: Get Workbook Sheets ))) (% class="akb-toc" %) ((( (% class="akb-toc-title
Excel Get Workbook Sheet (en)
保存場所
- 表示されるドキュメントの内容
for a sheet based on its index and returns its name as a String variable. be used in Excel Application Scope
…code better. E.g: Get Workbook Sheet Output Sheet (String) - List of string that contains sheet names
…if you want to public it. Remember to consider data security requirement before using it. Display Name
- タイトル
Excel Get Workbook Sheet
- 保存場所
Excel Get Workbook Sheet
…Excel Activities
- ドキュメントの内容のソース
and returns its name as a String variable. be used in Excel Application Scope Activity. [[image:image
…data security requirement before using it. * **Display Name (String) **- The name of this activity. You can edit the name of the activity to organize and structure your code better. E.g: Get Workbook
Activities (en)
保存場所
- 表示されるドキュメントの内容
Range Excel Copy Sheet Excel Delete Range Excel Get Workbook Sheet Excel Get Workbook Sheets Excel Insert Columns Table Excel Insert Or Delete Columns Excel Insert Or Delete Rows Excel Insert Rows Excel
…Write Cell Excel Write Range Execute Macro Export Chart Read Column Read Range Read Row Write Cell Write
- 保存場所
Excel Activities
- ドキュメントの内容のソース
/]] * [[Excel Get Workbook Sheet>>url:https://docs.akabot.com/bin/view/Activities/Excel%20Activities/Activities/Excel%20Get%20Workbook%20Sheet/]] * [[Excel Get Workbook Sheets>>url:https://docs.akabot.com/bin/view/Activities/Excel%20Activities/Activities/Excel%20Get%20Workbook%20Sheets/]] * [[Excel Insert Columns Table
[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
Read Column (en)
保存場所
- 表示されるドキュメントの内容
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
- タイトル
Read Column
- 保存場所
Excel Activities
…Read Column
- ドキュメントの内容のソース
" %) ((( 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
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