検索:excel-get-workbook-sheets
adminが2022/04/24 04:58に最終更新
検索を絞り込む
カテゴリーを選択して結果を絞り込む
保存場所
最終更新者
- 6VuNH54
- 4Giang Tran
- 2admin
作成者
- 7Giang Tran
- 3VuNH54
- 1LongVA
- 1admin
最終更新日
- 1230日以前
作成日
- 1230日以前
オブジェクトの種類
アップロードした人
- 7Giang Tran
- 3VuNH54
- 1LongVA
- 1admin
アップロード日
- 3230日以前
Get Excel Column Name (en)
保存場所
- 表示されるドキュメントの内容
. E.g: [482156710] Get Excel Column Name Output Result (String) - Stores column name in a string
- タイトル
Get Excel Column Name
- 保存場所
Get Excel Column Name
…Excel Activities
- ドキュメントの内容のソース
] Get Excel Column Name **Output** * **Result (String) **- Stores column name in a string variable.
Excel Remove Duplicates Range (en)
保存場所
- 表示されるドキュメントの内容
that are duplicated in a specified range. (*for mandatory) In the body of activity Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Range (String
…of the sheet in the workbook where the change must be made. E.g: "Sheet1" Misc Public (Boolean) - Check
- タイトル
Excel Remove Duplicates Range
- 保存場所
Excel Activities
…Excel Remove Duplicates Range
- ドキュメントの内容のソース
. [[image:image-20220505141832-1.png]] (*for mandatory) == **In the body of activity** == * **Sheet name (String)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1
…. E.g: "A1:H5" * **Sheet name (String)*** - The name of the sheet in the workbook where the change must
Read Column (en)
保存場所
- 表示されるドキュメントの内容
) 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
…, this is filled in with "A1". E.g: "A1" Workbook Path (String)* - The path of the Excel file you want to read. E.g
- 保存場所
Excel Activities
- ドキュメントの内容のソース
]] (* 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
…" * **Workbook Path (String)*** - The path of the Excel file you want to read. E.g: “C:\FolderName
Read Row (en)
保存場所
- 表示されるドキュメントの内容
) 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
…in with "A1". E.g: "A1" Workbook Path (String)* - The path of the Excel file you want to read. E.g: “C
- 保存場所
Excel Activities
- ドキュメントの内容のソース
]] (*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
…". E.g: "A1" * **Workbook Path (String)*** - The path of the Excel file you want to read. E.g: “C
Excel Insert Columns Table (en)
保存場所
- 表示されるドキュメントの内容
position in the table. (* for mandatory) In the body of activity Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Table name (String) - Table name you
…) - Position you want to add. Sheet name (String)* - The name of the sheet in the workbook where the change
- タイトル
Excel Insert Columns Table
- 保存場所
Excel Activities
…Excel Insert Columns Table
- ドキュメントの内容のソース
-20220505141633-1.png]] (* for mandatory) == **In the body of activity** == * **Sheet name (String)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" * **Table name (String
…(String)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" * **Table
Excel LookUp Range (en)
保存場所
- 表示されるドキュメントの内容
) In the body of activity Sheet name (String)* - The name of the sheet in the workbook where you want to search
…(String)* - The range where you want to perform the search. E.g: "A1:H5" Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Value (String) - The value that you
- タイトル
Excel LookUp Range
- 保存場所
Excel Activities
…Excel LookUp Range
- ドキュメントの内容のソース
]] (* for mandatory) == **In the body of activity** == * **Sheet name (String)*** - The name of the sheet in the workbook where you want to search. E.g: "Sheet1" * **Range (String)*** - The range where you want
…where you want to perform the search. E.g: "A1:H5" * **Sheet name (String)*** - The name of the sheet
Excel Insert Or Delete Columns (en)
保存場所
- 表示されるドキュメントの内容
or removal begins. E.g: 2 Sheet name (String)* - The name of the sheet in the workbook where the change must
…columns to the document. ・Delete: Remove columns from the document. Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Misc Public (Boolean) - Check
- タイトル
Excel Insert Or Delete Columns
- 保存場所
Excel Activities
…Excel Insert Or Delete Columns
- ドキュメントの内容のソース
**: Remove columns from the document. * **Sheet name (String)*** - The name of the sheet in the workbook
…)** - The column where the insertion or removal begins. E.g: 2 * **Sheet name (String)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" == **Properties** == **Destination** * **Number
Excel Insert Or Delete Rows (en)
保存場所
- 表示されるドキュメントの内容
the document. Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g
…or removal begins. By default, this is filled in with 1. E.g: 2 Sheet name (String)* - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1" Properties Destination Number of rows (Int32
- タイトル
Excel Insert Or Delete Rows
- 保存場所
Excel Activities
…Excel Insert Or Delete Rows
- ドキュメントの内容のソース
)** - The row where the insertion or removal begins. By default, this is filled in with 1. E.g: 2 * **Sheet name (String)*** - The name of the sheet in the workbook where the change must be made. E.g: "Sheet1
…the document. * **Sheet name (String)*** - The name of the sheet in the workbook where the change must be made
Excel Read Row (en)
保存場所
- 表示されるドキュメントの内容
of an Excel row beginning from the cell specified in the StartingCell field: and stores it in an lEnumerable<object> variable. (* is mandatory) In the body of activity Sheet name - The sheet you want to read
…, this is filled in with "A1". E.g: "A1" Properties Input Sheet name (String)* - The sheet you want to read. E.g
- タイトル
Excel Read Row
- 保存場所
Excel Activities
…Excel Read Row
- ドキュメントの内容のソース
the values of an Excel row beginning from the cell specified in the StartingCell field: and stores
…of activity** == * **Sheet name** - The sheet you want to read. E.g: "Sheet1" * **Starting Cell** - The cell
…" == **Properties** == **Input** * **Sheet name (String)*** - The sheet you want to read. E.g: "Sheet1
Excel Read Column (en)
保存場所
- 表示されるドキュメントの内容
(* for mandatory) In the body of activity Sheet name - The sheet you want to read. E.g: "Sheet1" Starting Cell
…" Properties Input Sheet name (String)* - The sheet you want to read. E.g: "Sheet1" Starting Cell (String
…the name of the activity to organize and structure your code better. E.g: [482156710] Excel Read Column
- タイトル
Excel Read Column
- 保存場所
Excel Activities
…Excel Read Column
- ドキュメントの内容のソース
** == * **Sheet name** - The sheet you want to read. E.g: "Sheet1" * **Starting Cell** - The cell from which
…" == **Properties** == **Input** * **Sheet name (String)*** - The sheet you want to read. E.g: "Sheet1
…your code better. E.g: [482156710] Excel Read Column **Options** * **Preserve Format (Boolean