I have managed to get PHPExcel working but I have a couple of issues.
My XLS spreadsheet has 7 columns but my MySQL Table has 8 it has an ID column so when I import to it my data is out of sync with the columns. How do i add a dummy field in the INSERT INTO statement?
Also do I really need to know how many rows are in my XLS spreadsheet? I am exporting my XLS from another application and the amount of rows is continually growing.