Web Excel SQL Automation All in one
This Process navigates to https://tipidpc.com/useritems.php?username=pchub and extracts the following information for each product:
- Product description
*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.