Exporting Data to EXCEL using IE

[raj_sv23]

Hi,
I am trying to download data from an Oracle database into an excel file. So I have my php like the following...

.....
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=$table.xls");
header("Pragma: no-cache");
header("Cache-Control:");
header("Expires: 0");
print "$header\n$data";

This works just fine in FireFox 1.0 browser however it doesn't work in IE 6.0 on XP (no service pack 2). In IE it is trying to download the php file that contains the above code and it fails with the error message "Internet Explorer can't download xyz.php file from <servername> ".

Any help in resolving this issue will be appreciated.

Thanks,
Raj

[Frederick]

This is what I use and it never fails

<?php 
header("Content-Type: application/octet-stream\n"); 
header("Content-Disposition: filename=\"my_excel_sheet.xls\""); 
header("Content-transfer-encoding: binary\n"); 

print("Employee List\r"); 
print("Employee SSN\t Employee Name\r"); 

$sql = "select * from employees order by employee_ssn"; 
$result = mysql_query($sql); 
while($row = mysql_fetch_array($result)) { 
    $ssn = $row["ssn"]; 
    $name = $row["name"]; 
    print("$ssn\t $name\r"); 
} 
?>

[raj_sv23]

If I comment the
header("Pragma: no-cache");

line, it works fine in IE.

Thanks for your help.

Raj