RE: [PHP] Excel Report Formatting
-Original Message- From: Php Developer [mailto:pdevelo...@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-Format-Part-1--P155.html -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] 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: [PHP] Excel Report Formatting
-Original Message- From: Jay Blanchard [mailto:jblanch...@pocket.com] Sent: Tuesday, April 20, 2010 8:40 AM To: Php Developer; php-general@lists.php.net Subject: RE: [PHP] 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 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: [PHP] 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. -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Excel Report Formatting
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
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 tommy...@gmail.com To: Php Developer pdevelo...@rocketmail.com; 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:pdevelo...@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-Format-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: [PHP] Excel Report Formatting
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
RE: [PHP] Excel Report Formatting
-Original Message- From: Php Developer [mailto:pdevelo...@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 tommy...@gmail.com To: Php Developer pdevelo...@rocketmail.com; php- gene...@lists.php.net Sent: Tue, April 20, 2010 11:37:21 AM Subject: RE: [PHP] Excel Report Formatting -Original Message- From: Php Developer [mailto:pdevelo...@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-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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP] 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: [PHP] 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 tommy...@gmail.com To: Php Developer pdevelo...@rocketmail.com; 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:pdevelo...@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 tommy...@gmail.com To: Php Developer pdevelo...@rocketmail.com; php- gene...@lists.php.net Sent: Tue, April 20, 2010 11:37:21 AM Subject: RE: [PHP] Excel Report Formatting -Original Message- From: Php Developer [mailto:pdevelo...@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-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 -- 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: [PHP] Excel Report Formatting
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 tommy...@gmail.com To: Php Developer pdevelo...@rocketmail.com; 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:pdevelo...@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 tommy...@gmail.com To: Php Developer pdevelo...@rocketmail.com; php- gene...@lists.php.net Sent: Tue, April 20, 2010 11:37:21 AM Subject: RE: [PHP] Excel Report Formatting -Original Message- From: Php Developer [mailto:pdevelo...@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-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 -- 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
RE: [PHP] 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. a href= target=_blank 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
Re: [PHP] Excel Report Formatting
On Tue, Apr 20, 2010 at 1:00 PM, Ashley Sheridan a...@ashleysheridan.co.uk wrote: 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 tommy...@gmail.com To: Php Developer pdevelo...@rocketmail.com; 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:pdevelo...@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 tommy...@gmail.com To: Php Developer pdevelo...@rocketmail.com; php- gene...@lists.php.net Sent: Tue, April 20, 2010 11:37:21 AM Subject: RE: [PHP] Excel Report Formatting -Original Message- From: Php Developer [mailto:pdevelo...@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-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 -- 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 If you're looking for something like Google's spreadsheet document capability, you got a LOT of work of you ;) -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php