php 简单的导出excel并实现合并单元格

<?php
require_once './config/config.php';
//$sql_topic = "SELECT * FROM td_activity";
$aid = intval($_GET['aid']);
$name = $orp->one("td_activity","title","aid=".$aid);
if(empty($name)){exit('Access DENIED');}
$name = iconv("UTF-8","GBK",$name);//问卷题目
$str = '';
$str.='

问卷题目		选项	选择人数(个)

'.$v['topic'].'

';//题目名称结束
 foreach ($attribute_array as $k1=>$v1){
  $sql_answer = "SELECT * FROM `td_answer` AS answer WHERE  answer.a_id=".$v1['id']." group by answer.uid";
  $array_answer = $orp->getallrowstring($sql_answer);
  $num = count($array_answer);
  $value ='';
  if($v1['attribute'] =='text' || $v1['attribute'] == 'textarea'){
   $value = ' 其他建议用户输入';
  }else $value=$v1['attribute'];
  $str.='

'.$value.'

';
  $str.='

'.$num.'

';
  
 $str.='';
}
}
$str.='';


/*echo $str;


exit;*/
$str = iconv("UTF-8","GBK",$str);
$name = iconv("UTF-8","GBK",$name);
header('Content-Length: '.strlen($str));
header("Content-type:application/vnd.ms-excel");
header("Content-Disposition:filename={$name}.xls");
echo $str;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29753604/viewspace-1278377/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29753604/viewspace-1278377/