In that case, here's a function I use to set an Excel header.
##############################################
#
# Creates headers to send MS Excel file
#
##############################################
function COM_ExcelHeader($filename = "download")
{
//MS Excel Headers
header("Content-Type: application/vnd.ms-excel; name='excel'");
header("Content-Disposition: attachment; filename=" . $filename .
".xls");
}
---John Holmes...
----- Original Message -----
From: "Chad Day" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, June 18, 2002 11:40 AM
Subject: RE: [PHP] PHP to Excel?
> Annoying doesn't begin to describe it.
>
> I'm going with the HTML/Excel Header bit, since Biffwriter costs way too
> much for a for-profit business to use. Thanks anyway.. looks pretty neat,
> and I'll probably use it for some other projects I do.
>
> Thanks,
> Chad
>
> -----Original Message-----
> From: 1LT John W. Holmes [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, June 18, 2002 11:47 AM
> To: Martin Lucas; 'Chad Day'; [EMAIL PROTECTED]
> Subject: Re: [PHP] PHP to Excel?
>
>
> The layout on that site is so annoying. Yeah, it looks pretty, but it's
> annoying. It's PHP2Excel BiffWriter that your looking for on that site.
> Should be one of the topics when you expand the central "dot" (after you
> close the "news' popup). annoying...
>
> Like someone else said, I just use HTML and send an Excel header(). Works
> great and it's perfect for simple stuff. I'll probably move to PHP2Excel
> BiffWriter eventually, though.
>
> ---John Holmes...
> ----- Original Message -----
> From: "Martin Lucas" <[EMAIL PROTECTED]>
> To: "'Chad Day'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
> Sent: Tuesday, June 18, 2002 11:24 AM
> Subject: AW: [PHP] PHP to Excel?
>
>
> hi chad,
>
> on http://www.cnovak.com/ you'll find a php-class that generates native
> excel-files, even with cell formatings and other more or less useful
things.
>
>
> greetings
>
> martin
>
> > -----Ursprüngliche Nachricht-----
> > Von: Chad Day [mailto:[EMAIL PROTECTED]]
> > Gesendet: Dienstag, 18. Juni 2002 16:52
> > An: [EMAIL PROTECTED]
> > Betreff: [PHP] PHP to Excel?
> >
> >
> > I'm trying to get data from my MySQL database into Excel
> > using PHP. I know
> > and I am doing it right now by generating a CSV file, but is
> > there any way I
> > can do formatting, like make certain cells bold, etc etc? Is
> > there a list
> > of codes somewhere I can use to put before my field output to
> > make a field
> > bold, stuff like that?
> >
> > Thanks,
> > Chad
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
