Force .xls download

[travisbrown]

How does one force an .xls download of a table in php? I have a tab-delimited text file that I need to open as an excel. I'm not sure how one writes headers with PHP.

<?php 
$file = "registrants.txt";
$fp=fopen($file,'r');
$content=fread($fp,filesize($file));
fclose($fp);

$content = "<table><tr><td>".$content."</td></tr></table>";
$content = str_replace(chr(10),"</td</tr><tr><td>",$content);
$content = str_replace(chr(9),"</td><td>",$content);

echo $content;
?>

 

[dkdude]

This gives the user the option to open or save a comma seperated volume:

<?php
header('Content-type: application/excel');
header('Content-Disposition: attachment; filename="downloaded.csv"');
readfile('my.csv');
?>

Regards