php导出excel_PHP_编程开发_程序员俱乐部

  /**
     * @param string $filname             //输出的文件名
     * @param string $type                //编码类型
     * @param string $array              //excel的标题
     * @param string $data               //需要的数据data
     **/
    function exportExcel($filname, $type = 'utf-8', $array, $data) {
        if (empty ($data)) {
            echo "<script>alert('sorry,no data!');history.go(-1);</script>";
            exit;
        }
        $filname = iconv("utf-8", "gb2312", $filname);
        header("Content-type:application/vnd.ms-excel;");
        header("Content-Disposition:attachment;filename=$filname.xls");
        echo "<META HTTP-EQUIV='Content-Type' CONTENT='text/html;charset=$type'>";
        echo '<table border="1" cellspacing="1" cellpadding="1"><tr align="center">';
        foreach ($array as $val) {
            echo "<td width='100'>$val</td>";
        }
        echo '</tr>';
        foreach ($data as $val) {
            if(is_array($val)){
                echo '<tr align="center">';
                foreach ($val as $v) {
                echo '<td width="120" height="30">' . $v . '</td>';
                }
                echo '</td>';
            }else {
                echo '<tr align="center">';
                echo '<td width="120" height="30">' . $val . '</td>';
                echo '</td>';
            }
        }
        echo '</table>';
        exit;
    }