Website scrapper - simple

Замовник: AI | Опубліковано: 08.01.2026

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.