Execute loop in web

Hey,

I need your help because my project needs to loop all pages.

I’m using click to next page in yellow streaked image.

Hi @Renan_Pereira,
Can you tell me what issue you are facing?

@Renan_Pereira

Could you please tell more details about the issue ?

It looks like structured data and so you can use Data scraping to scrape the data and also indicate that next page navigator to navigate to all pages. It will scrape all pages data and will you output as DataTable.

@Jyotika_Halai Eu preciso criar um loop para extrair todas as páginas e enviar para o Excel.

Para extrair as informações, uso a raspagem de dados, mas preciso extrair as informações nas outras páginas.

@lakshman

I need to create a loop to extract all pages and send to excel.

To extract the information I use data scraping but I need to extract the information on the other pages.

@Renan_Pereira

You have to indicate next page navigator to scrape next pages. It will scrape all pages data at a time.

Please check below thread.

https://docs.uipath.com/studio/docs/example-of-using-data-scraping

And how do I delete these lines?

@Renan_Pereira

Write into Excel file and then delete empty rows which are not required.

@Renan_Pereira,

To add to what @lakshman mentioned I surmise you can use the activity duplicate data table (or with a similar name like this, just goo to data table activity list and you will find that)

or use a Linq query like below -

Dtset.Tables(0).AsEnumerable().Where(Function(row) row.ItemArray.All(Function(field) field Is Nothing Or field Is DBNull.Value Or field.Equals(""))).ToList().ForEach(Sub(row) row.Delete())

in an assign statement for the final data table before using the write range activity :slight_smile:

Regards

1 Like

Hi @Renan_Pereira,
You are not able to write in excel because starting cell is empty. Try to scrape column one by one.

Thanks.