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…

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

Excel automation (VLOOKUP) with MS Excel

Help

jan (Jan) November 3, 2016, 1:08pm 5

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

Exception from HRESULT

Topic		Replies	Views
Apply V-look up Help datatable , excel	9	6529	July 2, 2017
Vlookup Excel hotkeys Help excel , uiautomation , activities	4	2748	October 29, 2018
Vlookup looping through multiple cells Studio datatable , excel , uiautomation , activities , question	3	1790	May 23, 2020
Approach for automating excel with very large amount of data Help excel , uiautomation	2	4044	May 29, 2020
UIPath Lookup Function Help studio	1	716	August 21, 2019

Most Active Users - Yesterday
ashokkarale
Anil_G
Yoichi
yangyq10
postwick
chandreshsinh.jadeja
aravindbalineni123
Parvathy
aya
PRASHANT_GABHANE
More details...

Excel automation (VLOOKUP) with MS Excel

Related Topics