Hi, Please guide me on below challenge:
Problem statement: I have 10 input excel file and 6 source files(1 .xlsb, rest all xlsx file).I need to open one by one of these 10 input files and need to do vlook up and fetch data from 6 source files, and need to apply some formulas also in some columns. Currently I am invoking vba scripts from UiPath and doing this functionality. and when doing vloopup I am not opening any of the source files other than the .xlsb file in foreground when doing vlookup.
Can anyone pls suggest using python script or vba script will be better ( in terms of speed of execution), since my process involves multiple excel files and excel related operations only