Re: PHP to Excel?
| From: | 1LT John W. Holmes | Date: | Tue, 18 Jun 2002 16:22:55 +0000 |
| Subject: | Re: PHP to Excel? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-102727@lists.php.net to get a copy of this message | ||
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" <cday@atpco.com>
To: <php-general@lists.php.net>
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:holmes072000@charter.net]
> Sent: Tuesday, June 18, 2002 11:47 AM
> To: Martin Lucas; 'Chad Day'; php-general@lists.php.net
> 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" <martin.lucas@techconsult.de>
> To: "'Chad Day'" <cday@atpco.com>; <php-general@lists.php.net>
> 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:cday@atpco.com]
> > Gesendet: Dienstag, 18. Juni 2002 16:52
> > An: php-general@lists.php.net
> > 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
>