Workbook Read Range doesn't handle VLOOKUP properly

I have an Excel file I’m reading that uses VLOOKUP to pull data from another Excel file. When reading with Workbook Read Range the dates come through as integers…

image

If I switch to Excel Application Scope it works…

image

So I’m asking for Workbook Read Range to be fixed so it can handle VLOOKUP data properly.

This is using UiPath.Excel.Activities v2.10.4

1 Like

Have you tried using preserve format property present in workbook read range activity ?

If not, Could you please try that.

Thanks
#nK

hear thinking, kind of confused though

I believe that’s not something that needs or can be enhanced.

The VLOOKUP values are actually using excel advanced functions and hence a normal workbook is not designed to fetch those values. We have excel application scope for that, which uses application api to perform those advanced functions.

Preserve Format had no effect.

1 Like

Try making that column as text type in excel and use the preserve format. Hope that may help.

#nK

I cannot do that. We cannot change the Excel file.

1 Like

Also, you are not supposed to use Excel ?

Kindly confirm

#nK

We are using Excel. That’s what the Workbook activities do. Yes, Excel Application Scope works for linked data. I’m hoping Workbook activities can be updated to handle linked data, too. That’s all.

1 Like