VLookup Workbook (preview)

VLookup Workbook activity that finds a value in the first column of a table range using the Excel VLOOKUP function and returns a value from another column.

UiPath.Excel.Activities.VLookup

説明

Looks up a value in the first column of a table range and returns a value from the column that you specify, using the Excel VLOOKUP function. This is the cross-platform equivalent of the VLookup Windows activity.

注:

This activity does not support .xls files.

プロジェクトの対応 OS

Windows | クロスプラットフォーム

プロパティ

共通

• 表示名 - デザイナー パネルに表示されるアクティビティの名前です。

入力

• ファイル - リソースのブックのフル パスです。ローカル パスに切り替えるには、プラス記号のアイコンを選択し、[ローカル ファイルを使用] を選択します。現在のフィールドが [ファイル (ローカル パス)] に変更され、ブックのフル パスを指定できます。
• シート名 - ブックのシートの名前です。
• Table Range - The table range to search. The activity searches the first column of the range. This field is required.
• Lookup Value - The value to search for. This field is required.
• Column Index - The 1-based index of the column, within the table range, to return a value from. Column 1 is the first column of the range, the one that is searched. This field is required.

オプション

• Exact Match - Select this option for an exact match. Clear it for an approximate match against sorted data, which finds the nearest value that is less than or equal to the lookup value. By default, this option is selected.
• パスワード - ブックのパスワードです (必要な場合)。

出力

• Result - The value that the activity found, or null if the lookup value is not found. You can store the value in a variable of any type. The value is converted if the type is different.

ブックを使用する

• Workbook - The existing workbook to use instead of a file path.

備考

• For an approximate match, the first column of the table range must be sorted in ascending order, as in the Excel VLOOKUP function.
• Table Range must refer to the sheet in SheetName. A range that includes a sheet name, such as Sheet2!A1:C100, is not supported and causes an error.
• A whole-column or whole-row range, such as A:C, is limited to the used range of the sheet.
• The activity fails with an error if Table Range is empty, if Column Index is less than 1 or greater than the number of columns in the range, or if Lookup Value is null.