Prev: Directory permissions question
Next: Hello everybody - php newbie from switzerland
From: Dan Joseph on 20 Apr 2010 12:50
Its good to see we're all playing nice today!

--
-Dan Joseph

www.canishosting.com - Unlimited Hosting Plans start @ $3.95/month. Promo
Code "NEWTHINGS" for 10% off initial order

http://www.facebook.com/canishosting
http://www.facebook.com/originalpoetry
From: Php Developer on 20 Apr 2010 12:52
Hi Tommy,

The code in the link is traightforward. The problem is you need to install ADOdb.

I'm wondering if there is a way to do it from scratch.

Thanks


----- Original Message ----
From: Tommy Pham <tommyhp2(a)gmail.com>
To: Php Developer <pdeveloper(a)rocketmail.com>; php-general(a)lists.php.net
Sent: Tue, April 20, 2010 11:37:21 AM
Subject: RE: [PHP] Excel Report Formatting

> -----Original Message-----
> From: Php Developer [mailto:pdeveloper(a)rocketmail.com]
> Sent: Tuesday, April 20, 2010 8:30 AM
> To: php-general(a)lists.php.net
> Subject: [PHP] Excel Report Formatting
>
> Hi,
>
> Do you know if there is a way to generate a formated Excel report.
> I want some rows to be of different colors than the others.
>
> Thank you
>
>
>
>
> __________________________________________________________________
> Get the name you've always wanted @ymail.com or @rocketmail.com! Go to
> http://ca.promos.yahoo.com/jacko/
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php

http://www.phpeveryday.com/articles/Write-report-in-Excel-Format-Part-1--P155.html

__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

From: Ashley Sheridan on 20 Apr 2010 12:59
On Tue, 2010-04-20 at 12:50 -0400, Dan Joseph wrote:

> Its good to see we're all playing nice today!
>


It's still not an excel file but an HTML table sent with an Excel
mime-type. This is just asking for trouble if the user does not use
Excel, as it's exploiting behaviour that looks very particular to Excel
and not ALL spreadsheet software.

Thanks,
Ash
http://www.ashleysheridan.co.uk


From: "Tommy Pham" on 20 Apr 2010 13:47
> -----Original Message-----
> From: Php Developer [mailto:pdeveloper(a)rocketmail.com]
> Sent: Tuesday, April 20, 2010 9:52 AM
> To: Tommy Pham; php-general(a)lists.php.net
> Subject: Re: [PHP] Excel Report Formatting
>
> Hi Tommy,
>
> The code in the link is traightforward. The problem is you need to
> install ADOdb.
>
> I'm wondering if there is a way to do it from scratch.
>
> Thanks
>
>
> ----- Original Message ----
> From: Tommy Pham <tommyhp2(a)gmail.com>
> To: Php Developer <pdeveloper(a)rocketmail.com>; php-
> general(a)lists.php.net
> Sent: Tue, April 20, 2010 11:37:21 AM
> Subject: RE: [PHP] Excel Report Formatting
>
> > -----Original Message-----
> > From: Php Developer [mailto:pdeveloper(a)rocketmail.com]
> > Sent: Tuesday, April 20, 2010 8:30 AM
> > To: php-general(a)lists.php.net
> > Subject: [PHP] Excel Report Formatting
> >
> > Hi,
> >
> > Do you know if there is a way to generate a formated Excel report.
> > I want some rows to be of different colors than the others.
> >
> > Thank you
> >
> >
> >
> >
> > __________________________________________________________________
> > Get the name you've always wanted @ymail.com or @rocketmail.com! Go
> to
> > http://ca.promos.yahoo.com/jacko/
> >
>
> http://www.phpeveryday.com/articles/Write-report-in-Excel-Format-Part-
> 1--P155.html
>

I think the article/sample uses PEAR's Excel Writer.

http://pear.php.net/package/Spreadsheet_Excel_Writer/
http://pear.php.net/manual/en/package.fileformats.spreadsheet-excel-writer.spreadsheet-excel-writer-format.setfgcolor.php


From: "Jay Blanchard" on 20 Apr 2010 14:34
[snip]
It's still not an excel file but an HTML table sent with an Excel
mime-type. This is just asking for trouble if the user does not use
Excel, as it's exploiting behaviour that looks very particular to Excel
and not ALL spreadsheet software.
[/snip]

This is true, it is exploiting behavior that is particular to Excel. I
was able to do this with Open Office too, even though I didn't fully
bake the code for that.

The article is pretty old and there are other tools that would probably
work a lot better, but the OP asked about Excel and coloring.
First  |  Prev  |  Next  |  Last
Pages: 1 2 3
Prev: Directory permissions question
Next: Hello everybody - php newbie from switzerland