While not directly involving PHP, you certainly open up a database table in
Excel, just create it as a pivot table or data import from a DSN. You can
create spreadsheets based on specific SQL queries and table joins, that
Excel will work happily with.
Hope this helps!
Best regards,
Andrew
---------------------------------------
Andrew Hill - OpenLink Software
Director Technology Evangelism
eBusiness Infrastructure Technology
http://www.openlinksw.com
On 3/14/01 9:28 PM, "Jason Murray" <[EMAIL PROTECTED]> wrote:
>> Could anyone help me out with how to print the entire contents of a
>> database as an Excel file? I'm familiar with the header:
>>
>> header("Content-Type: application/vnd.ms-excel");
>>
>> just not sure how to go about it beyond that. I have this code and
>> am not sure what do do after it. Thanks.
>
> Excel spreadsheets are in a proprietary format as far as I know.
>
> However, if you output the database one line = one row, and tab delimit
> the lines, Excel will notice you're importing a text file and give you
> some appropriate options (select delimiter, etc).
>
> I'd go for tab delimiting over comma delimiting, since your text fields
> will probably contain commas but will *very* *exceedingly* rarely have
> tabs.
>
> I've ripped some code out of phpMyAdmin to do this (ta Tobias, if you're
> watching ;)) - I can post it if you want to.
>
> Jason
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
