Re: Excel Report Formatting

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx>
> To: Php Developer <pdeveloper@xxxxxxxxxxxxxx>; php-general@xxxxxxxxxxxxx
> Sent: Tue, April 20, 2010 1:47:40 PM
> Subject: RE:  Excel Report Formatting
> 
> > -----Original Message-----
> > From: Php Developer [mailto:pdeveloper@xxxxxxxxxxxxxx]
> > Sent: Tuesday, April 20, 2010 9:52 AM
> > To: Tommy Pham; php-general@xxxxxxxxxxxxx
> > Subject: 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 <tommyhp2@xxxxxxxxx>
> > To: Php Developer <pdeveloper@xxxxxxxxxxxxxx>; php-
> > general@xxxxxxxxxxxxx
> > Sent: Tue, April 20, 2010 11:37:21 AM
> > Subject: RE:  Excel Report Formatting
> > 
> > > -----Original Message-----
> > > From: Php Developer [mailto:pdeveloper@xxxxxxxxxxxxxx]
> > > Sent: Tuesday, April 20, 2010 8:30 AM
> > > To: php-general@xxxxxxxxxxxxx
> > > Subject:  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



[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux