php excel reader and display resultsin html

on html page 5 different field Postcode,AQ,Profile,Area,Uplift Uplift field is used for adding digits up on top of the values displayed dynamically there is two different Headings E and G means we will divide the page in two with different Headings from the files.. All the EXCEL files is a price-book that refreshed every week so we replace the files every week. for this reason your script needs to be able to read this files even if they replaced assuming same format. for example first box we enter 03 profile 2nd box we enter 10 Area ====================================================================================== Category E Files FOR DUAL file SMART Saver Acquisition Price book (aug14).xls Can you check if you can make your script read from the file and do this: as well as other fields we will have one single html page and few fields to enter some number and it will read from the file and display the correct row so based on this entry script should open the sheet 10 and list the result from ROW18,19 with headings as 3YEAR results and ROW 35,36 as 2YEAR results so it would use the same heading but we would add another column to beginning called LENGTH to display if it is 2YEAR or 3YEAR FOR SSE file [login to view URL] when we enter 03 and 10 on the first sheet the correct ROW is 4 and 5 you will see ColumnD and ColumnE defines that from what entered this would read from all sheets as each sheet is for 12,24,36,48month ======================================================================================= Category G files FOR CNG file=DIRECT CNG 24Mth Latest from [login to view URL] (you will find this file have hidden Rows so your script will need to be able to see the hidden rows automatically to work properly ,... ) profile and area fields wont effect for this file provided what postcode entered if script can enter the values on ColumnB and get results from ColumnD and show them on page that is great postcode is the 2nd sheet in this file and you will see how it works, we will have postcode field to enter on html and once we enter it will find the nearest matching postcode in the file and it will enter the value into that cell in columnB if you enter 90000 into B14 CELL you will see the price result changes on right so that's what is needed to be displayed on HTML page.. FOR GP file:20p-65p MATRIX - VERSION [login to view URL] profile and area fields wont effect for this file on ColumnB you can see all the AQ range (we will have an AQ field to enter) so if i enter 10000 this would display the ROW (21-22)