I am using the php excel reader from google (http://code.google.com/p/php-excel-reader2/downloads/list) I am building an affiliate stats site and I want to display only one row from my excel file. How can I do that? Also is it possible to display a row that contains a certain word? For example "display the row that contains the tracker number 1234567". Thanks for your answer in advance.
Should look into the documentation on their website, I found this after a quick search: You can do a for loop, and loop through all the read values and only echo it when your $matchedvalue is shown.
the only problem is that I am new to such things and even if I would have found it wouldn't have known where to add it. THanks for looking after. I will try to experiment with it a bit.
yes, you can do this. With the help of Excel reader you can read the excel file just like as if you were reading data from MySql database. If you want my help then you most welcome.
It might be easier to write an import script for your Excel file into MySQL. You could run it on a daily basis (or whatever suits) via a cron job to refresh the data. Then you can lookup the data in MySQL which will be a lot quicker than reading Excel.