代码
public function expert()
{
vendor("PHPExcel.PHPExcel");
$list=db('alpacooperation')->field('*')->select();
$objPHPExcel = new \PHPExcel();
$objWriter = new \PHPExcel_Writer_Excel5($objPHPExcel);
//设置sheet名称
$sheets=$objPHPExcel->getActiveSheet()->setTitle('合作客户');
//设置sheet列头信息
$objPHPExcel->setActiveSheetIndex()->setCellValue('A1', '序号')->setCellValue('B1', '名称')->setCellValue('C1', '产品')->setCellValue('D1', '名称2')->setCellValue('E1', '数量')->setCellValue('F1', '金额')->setCellValue('G1', '日期')->setCellValue('H1', '负责人')->setCellValue('I1', '行业')->setCellValue('J1', '日期')->setCellValue('K1', '编码')->setCellValue('L1', '负责人标签[在职/离职/已转岗/管理层/代理]');
$i=2;
foreach($list as $v){
//设置单元格的值
$sheets=$objPHPExcel->getActiveSheet()->setCellValue('A'.$i,$v['bianhao']);
$sheets=$objPHPExcel->getActiveSheet()->setCellValue('B'.$i,$v['compname']);
$sheets=$objPHPExcel->getActiveSheet()->setCellValue('C'.$i,$v['prodname']);
$sheets=$objPHPExcel->getActiveSheet()->setCellValue('D'.$i,$v['materiel']);
$sheets=$objPHPExcel->getActiveSheet()->setCellValue('E'.$i,$v['num']);
$sheets=$objPHPExcel->getActiveSheet()->setCellValue('F'.$i,$v['money']);
$sheets=$objPHPExcel->getActiveSheet()->setCellValue('G'.$i,$v['date']);
$sheets=$objPHPExcel->getActiveSheet()->setCellValue('H'.$i,$v['salesperson']);
$sheets=$objPHPExcel->getActiveSheet()->setCellValue('I'.$i,$v['attribute']);
$sheets=$objPHPExcel->getActiveSheet()->setCellValue('J'.$i,$v['recorddate']);
$sheets=$objPHPExcel->getActiveSheet()->setCellValue('K'.$i,$v['contractcode']);
$sheets=$objPHPExcel->getActiveSheet()->setCellValue('L'.$i,$v['fla']);
$i++;
}
//整体设置字体和字体大小
$objPHPExcel->getDefaultStyle()->getFont()->setName( 'Arial');
$objPHPExcel->getDefaultStyle()->getFont()->setSize(10);
// $objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true); //单元格宽度自适应
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(20); //设置列宽度
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(50); //设置列宽度
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(20); //设置列宽度
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(20); //设置列宽度
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(20); //设置列宽度
$objPHPExcel->getActiveSheet()->getColumnDimension('F')->setWidth(20); //设置列宽度
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setWidth(20); //设置列宽度
$objPHPExcel->getActiveSheet()->getColumnDimension('H')->setWidth(20); //设置列宽度
$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setWidth(20); //设置列宽度
$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setWidth(20); //设置列宽度
$objPHPExcel->getActiveSheet()->getColumnDimension('K')->setWidth(20); //设置列宽度
$objPHPExcel->getActiveSheet()->getColumnDimension('L')->setWidth(50); //设置列宽度
// $objPHPExcel->getActiveSheet()->getStyle('B3')->getFont()->setBold(true); //设置单元格字体加粗
// 输出Excel表格到浏览器下载
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="hzkh.xls"'); //excel表格名称
$objWriter->save('php://output');
}