July 01, 2016 18:15 NONE
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 !