Read Excel>search for file>open>read Column value> write the value in output file>

Help
1

open excel read a column which contains file name then open that file read a column print the value in output file

2

Could anyone help me with this?

3

which file it is? is it another excel or text file?

4

Hey Sarathi,

Thank for for the quick reply. yes it is an excel file

5

Hey,

Assumed your output file is a text file and generated this xaml, check this one
ReadExcelFiles.xaml (6.5 KB)

1 Like
6

Thank you very much, i am checking. will update on this

7

It is showing an error… activity is either missing or could not be loaded

Missing%20activities%20error
Missing%20activities%20error827×276 8.03 KB

8

Hi,

Sorry, I am using latest uipath studio 2019.9.2

ReadIntexMobile
ReadIntexMobile528×781 44.2 KB

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' />

9

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