Click here to get back home

MySQL -> PHP -> MS Excel?

 Home | NewsGroups | Search
Login Password
Register Now! Lost Password?

comp.lang.php - PHP programming language discussions 
get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content
Subject Author Date
MySQL -> PHP -> MS Excel? me 11-25-2008
Posted by Rob on November 27, 2008, 4:10 am
Please log in for more thread options
show/hide quoted text

Although I couldn't recommend a specific component, I've used many of
the classes from http://www.phpclasses.org/browse/ and found them to
be reasonably good.

Rob.

Posted by Anthony Papillion on November 29, 2008, 3:49 pm
Please log in for more thread options
show/hide quoted text

Unfortunately, there are a lot of solutions out there but none of them
don't feel like a hack and none of them are as robust as you'd
probably like. If you're on Windows, you can probably connect to
Excel from PHP via COM but I don't know of an easy/simple way to do it
on Linux. Maybe if you're open to a 2-step solution, you could write a
connector in C# using Mono then feed XML or regular text data to it
and have IT create the Excel file.

Like I said, nothing clean and robust unfortunately.

Anthony Papillion
www.messengerboy.net
www.openemrhq.com

Similar ThreadsPosted
Excel to MySQL through PHP? April 1, 2006, 4:27 pm
MySQL as Excel? February 3, 2009, 6:50 pm
Export mysql data to excel? March 10, 2008, 6:03 am
Exporting MySQL Data to Excel using PHP January 5, 2009, 10:18 am
Import Excel file into MySQL database September 3, 2004, 2:27 am
Reading Excel to MySql or Comma delimited ... June 14, 2006, 6:44 pm
PHP (mysql) to Excel, Word and PDF and other report formats May 2, 2009, 4:52 am
PHP / MySQL to Excel - good library recommendation? May 18, 2009, 7:24 am
uploading special characters from excel to mysql and php binary/Image June 17, 2008, 10:47 am
PHP COM Excel Obj May 31, 2006, 7:06 pm

Our other projects:

Art Dolls, Fairies and Mermaids - Sunnyfaces.net

Driving a better car - Fuelzilla.com

Cabling site for homeowners and pros alike - Cabling-Design.com

Friends:

Roy's Linux, Programming and Search Engines messages

1-Script XML SitemapXML Sitemap
Privacy Policy