First post on here so apologies if I’m in the wrong place.
I am long term (but basic) user of UiPath for web scraping purposes. I have never had a problem, until over the last few weeks everytime I have attempted to scrape a website using Table Extraction, it does not always work.
Specifically, if just scraping on a single page it is fine. However, if I try to scrape across multiple pages, when I run the action it scrapes the first page, then opens up the Excel file which it is extracting to, stops scraping and then subsequently closes the Excel. I have no idea why it’s opening the document mid scrape and this appears to be part of the issue. Do you know how I could fix this? As mentioned, it seems to work fine if just scraping a single page.
Hey @Luke2390
It looks like UiPath might be jumping to the Excel export right after scraping the first page, which would stop the rest of the pagination. This can happen if the Excel write step ends up inside the loop, or if it was added automatically by the Table Extraction wizard.
Hard to say for sure without seeing it - could you share a screenshot of your workflow?
Which version of UiPath are you using ?
Which activities are you using ?
Looks like ‘NextLinkSelector’ i.e. selector of the ‘Next’ button seems to be an issue.
Also check the value of ‘MaxNumberOfResults’. It has to be ‘0’ to extract all the values of the table. ( Please refer screenshot )
Does anyone have any suggestions on how I might fix this? When I run the scraper it only does the first page because it opens up the Excel during the scraping process. I’m not very good with UiPath so any suggestions in simple terms would be incredibly appreciated.
And for sure don’t keep the table extraction activity inside Excel Application scope. There is issue with sequencing in the snapshot that you have shared.
Can you explain what my sequence should look like in that case? If I don’t include the table extraction in the Excel Application scope, then it doesn’t appear to let me extract the table to my specific Excel. What is the correct ordering?
One separate question - where do I go to uncheck the ‘keep excel file open’ property?
Apologies for the basic questions, I’m a very infrequent UiPath user.
I have followed the example above but I’m still faced with the same issue where my Excel opens during the process and it only scrapes the first page.
If you wouldn’t mind, please could you send me a screenshot of what the workflow should look like when data scraping into an Excel. I’m confused what it’s supposed to look like if my table exaction activity doesn’t sit inside the “Use Excel File” section.
