读出数据库的数据生成一个EXCEL文件存于服务器上，需要下载的时候再下载
哪们知道怎么做吗？
用下面的这种方法，一打开页面就提示下载，我不想这样
1
2header("Content-type:application/vnd.ms-excel");
3header("Content-Disposition:filename=test.xls");
---------------------------------------------------------------
1
2
3$result = mysql_query('select * from 表名');
4$count = mysql_num_fields($result);
5
6for ($i = 0; $i < $count; $i++){
7$header .= mysql_field_name($result, $i)."\t";
8}
9
10while($row = mysql_fetch_row($result)){
11$line = '';
12foreach($row as $value){
13if(!isset($value) ¦ ¦ $value == ""){
14$value = "\t";
15}else{
16
17$value = str_replace('"', '""', $value);
18$value = '"' . $value . '"' . "\t";
19}
20$line .= $value;
21}
22$data .= trim($line)."\n";
23}
24
25$data = str_replace("\r", "", $data);
26
27if ($data == "") {
28$data = "\nno matching records found\n";
29}
30
31header("Content-type: application/octet-stream");
32header("Content-Disposition: attachment; filename=excelfile.xls");
33header("Pragma: no-cache");
34header("Expires: 0");
35
36echo $header."\n".$data;
37