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

RE: Excel Report Formatting

> -----Original Message-----
> From: Php Developer [mailto:pdeveloper@rocketmail.com]
> Sent: Tuesday, April 20, 2010 8:30 AM
> To: php-general@lists.php.net
> Subject: [PHP] Excel Report Formatting
>=20
> Hi,
>=20
> 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.
>=20
> Thank you
>=20
>=20
>=20
>=20
> ____________________________________________________________ ______
> Get the name you've always wanted @ymail.com or @rocketmail.com! Go to
> http://ca.promos.yahoo.com/jacko/
>=20
>=20
> --
> 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-Fo rmat-Part-1--=
P155.html


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: Excel Report Formatting

[snip]
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.
[/snip]

STFW or STFA much? This was posted yesterday....

Stupid browser tricks....

http://www.evolt.org/node/26896



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: Excel Report Formatting

> -----Original Message-----
> From: Jay Blanchard [mailto:jblanchard@pocket.com]
> Sent: Tuesday, April 20, 2010 8:40 AM
> To: Php Developer; php-general@lists.php.net
> Subject: RE: [PHP] Excel Report Formatting
>=20
> [snip]
> 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.
> [/snip]
>=20
> STFW or STFA much? This was posted yesterday....
>=20
> Stupid browser tricks....
>=20
> http://www.evolt.org/node/26896
>=20
>=20
>=20
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php


I believe the OP wants to format the excel for download. And not =
display the data in excel like in the web browser.


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: Excel Report Formatting

[snip]I believe the OP wants to format the excel for download. And not
display the data in excel like in the web browser.[/snip]

He didn't specify that, but you can change the code in the article to
save the file and make available for download.=20


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Excel Report Formatting

--001636284828a260770484ade020
Content-Type: text/plain; charset=ISO-8859-1

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

--001636284828a260770484ade020--

Re: 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
To: Php Developer ; php-general@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@rocketmail.com]
> Sent: Tuesday, April 20, 2010 8:30 AM
> To: php-general@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-Fo rmat-Part-1--P155.html

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


--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Excel Report Formatting

--=-BLPmTbVVfyrd4KSJu+Ll
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

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



--=-BLPmTbVVfyrd4KSJu+Ll--

RE: Excel Report Formatting

> -----Original Message-----
> From: Php Developer [mailto:pdeveloper@rocketmail.com]
> Sent: Tuesday, April 20, 2010 9:52 AM
> To: Tommy Pham; php-general@lists.php.net
> Subject: Re: [PHP] Excel Report Formatting
>=20
> Hi Tommy,
>=20
> The code in the link is traightforward. The problem is you need to
> install ADOdb.
>=20
> I'm wondering if there is a way to do it from scratch.
>=20
> Thanks
>=20
>=20
> ----- Original Message ----
> From: Tommy Pham
> To: Php Developer ; php-
> general@lists.php.net
> Sent: Tue, April 20, 2010 11:37:21 AM
> Subject: RE: [PHP] Excel Report Formatting
>=20
> > -----Original Message-----
> > From: Php Developer [mailto:pdeveloper@rocketmail.com]
> > Sent: Tuesday, April 20, 2010 8:30 AM
> > To: php-general@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/
> >
>=20
> http://www.phpeveryday.com/articles/Write-report-in-Excel-Fo rmat-Part-
> 1--P155.html
>=20

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.spreadshee t-excel-write=
r.spreadsheet-excel-writer-format.setfgcolor.php



--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

RE: Excel Report Formatting

[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.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Excel Report Formatting

Hi, somebody knows if it is possible to open excel content in a new window? what i want is basically initialize the headers and instead of echo $content i want it to open in a new window. is that possible?



----- Original Message ----
From: Tommy Pham
To: Php Developer ; php-general@lists.php.net
Sent: Tue, April 20, 2010 1:47:40 PM
Subject: RE: [PHP] Excel Report Formatting

> -----Original Message-----
> From: Php Developer [mailto:pdeveloper@rocketmail.com]
> Sent: Tuesday, April 20, 2010 9:52 AM
> To: Tommy Pham; php-general@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
> To: Php Developer ; php-
> general@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@rocketmail.com]
> > Sent: Tuesday, April 20, 2010 8:30 AM
> > To: php-general@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-Fo rmat-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.spreadshee t-excel-writer.spreadsheet-excel-writer-format.setfgcolor.ph p



--
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

Re: Excel Report Formatting

--=-Pq6DF9fNBrkFyVJ6eTqa
Content-Type: text/plain
Content-Transfer-Encoding: 7bit

On Tue, 2010-04-20 at 12:58 -0700, Php Developer wrote:

> Hi, somebody knows if it is possible to open excel content in a new window? what i want is basically initialize the headers and instead of echo $content i want it to open in a new window. is that possible?
>
>
>
> ----- Original Message ----
> From: Tommy Pham
> To: Php Developer ; php-general@lists.php.net
> Sent: Tue, April 20, 2010 1:47:40 PM
> Subject: RE: [PHP] Excel Report Formatting
>
> > -----Original Message-----
> > From: Php Developer [mailto:pdeveloper@rocketmail.com]
> > Sent: Tuesday, April 20, 2010 9:52 AM
> > To: Tommy Pham; php-general@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
> > To: Php Developer ; php-
> > general@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@rocketmail.com]
> > > Sent: Tuesday, April 20, 2010 8:30 AM
> > > To: php-general@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-Fo rmat-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.spreadshee t-excel-writer.spreadsheet-excel-writer-format.setfgcolor.ph p
>
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>
>


Erm, why?

Wouldn't it be easier to output the table as HTML in a new window?

Excel does have plugins for *some* browsers that allow the browser to
open Excel files within its own window (in that annoying way that PDF's
try to open up within the browser) but this can be turned off by the
user (and I can't imagine many people who wouldn't turn it off tbh) This
is also only available for some browsers on some operating systems, and
you could well be alienating users who don't use Microsoft software.

Are you looking to allow a way for users to edit spreadsheets within
your web app? It's worth considering that this is a huge task. There are
some Javascript-based plugins that you can use to embed spreadsheet-like
data into your web pages, but I think anything more than basic
formatting and data entry is a pipe dream at the moment. The only really
usable web-based spreadsheets I've seen come from the likes of very big
companies like Google and Microsoft.

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



--=-Pq6DF9fNBrkFyVJ6eTqa--

RE: Excel Report Formatting

[snip]
Hi, somebody knows if it is possible to open excel content in a new
window? what i want is basically initialize the headers and instead of
echo $content i want it to open in a new window. is that possible?
[/snip]

Yes, it is possible. Is this too =
obvious?


















My apologies, I am in a funky mood today.

--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php