I'm using a script named: reader.php which is for reading an Excel file with an extension of .xls. It works great. I have come across a bug that I am hoping someone with a bit more knowledge of Excel and php can help with.
I am now using Excel 2003. The reader.php class doesn't seem to know how to extract numbers from the spreadsheet and display them correctly on my webpage. All cells with just numbers are displayed to my webpage as zeros. Numbers with decimal places, such as 1.23, show as 0.00. Columns of text/characters display correctly.
If I upload an older excel file, it all works great, but not 2003. Thus my assumption that is has to do with Excel 2003.
I have a script or two that use this reader.php and are being fed older versions of Excel, and like I stated, it works great. I came across this wrinkle when creating a new script and trying to use an excel file I created with 2003. I feed an older excel file to my new script and it works fine. Hmmm!
The reader.php class can be viewed here: http://scripts.ringsworld.com/database-tools/xls2mysql/inc/Excel/reader.php.html
If anyone knows how to get this to work for Excel 2003, I'b be very greatful
Thanks,
johndcowan