-Original Message-
You can use
table
tr
td
and each tr becomes an excel row and each td becomes a cell. This may or
may not work in/before excel97??
If you're looking to create true excel files, then i highly suggest
spreadsheetwrite_excel,
It is an
Hi there everyone,
I'm having a dilemma (Now that I have power back after the hurricane hit us
directly in Orlando). Anyway, I need to export a database table to Excel, I
can do it as a .txt file without a problem, but I can't seem to get it to
put each column into a separate cell when I try
I'm having a dilemma (Now that I have power back after the hurricane hit us
directly in Orlando). Anyway, I need to export a database table to Excel, I
can do it as a .txt file without a problem, but I can't seem to get it to
put each column into a separate cell when I try to export as an
You could always use phpMyAdmin...I believe it will export to Excel
(if not, CSV file).
http://phpmyadmin.sourceforge.net/
On Tue, 17 Aug 2004 15:36:49 -0400, Chris Payne
[EMAIL PROTECTED] wrote:
Hi there everyone,
I'm having a dilemma (Now that I have power back after the hurricane hit us
-Original Message-
either output the data as a csv which you are doing (on windoze name
the file with a .csv extension) or take a look at
http://pear.php.net/package/Spreadsheet_Excel_Writer
I have another option that might work for you also. Go to MySQL's website
and grab their ODBC
I have another option that might work for you also. Go to MySQL's website
and grab their ODBC driver and use that to pull data directly into Excel.
That's what I do and the end result tends to be a lot cleaner than going
through cvs or other MySQL exports.
I was not sure that this was a
I have another option that might work for you also. Go to MySQL's website
and grab their ODBC driver and use that to pull data directly into Excel.
That's what I do and the end result tends to be a lot cleaner than going
through cvs or other MySQL exports.
I was not sure that this was
I don't know how you have it setup.
But you can create a XLS file on the fly using PHP
By using header...
header(Content-Type: application/vnd.ms-excel);
header(Content-Dispostion: attachemnt; filename='Project.xls');
header(Pragma: no-cache);
header(Expires: 0);
Then just echo your results
-Original Message-
From: Daniel Brunner [mailto:[EMAIL PROTECTED]
Sent: Tuesday, August 17, 2004 2:45 PM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL to EXCEL?
I don't know how you have it setup.
But you can create a XLS file on the fly using PHP
By using header
I don't know how you have it setup.
But you can create a XLS file on the fly using PHP
By using header...
header(Content-Type: application/vnd.ms-excel);
header(Content-Dispostion: attachemnt; filename='Project.xls');
header(Pragma: no-cache);
header(Expires: 0);
Then just
10 matches
Mail list logo
