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
