検索: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日以前
Get Excel Column Name (en)
保存場所
- 表示されるドキュメントの内容
. 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
- タイトル
Get Excel Column Name
- 保存場所
Get Excel Column Name
…Excel Activities
- ドキュメントの内容のソース
] 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
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 Read Column (en)
保存場所
- 表示されるドキュメントの内容
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
- タイトル
Excel Read Column
- 保存場所
Excel Read Column
…Excel Activities
- ドキュメントの内容のソース
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 (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