PHP 导出 EXCEL

	header("Content-type:application/vnd.ms-excel;charset=utf-8");
	$filename = "order_".date("Y-m-d",time()).".xls";
	header("Content-Disposition:attachment; filename=$filename");

	$sql = "select id ,linkman,telephone,postcode, address,price,name  from  {$tablepre}shops ";
	$result = $db->fetchAssocArrBySql($sql,0);
	//print_r($result);exit;
	$excelheader = "订单号\t收货人\t手机\t邮编\t商品名称\t价格\t收货地址\t\n";
	foreach($result as $k => $v)
	{
	  if($k==0)
	  {
		   echo  iconv("utf-8","gbk",$excelheader);
	  }
	  foreach($v as $kk => $vv)
	  {
		   $vv = preg_replace('/\n/', '', $vv);
		   $vv = preg_replace('/\t/', '', $vv);
		   $vv = preg_replace('/'.chr(13).'/', '', $vv);
		   //echo $vv."\t";
		   echo @iconv("utf-8","gbk",$vv."\t");
	  }
	  /*
	  echo iconv("utf-8","gbk",$v['name']."\t");
	  $cardid = $db->fetchOneBySql("select idcode from {$tablepre}members where uid='".$v['title']."'");
	  $cardid = "'".strval($cardid);
	  */
	  echo "\n";
	}
	exit;