Re: Excel export problem
- From: "subrato" <mukherjeesubrato@xxxxxxxxx>
- Date: 31 May 2006 09:18:15 -0700
I tried to use the header you specified! Does not work as before.!!
DonO wrote:
I use...
header("Content-Type: application/vnd.ms-excel; name='excel'");
header("Content-disposition: attachment; filename="
.date("Y-m-d").".xls");
and it works, but I have to either save the file and open it later in
excel, or excel has to be already open for it to open from the link.
I did notice you had...
require_once("${HTTP_SERVER_VARS['DOCUMENT_ROOT']}/conf/config.ph");
(no "p" at the end of config.ph)
Not sure if that's causing you a problem, or if it was just a typo in
your submission. Let me know if that doesn't work.
D.
subrato wrote:
Hi,
I have this script to export mysql data to excel. I have tried
everything but I am not able to get this script to work for IE. The
script downloads the data using Mozilla or Netscape but it fails and
says
Internet Explorer cannot download export.php from "IP Address" (this is
the IP on which the file resides). Internet Explorer was not able to
open this Internet site. The requested site is either unavailable or
cannot be found. Please try again later.
If I remove the header("Content-type: application/vnd.ms-excel;
name='excel'"); then it outputs the database values on the page even
using IE . Not sure what is wrong with the script.
<?php
header("Content-type: application/vnd.ms-excel; name='excel'");
header("Content-Disposition: filename=export.xls");
header("Pragma: no-cache");
header("Expires: 0");
require_once("${HTTP_SERVER_VARS['DOCUMENT_ROOT']}/conf/config.ph");
$query = "Select * from table";
$result = mysql_query($query) or die (mysql_error());
$fields=mysql_num_fields($result);
for ($i=0;i<$fields;$++i)
{
$header .= mysql_field_name($result,$i) . "\t";
}
while($row = mysql_fetch_row($result))
{
$line = '';
$count=0;
foreach($row as $value)
{
if ($count ==15)
{
if ($value == 1)
{ $line .= "Yes" . "\t";}
else
{ $line .="No" . "\t"; }
}
else
{
if((!isset($value) OR ($value==""))
{
$value = "\t";
}
else
{
$value = str_replace('"', '""', $value);
$value = '"' . stripslashes($value) . '"'
. "\t";
}
$line .= $value;
}
$count ++;
}
$data . =trim($line) . "\n";
}
$data = str_replace("\r", " ", $data);
if ($data=="")
{
$data = "\n No records found\n";
}
echo "$header\n$data\n";
mysql_free_result($result);
?>
This is the whole script. Not sure if the script is wrong somewhere or
what.
Any help is appreciated
Thanks
Subrato
.
- References:
- Excel export problem
- From: subrato
- Re: Excel export problem
- From: DonO
- Excel export problem
- Prev by Date: Re: Excel export problem
- Next by Date: Which array declaration is better?
- Previous by thread: Re: Excel export problem
- Next by thread: Re: Excel export problem
- Index(es):
Relevant Pages
|
