open excel read a column which contains file name then open that file read a column print the value in output file
Could anyone help me with this?
which file it is? is it another excel or text file?
Hey Sarathi,
Thank for for the quick reply. yes it is an excel file
Hey,
Assumed your output file is a text file and generated this xaml, check this one
ReadExcelFiles.xaml (6.5 KB)
Thank you very much, i am checking. will update on this
Hi,
Sorry, I am using latest uipath studio 2019.9.2
Attach browser
<html title='Consumer Durable, IT and Mobile Accessories, Smartphones, TVs, R*' />
Extract Structured Data ‘DIV store-location’
ExtractMetaData
"<extract><column attr='text' name='Column1' exact='1'><webctrl class='address-box' tag='div' /></column></extract>"
Selector
<webctrl id='store-location' tag='DIV' />
This is different! i mean this is for data scraping but here i am trying to read files names from excel and then searching and opening them one by one