The time now is Fri Jul 04, 2008 8:39 pm
All times are GMT
|
jdc44
Joined: 11 Jan 2006 Posts: 1 Location: Ithaca NY
|
Posted: Wed Jan 11, 2006 4:11 pm Post subject:
reader.php
Subject description: How to get updated script
|
|
|
I'm using a script: 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. All numbers are displayed to my webpage as zeros. If I upload an older excel file, it works great, but not 2003.
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
|
|
| Back to top |
|
 |
|
|
Posted: Thu Jan 12, 2006 10:59 am Post subject:
Re: reader.php
Subject description: How to get updated script
|
|
|
Hello jdc44
| jdc44 wrote: | | If anyone knows how to get this to work for Excel 2003, I'b be very greatful |
I don't know if it can help but I found this other PHP reader :
http://sourceforge.net/projects/phpexcelreader
in the documentation : http://sourceforge.net/docman/display_doc.php?docid=22092&group_id=99160
| Quote: | PHP-ExcelReader is a PHP class for reading the contents of Excel xls files. It used to require the OLE package but does not need to run on a windows platform. You could also find the OLE package here.
Starting before version 2i, the oleread.inc file is included with the PHP ExcelReader distribution, so it is no longer necessary to have the OLE package available.
/.../
PHP-ExcelReader only supports BIFF7 and BIFF8 format files, which should include Excel95 up through Excel 2003. Not included would be Excel 5.0 and earlier. Actually, Excel XP and Excel 2003 use BIFF8X format which is an extension of the BIFF8 format. Whatever features are added by Excel XP/2003 are probably not supported by PHP-ExcelReader. Otherwise it will work just as well on Excel XP/2003 files. |
Hope it can help,
|
|
| Back to top |
|
 |
|
|
Posted: Tue Jul 18, 2006 4:25 am Post subject:
Re: reader.php
Subject description: How to get updated script
|
|
|
| jdc44 wrote: | I'm using a script: 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. All numbers are displayed to my webpage as zeros. If I upload an older excel file, it works great, but not 2003.
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 |
|
|
| Back to top |
|
 |
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
| Link to this Page |
|
If you want to link to this page you can use the following URL:
Example:
|
|
| The PHP Web-Ring Community
Sign-up to receive daily news on PHP by email.
|
|