Excel Report Formatting
in [General]
|
From: Php Developer on 20 Apr 2010 15:58 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 <tommyhp2(a)gmail.com> To: Php Developer <pdeveloper(a)rocketmail.com>; php-general(a)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(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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
From: Ashley Sheridan on 20 Apr 2010 16:00 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 <tommyhp2(a)gmail.com> > To: Php Developer <pdeveloper(a)rocketmail.com>; php-general(a)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(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 > > > > -- > 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
From: "Jay Blanchard" on 20 Apr 2010 16:56 [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.
From: Tommy Pham on 20 Apr 2010 19:38 On Tue, Apr 20, 2010 at 1:00 PM, Ashley Sheridan <ash(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 <tommyhp2(a)gmail.com> > To: Php Developer <pdeveloper(a)rocketmail.com>; php-general(a)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(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 > > > > -- > 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 ;)
First
|
Prev
|
Pages: 1 2 3 Prev: Directory permissions question Next: Hello everybody - php newbie from switzerland |