Excel automation (VLOOKUP) with MS Excel

excel

#1

André
July 01, 2016 18:15 NONE
Hello,

I’m just starting with UIpath studio and I’m facing a problem with excel automation.

My goal is to automate the creation of a column in an existing Excel file, name it and then do a VLOOKUP function down all the column (searching in a different sheet). Then I might have other actions to automate within Excel.

My problem is that when I use the “Click” module or the recording mode, I can’t click precisely on a cell: when I pass the cursor over the table, all the table goes blue as a sole clickable area. Therefore I can’t record a click on a specific cell, or duplicate a formula over a column, etc.

How can I solve this?

Thank you for your help !

Regards,

André


Apply V-look up
#2

Mihai Badita July 02, 2016 20:37
Hi Andree,

A workaround would be to perform the processing in memory or by using the excel activities.

This might help: http://www.uipath.com/kb-articles/simulate-excel-vlookup-in-a-datatable


#3

Hi Mihai, please is datatable’s Select method supposed to work also with Strings? Because the example works fine with integers but as soon as i want to loop up string it crashes.
Thank you :wink:


#4

Select works with all datatypes, but some of them (like dates) require specific syntax.
You can see some examples here: https://www.dotnetperls.com/datatable-select-vbnet

What error message are you getting/can you post a repro xaml (or at least your condition)?


#5

Hi Andrzej, thank you for the link, it helped. I havent included ’ (apostrophe) so thats why it didnt work.


Exception from HRESULT