PHP生成Excel,然后另存为的方法

上一篇 / 下一篇  2009-04-17 14:13:49 / 个人分类:PHP

1.以下方法是直接下载(显示另存为)一个test1.xls的Excel表。

<?
header("Content-type:application/xls");
header("Content-Disposition:attachment;filename=test1.xls");

echo "test1\t";
echo "test2\t\n";
echo "test1\t";
echo "test2\t\n";
echo "test1\t";
echo "test2\t\n";
echo "test1\t";
echo "test2\t\n";
echo "test1\t";
echo "test2\t\n";
echo "test1\t";
echo "test2\t\n";
?>

2.下面是直接在IE中打开Excel表的header

<?
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:filename=test.xls");

echo "test1\t";
echo "test2\t\n";
echo "test1\t";
echo "test2\t\n";
echo "test1\t";
echo "test2\t\n";
echo "test1\t";
echo "test2\t\n";
echo "test1\t";
echo "test2\t\n";
echo "test1\t";
echo "test2\t\n";
?>


TAG:

 

评分:0

我来说两句

显示全部

:loveliness: :handshake :victory: :funk: :time: :kiss: :call: :hug: :lol :'( :Q :L ;P :$ :P :o :@ :D :( :)

关于作者