Anyway, I tried changing
Header("Content-Disposition: attachment; filename='stats.xls'");
to
Header("Content-Disposition: inline; filename='stats.xls'");
without adding any of your other changes but I got the same icon in the corner. I'm using IE 6.
-Lisi
At 09:46 AM 2/25/03 +0000, George Pitcher wrote:
Lisi,
This is a modification of a script I use to download pdfs.
It might just work
<?php
$fpd = "E:\\MyFolder\\" . $fp . ".xls"; // where the file is
$len = filesize($fpd);
header("Content-Type: application/vnd.ms-excel");
header("Content-Disposition: inline; filename=$fpd");
header("Content-Title: $fpd");
header("Content-Length: $len");
readfile($fpd);
?>
George
> -----Original Message-----
> From: Lisi [mailto:lists@shemeshdirectory.co.il]
> Sent: 25 February 2003 9:41 am
> To: PHP-DB
> Subject: Reporting tool for stats pulled from MySQL db
>
>
> I have a stats tracking program and a page that displays stats
> for various
> dates/items depending on what options the user selects. I need to
> add some
> kind of external reporting tool, i.e. they'd like to download the
> information, preferably in Excel.
>
> I tried forcing Excel to open the data instead of the browser by sending
> headers:
>
> Header("Content-Type: application/vnd.ms-excel");
> Header("Content-Disposition: attachment; filename='stats.xls'");
>
> When I sent just the first one, all I got was a blank broswer page with a
> picture (application?) icon in the top left hand corner. Then I added the
> second header, which I found in a previous post in the archives, and that
> forced a download but of the page itself (stats_print.php).
>
> 1) What am I doing wrong?
>
> 2) Every posting I found in the archives said this is the easiest way. Is
> there another, harder but might work for me, way anyone would suggest of
> doing this?
>
> Thanks in advance,
>
> -Lisi
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
