Search: excel-get-column-name

. 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

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

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

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

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

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

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

RCA.Activities.Excel.ExcelInsertColumnsTable 説明 指定された列をテーブル内の特定の位置に追加します。 *は必須。 アクティビティの内容

："Column1" プロパティ 入力 列名（文字列）：挿入する列の名前。 例："Column1" 位置（整数）：追加する位置。 シート名（文字列）*：変更する必要があるワークブック内のシートの名前。 例

してください。 表示名（文字列）：アクティビティ名。アクティビティ名を編集して、コードをより適切に整理および構造化で名称きます。 例：[028225900]Excel列を挿入

Excel列を挿入

(% class="akb-page-with-toc" %) ((( (% class="akb-page-content" %) ((( RCA.Activities.Excel

" * **列名（文字列）**：挿入する列の名前。 例："Column1" == **プロパティ** == **入力** * **列名（文字列）**：挿入する列の名前。 例："Column1" * **位置

）**：アクティビティ名。アクティビティ名を編集して、コードをより適切に整理および構造化で名称きます。 例：[028225900]Excel列を挿入 ))) {{velocity}} #if ($xcontext

Excel Activities

Excel Insert Columns Table

-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

されます。このフィールドはInt32変数のみをサポートします。 Target Column Column Index：ここにColumnインデックスを指定すると、この列からRow Indexプロパティの値までの座標内で見つかったセルの値を返します。 このフィールドはInt32変数のみをサポートします。 例：1 Column Name（文字列）：ここで列名を指定すると、この列とRowIndexプロパティの値の間の座標

）*：ルックアップを実行するデータテーブル変数です。このフィールドはデータテーブル変数のみをサポートします。 Lookup Column 列インデックス（整数）：検索する列のインデックスです。このフィールド

：1 * **Column Name（文字列）**：ここで列名を指定すると、この列とRowIndexプロパティの値の間の座標にあるセルの値が返されます。このフィールドは文字列および文字列変数

するデータテーブル変数です。このフィールドはデータテーブル変数のみをサポートします。 **Lookup Column** * **列インデックス（整数）**：検索する列のインデックスです。このフィールド

します。 * **Row Index**：見つかったセルの行インデックスです。Int32変数に格納されます。このフィールドはInt32変数のみをサポートします。 **Target Column** * **Column