Website scrapper - simple
Budget: $10 – $30 CAD
I need a Python program/script to do the following.
I have an Excel sheet with 2 columns (QST_Number, Name). The file can have 20K records.
Program should go to a website
https://entreprises.revenuquebec.ca/EntNa/SX/SX00/SX00.SXCLT20A.ValiderInscription/SXCLT20AA?CLNG=A&SVAR=01
Then, one by one enter the QST_Number from Excel, and save the results in Excel starting Column C.
Columns A and B would stay the same (QST_Number and Name)
Column C would be a manual column that should have either "Found" or "Not Found",
Column D would have any errors (if no errors, leave blank)
The website returns 6 results: Registration number, Status, Effective date of status, Date viewed, Name of the entity and Business name. These results can go on Columns E to J.
The program should ask the input file name. The result file should be called "Result-" plus whatever the original file name was.
I have an Excel sheet with 2 columns (QST_Number, Name). The file can have 20K records.
Program should go to a website
https://entreprises.revenuquebec.ca/EntNa/SX/SX00/SX00.SXCLT20A.ValiderInscription/SXCLT20AA?CLNG=A&SVAR=01
Then, one by one enter the QST_Number from Excel, and save the results in Excel starting Column C.
Columns A and B would stay the same (QST_Number and Name)
Column C would be a manual column that should have either "Found" or "Not Found",
Column D would have any errors (if no errors, leave blank)
The website returns 6 results: Registration number, Status, Effective date of status, Date viewed, Name of the entity and Business name. These results can go on Columns E to J.
The program should ask the input file name. The result file should be called "Result-" plus whatever the original file name was.