On 8 November 2011 18:31, Ron Piggott ron.pigg...@actsministries.org wrote:
What is the preferred method used to export mySQL to Excel within the context
of PHP? I have looked on Google and found a wide variety of options. Ron
Ron Piggott
If the mysql server is set to allow remote access,
To: Ron Piggott
Cc: php-db@lists.php.net
Subject: Re: [PHP-DB] Exporting mySQL to Excel
The best option I've found is to write to a file that is then sent to
the browser for download. Are there others? Yes but that's the one
I've had the best experience with. It seems to work reliably regardless
The problem you are describing is where the fields are not enclosed in
quotes. Are you specifying to enclose alpha type fields in quotes, and
leaving number-only fields without?
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Thu, Nov 10, 2011 at 12:32 AM, Ron Piggott
ron.pigg...@actsministries.org wrote:
I am wondering how phpmyadmin makes Excel files on the fly --- Is it a
class?
They used PHPExcel in the past, but they had to remove because of
license issues. Don't know what they're currently using, but if
On 9 November 2011 23:52, Matijn Woudt tijn...@gmail.com wrote:
On Thu, Nov 10, 2011 at 12:32 AM, Ron Piggott
ron.pigg...@actsministries.org wrote:
I am wondering how phpmyadmin makes Excel files on the fly --- Is it a
class?
They used PHPExcel in the past, but they had to remove because
What is the preferred method used to export mySQL to Excel within the context
of PHP? I have looked on Google and found a wide variety of options. Ron
Ron Piggott
www.TheVerseOfTheDay.info
On Tue, Nov 8, 2011 at 1:33 PM, Bastien Koert phps...@gmail.com wrote:
On Tue, Nov 8, 2011 at 1:31 PM, Ron Piggott
ron.pigg...@actsministries.org wrote:
What is the preferred method used to export mySQL to Excel within the
context of PHP? I have looked on Google and found a wide variety of
] Exporting mySQL to Excel
On Tue, Nov 8, 2011 at 1:33 PM, Bastien Koert phps...@gmail.com wrote:
On Tue, Nov 8, 2011 at 1:31 PM, Ron Piggott
ron.pigg...@actsministries.org wrote:
What is the preferred method used to export mySQL to Excel within the
context of PHP? I have looked on Google and found
The best option I've found is to write to a file that is then sent to
the browser for download. Are there others? Yes but that's the one
I've had the best experience with. It seems to work reliably regardless
of browser or version of Office or any thing else.
HTH!
On Tue, 2011-11-08 at
CSV is probably the least bloated. IMHO.
But I guess it depends on what your trying to get as an end result.
Best,
Karl
On Nov 8, 2011, at 3:59 PM, Jimi Thompson wrote:
The best option I've found is to write to a file that is then sent to
the browser for download. Are there others? Yes but
10 matches
Mail list logo