Excel opens midway through table extraction

Help StudioX
,
1

Hi guys,

Making another post as I think I had the wrong tags on the previous one. Apologies if this is the wrong place, I’m new to the forum.

I’m a StudioX user of UiPath and for years have used it for table extraction. However, now when I try and scrape a webpage with multiple pages, it does not seem to work. When I press execute, it scrapes the first page, then opens up the Excel which I am extracting to, and then stops when it gets to page 2. I’m not sure why it’s opening the Excel mid way through; I have always scraped using this workflow and it has been fine.

Do you know how I could fix this? I don’t know UiPath well so any instructions in simple terms would be hugely appreciated.

Thank you! :slight_smile:

The image shows a workflow in UiPath for extracting table data from a web page into an Excel file. (Captioned by AI)
The image shows a workflow in UiPath for extracting table data from a web page into an Excel file. (Captioned by AI)521×796 25.9 KB

2

Hi @Luke2390,

Try below,

  1. Add a ‘Excel Process Scope’ activity and move the ‘Use excel file’ activity inside it.
  2. In the properties of ‘Excel Process Scope’, Choose ‘False’ option on ‘Show Excel Window’ dropdown like below.
    This image shows the properties of the Excel Process Scope activity in UiPath, with various configurable settings including Display alerts, Existing processes action, File conflict resolution, and Show Excel window. (Captioned by AI)
    This image shows the properties of the Excel Process Scope activity in UiPath, with various configurable settings including Display alerts, Existing processes action, File conflict resolution, and Show Excel window. (Captioned by AI)314×429 9.61 KB

Confirm if it working.

3

@Luke2390

Instead of following your way, try below way,

  1. First extract the data from browser which contains multiple pages, to extract multiple pages there is one toggle you need to enable that was Extract data from multiple pages. find below screenshot.

image

3.After completing extract now use excel activities to write the data.
you can simply use write range workbook activity to write the data into excel or if you want use modern activities,

  • Use Excel process scope
  • inside that use use excel file
  • inside of this use write datatable to excel

This will you good structure for development and for your debugging purpose also it can help you

Happy Automation!!

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.