导入

header("Content-Type: application/vnd.ms-execl");
header("Content-Type: application/vnd.ms-excel; charset=utf-8");
header("Content-Disposition: attachment; filename=test.xls");
header("Pragma: no-cache");
header("Expires: 0");
echo iconv("utf-8", "gb2312", "公司名称")."\t";
echo iconv("utf-8", "gb2312", "联系人")."\t";
echo iconv("utf-8", "gb2312", "联系方式")."\t";
echo iconv("utf-8", "gb2312", "公司地址")."\t";
echo iconv("utf-8", "gb2312", "加入类型")."\t";
echo iconv("utf-8", "gb2312", "审核状态")."\n";
$ar=new Admin();
$v =$ar->dao();
foreach($v as $k=>$row){
    echo iconv("utf-8", "gb2312", $row['company_name'])."\t";
    echo iconv("utf-8", "gb2312", $row['contacts'])."\t";
    echo iconv("utf-8", "gb2312", $row['tel'])."\t";
    echo iconv("utf-8", "gb2312", $row['address'])."\t";
    echo iconv("utf-8", "gb2312", $row['sort'])."\t";
    echo iconv("utf-8", "gb2312", $row['status'])."\n";
}