[PHP] Header Information for Formatting?

2002-05-02 Thread Jay Blanchard

G' morning!

Can someone tell me where to find the various options for the Header
function as it relates to M$ Excel? Yesterday, thanks to this list, we found
a way to open a worksheet in the browser and display data retrieved from a
database. The worksheet opens with no gridlines and displaying zero values,
I would like to see gridlines and no zero values. Are there options that can
be placed in the header function. I have looked at MSDN and did a Google
search that did not reveal much of anything.

Here is the header info being used...

header(Content-Type:  application/x-excel);
header(Content-Disposition: inline; filename=\excel.xls\);
header(Expires: 0);
header(Cache-Control: must-revalidate, post-check=0, pre-check=0);

Thanks!

Jay Blanchard



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




Re: [PHP] Header Information for Formatting?

2002-05-02 Thread Jason Wong

On Thursday 02 May 2002 21:05, Jay Blanchard wrote:
 G' morning!

 Can someone tell me where to find the various options for the Header
 function as it relates to M$ Excel? Yesterday, thanks to this list, we
 found a way to open a worksheet in the browser and display data retrieved
 from a database. The worksheet opens with no gridlines and displaying zero
 values, I would like to see gridlines and no zero values. Are there options
 that can be placed in the header function. I have looked at MSDN and did a
 Google search that did not reveal much of anything.

 Here is the header info being used...

 header(Content-Type:  application/x-excel);
 header(Content-Disposition: inline; filename=\excel.xls\);
 header(Expires: 0);
 header(Cache-Control: must-revalidate, post-check=0, pre-check=0);

M$ Excel is not a browser (not yet anyway, and hopefully it doesn't evolve 
into one), thus http headers are not pertinent to how Excel displays it's 
data. Try fiddling with Excel's display options.

-- 
Jason Wong - Gremlins Associates - www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design  Hosting * Internet  Intranet Applications Development *

/*
marriage, n.:
Convertible bonds.
*/

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