I am collecting links from several pages, then I enter each link that has an ad and collect the title. but I need to insert everything in Excel, line by line, does anyone know where I’m going wrong?
- Build datatable with 2 column(“AD_Link”,“Title”)
- whenever you collect the link ,use Add datarow to the already built datatable and pass the values
- then after collecting all the links finally write the datatable to the Excel sheet
(if you need the previous link collected values as well,then you can use Excel Append Range activity )
Let me know if you need further clarification.