Re: Header Information for Formatting?

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. */