Support Portal

for ProcessRobot and WinAutomation

Start a new topic

Web Excel SQL Automation All in one

ADMIN

This Process navigates to https://tipidpc.com/useritems.php?username=pchub and extracts the following information for each product:

  • Product description
  • Price
  • Category

*Note the regex that is being applied within the "Extract Data from Web Page" Action in order to extract the price correctly.


The data is stored into the Excel file "webdata.xlsx".


Afterwards, a second Excel file "filter_data.xlsx" is being created, that contains a worksheet for each one of the categories found above.

The data of each category are stored into the corresponding worksheet.


SQL Actions Requirements
Verify that any one of the below drivers are installed on your machine. If not, install one of them through the links below.

waj
Login or Signup to post a comment