Using loop write to ColB starting at next empty cell in ColA Excel

Help
, ,
1

Hi!

Currently, I have a list of urls. I scrape the content in the urls and append range to an excel sheet. This way, each content paragraph (from same article) is in its own excel cell. So, there may be 6 paragraphs in the article which would mean that there are 6 excel cells with content. I am doing this approach for 20+ articles from the same site.

My issue…I’m trying to label each content cell (in Col A) with the corresponding date, title, and url of the article (Columns B,C,&D). Unfortunately, my for loop I cannot get to work to label each paragraph properly (after hours of trying many approaches and reading many articles). I either write a unending loop of the article-title or get nothing at all. What am I doing wrong?

https://drive.google.com/file/d/1iY1rou3OB-En7d_j8w6WypQSqxNHQlkI/view?usp=sharing

Thank you soooo much :slight_smile: :slight_smile:

2

Hi @Manda_B

Welcome to our UiPath Forum! :slight_smile:

Feel free to also provide a sample Excel file to your automation. It might help others find the issue.

A word of advise. I would start simple. If you can extract everything you want once, you could then build a loop.