Script to check data from Excel file to web page

Question

I have an Excel spreadsheet with about 300 names which includes ID, first name and second name (different column each).

I have a website (not in English) that has forms to fill with people ID, first name, last name and a search button.

There's 2 outcomes that the search can provide:

• either there will be one line massage under the form which indicate me NO result

• or a new window will open to fill some details which means to me YES result (I don't need to fill those details, the new window display is the final result) and a new search will begin.

I need a script to auto insert the details from the Excel spreadsheet and return me yes or no results (or whatever 2 options result).

If the results can be inported from the Excel file that will be great.

Thanks in advance!

Answer 1

Start by looking at libraries like PHPExcel, then you can ask any specific questions over code that you're having problems with, but don't expect people to write your application for you