Re: Excel Report Formatting

On Tue, Apr 20, 2010 at 1:00 PM, Ashley Sheridan <ash@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@gmail.com> > To: Php Developer <pdeveloper@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: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 <tommyhp2@gmail.com> > > To: Php Developer <pdeveloper@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: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-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 ;)