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

Descripción

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.

Nota:

This activity does not support .xls files.

Compatibilidad de proyectos

Windows | Multiplataforma

Propiedades

Común

• DisplayName - The name displayed for the activity in the Designer panel.

Entrada

• Archivo : la ruta completa del libro de recursos. Para cambiar a una ruta local, selecciona el icono más y luego Usar archivo local. El campo actual cambia a Archivo (ruta local), donde puedes proporcionar la ruta completa del libro.
• NombreDeLaHoja : el nombre de la hoja del libro.
• 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.

Opciones

• 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.
• Contraseña : la contraseña del libro, si es necesario.

Salida

• 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.

Utilizar libro

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

Notas

• 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.