Does anyone know of a good script where you can:
Read Data from a MS Excel File
Put the data from the MS Excel File into a MySQL Database
Thanks
Ben
Excel and PHP
Moderator: General Moderators
-
jollyjumper
- Forum Contributor
- Posts: 107
- Joined: Sat Jan 25, 2003 11:03 am
Haven't tried this myself, but the description I've read looks promising.
http://www.phpclasses.org/browse/package/1919.html
http://www.phpclasses.org/browse/package/1919.html
Microsoft Excel is one of the most popular applications for desktop users, especially as a business work tool. Therefore the generation of spreadsheets in the Excel XLS format is a frequently used feature of Web applications to provide information in a way that lets their users do their work using Excel.
There have always been plenty of solutions to generate spreadsheet files in the XLS format. However, this class provide an innovating approach to the problem of generating XLS files.
This class takes advantage of the stream wrapping capabilities introduced in PHP 4.3 to let applications create XLS files just by using common file handling functions, making the generation of this type of files a trivial task.
-
ibizconsultants
- Forum Commoner
- Posts: 35
- Joined: Tue Sep 07, 2004 12:07 pm
You could use this:
http://phpclasses.comrax.com/browse/package/1808.html
If you wish to design your own PHP XLS reader module, this could be useful
http://chicago.sourceforge.net/devel/docs/excel/
Hope this helps
http://www.ibizconsultants.com
http://phpclasses.comrax.com/browse/package/1808.html
If you wish to design your own PHP XLS reader module, this could be useful
http://chicago.sourceforge.net/devel/docs/excel/
Hope this helps
http://www.ibizconsultants.com
I'll have a lookibizconsultants wrote:You could use this:
http://phpclasses.comrax.com/browse/package/1808.html
If you wish to design your own PHP XLS reader module, this could be useful
http://chicago.sourceforge.net/devel/docs/excel/
Hope this helps
http://www.ibizconsultants.com
Yup http://phpclasses.comrax.com/browse/package/1808.html works great