php页面表格，加一导入按钮，点击可以将表格导出为Excel 文件的代码

参考这页：

http://topic.csdn.net/u/20090503/23/8c835206-c106-4d83-b841-73930d574276.html

有心得，组合后成这样，可以使用。

<?php

include("../../config.php");

include("../head.php");

include("../../fuction.php");

if ($_REQUEST['opt'] == "export")

{

    //导出的操作

echo "exporting...";

$file_type = "vnd.ms-excel";

$file_ending = "xls";

header("Content-Type: application/$file_type;charset=utf-8");

header("Content-Disposition: attachment; filename=mydowns.$file_ending");

header("Pragma: no-cache");

header("Expires: 0");

echo 'test    test2    test3';//用tab键分开好了

}

?>

<script>

function exportcsv()

{

    if(confirm('确认导出吗？')){

        f_export.opt.value='export';

    }

    else{

        f_export.opt.value='search';

    }

    f_export.submit();

}

</script>

<form name="f_export" method="post">

<table border="1">

<tr>

<td>id</td>

<td>name</td>

<td>date</td>

</tr>

<?php

for ($i=0; $i<10; $i++)

{

?>

<tr><td><?php echo $i;?></td><td>aa</td><td>2009-09-09</td></tr>

<?php

}

?>

<tr></tr>

</table>

<input type="button" οnclick="exportcsv();" value="export">导出为Excel文件

<input type="hidden" name="opt" value="">

</form>

然后与自己的代码结合，成下面这样，一样好用：

<?php

include("../../config.php");

include("../head.php");

include("../../fuction.php");

if ($_REQUEST['opt'] == "export")

{

    //导出的操作

echo "exporting...";

$file_type = "vnd.ms-excel";

$file_ending = "xls";

header("Content-Type: application/$file_type;charset=utf-8");

header("Content-Disposition: attachment; filename=mydowns.$file_ending");

header("Pragma: no-cache");

header("Expires: 0");

echo 'test    test2    test3';//用tab键分开好了

}

?>

<script>

function exportcsv()

{

    if(confirm('确认导出吗？')){

        f_export.opt.value='export';

    }

    else{

        f_export.opt.value='search';

    }

    f_export.submit();

}

</script>

<form name="f_export" method="post">

<!--替换代码开始-->

<?php

$sql = 'SELECT a.`id`,a.`dwbh`,b.`dwname`,a.`xd`,a.`gg`,a.`fzr` FROM `dw_base` as a,`dw_base` as b where `a`.`dwbh`=`b`.`dwbh` ORDER BY  a.`id` ASC';

      $result=mysql_query($sql);

      $row=mysql_fetch_row($result);

     if(!empty($row)){

 ?>

<center>

      <h2>“员工荣誉”单位列表</h2><table border=1 bordercolor=#999999 cellspacing=0 cellpadding=4>

      <tr>

      <th><center>本页序号</center></th><th><center>识别id</center></th>

      <th>学校编号</th><th><center>单位名称</center></th><th><center>类别</center></th><th><center>规格</center></th><th><center>负责人</center></th><th><center>&nbsp;概况&nbsp;</center></th>

      </tr>

 <?php

     $query=mysql_query($sql);

$id=0;

      while($row=mysql_fetch_row($query))

      {

       $id++;

      echo"<tr><td>$id</td>";

      foreach($row as $value)

      {

      echo"<td>&nbsp;$value&nbsp;</td>";

      }

?>

<td align="center"><a href="list_school1.php?id=<?php echo $row[0]?>&dwbh=<?php echo $row[1]?>">概况</a></td>

<?php

//开始

      echo"</tr>";

      }

     echo"</table>";

//     echo"</center>";

    }

    else

    {

    echo"<center><font size=4 color=blue>查询失败，没有找到相关信息！</font></center>";

    }

//结束

?>

<br/>

注意：一旦增加了某单位，就不要再修改其“单位编号”，否则可能引起不正确的统计结果！

<br/>

<?php

include_once("../footer.inc");

?>

</center>

<!--替换代码结束-->

<input type="button" οnclick="exportcsv();" value="export">导出为Excel文件

<input type="hidden" name="opt" value="">

</form>