検索:excel-get-column-name
adminが2022/04/24 04:58に最終更新
検索を絞り込む
カテゴリーを選択して結果を絞り込む
保存場所
- 44Activities
- 2akaBot Agent
- 1akaBot Studio
最終更新者
- 21Giang Tran
- 14VuNH54
- 6DatPT
- 1admin
作成者
- 40Giang Tran
- 2admin
最終更新日
- 4230日以前
作成日
- 4230日以前
アップロード日
- 10530日以前
- 並び替え:
- 関連性
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
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
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
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
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
Excel Application Scope (en)
保存場所
- 表示されるドキュメントの内容
RCA.Activities.Excel.ExcelApplicationScope Description This activity allows to open an Excel workbook and provides a scope for Excel Activities. (* for mandatory) In the body of the activity Workbook Path (String) - The path of the Excel file you want to read. E.g: “C:\FolderName\Contacts.xlsx
- タイトル
Excel Application Scope
- 保存場所
Excel Activities
…Excel Application Scope
- ドキュメントの内容のソース
" %) ((( RCA.Activities.Excel.ExcelApplicationScope == **Description** == This activity allows to open an Excel workbook and provides a scope for Excel Activities. [[image:image-20220505111836-1.jpeg]] (* for mandatory) == **In the body of the activity** == * **Workbook Path (String)** - The path of the Excel file you want to read. E.g: “C