i am a beginner at Uipath and need your help.
I would like to implement the following automation:
open webpage
exctract all Links in a data tabel using Data Extraction
open each childlink, which containes some fixed keywords
exctract a defined pattern, using Data Extraction
save the extract data from each link in separate sheets of one Excelfile
I did some work, but im still not able to save the data in the separate sheets. I do not know how to genrate new sheets for each link and save the data.
I would be very grateful if someone could help me.
You dont need to explicitly ‘generate’ new sheets as any write range activity will check if the sheet exists and if not it will generate automatically.
Also, you can declare different data tables for each sheet and then assign them in the write range activity so that certain sheets have their own data-tables.
Data scraping must be fairly easy as you have the option of scraping the hyperlinks also. If not you can also explore find children activity. Go through the links and you will get a fair idea on how to leverage it for ‘child’ links also.
In data scraping you can make use of the meta-data also to tailor the script to your needs that loops through child links and main headers. You can take any avenue, that feels easier.
Hope this helps, do get back if you still have issue
Regards
I already declared the datatable to variable, by naming it “ExtractDataTable_text”. But it still doesnt write anything to the excel file. I even tried to fix the problem by implementing a counter above the write range actvity( see screenshot), but still no sucess.
Unfortunately, I still have no idea why no data is written to the excel file.