// 这里的 $company_list 是一个 $list = array(array('id'=>1,'username'=>'YQJ','sex'=>'男','age'=>24));类型的数组
public function test2Action($company_list)
{
// $indexKey = array('id','username','sex','age');
// $list = array(array('id'=>1,'username'=>'YQJ','sex'=>'男','age'=>24));
$indexKey = array(
'key','company_name','SHXYDM','FRDB','ESDATE','ENTSTATUS','REGCAP','REGCAPCUR','DOM','ENTTYPE','OPSCOPE');
$list = array(array('id'=>1,'username'=>'YQJ','sex'=>'男','age'=>24));
// 获取所有问题栏目
$this->exportExcel($company_list,time(),$indexKey);
}
function exportExcel($list,$filename,$indexKey,$startRow=2,$excel2007=false){
if(empty($filename)) $filename = time();
if( !is_array($indexKey)) return false;
$header_arr = array('A','B','C','D','E','F','G','H','I','J','K','L','M', 'N','O','P','Q','R','S','T','U','V','W','X','Y','Z');
//初始化PHPExcel()
$objPHPExcel = new PHPExcel();
//设置保存版本格式
if($excel2007){
$objWriter = new PHPExcel_Writer_Excel2007($objPHPExcel);
$filename = $filename.'.xlsx';
}else{
$objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);
$filename = $filename.'.xls';
}
//接下来就是写数据到表格里面去
$objActSheet = $objPHPExcel->getActiveSheet();
//$startRow = 1;
//设置标题
$objActSheet->setCellValue('A1', "排名");
$objActSheet->setCellValue('B1', "企业名称");
$objActSheet->setCellValue('C1', "统一社会信用代码");
$objActSheet->setCellValue('D1', "法定代表人");
$objActSheet->setCellValue('E1', "成立日期");
$objActSheet->setCellValue('F1', "经营状态");
$objActSheet->setCellValue('G1', "注册资本");
$objActSheet->setCellValue('H1', "注册资本币种");
$objActSheet->setCellValue('I1', "地址");
$objActSheet->setCellValue('J1', "企业类型");
$objActSheet->setCellValue('K1', "经营业务范围");
foreach ($list as $row) {
/* p($row);die;
Array
(
[id] => 2146
[company_num] => N2112
[company_name] => 海南航空股份有限公司
[company_keyworlds] => 海航
[cid] => 5
[10] => 2
[11] => 2
[12] => 7
[13] => 1
[14] => 5
[15] => 2
[21] => 1
)*/
foreach ($indexKey as $key => $value){
/* p($value);die;
第一次 :id
第二次 :company_num
第三次*/
//这里是设置单元格的内容
$objActSheet->setCellValue($header_arr[$key].$startRow,$row[$value]);
}
$startRow++;
}
// 下载这个表格,在浏览器输出
header("Pragma: public");
header("Expires: 0");
header("Cache-Control:must-revalidate, post-check=0, pre-check=0");
header("Content-Type:application/force-download");
header("Content-Type:application/vnd.ms-execl");
header("Content-Type:application/octet-stream");
header("Content-Type:application/download");;
header('Content-Disposition:attachment;filename='.$filename.'');
header("Content-Transfer-Encoding:binary");
$objWriter->save('php://output');
}