$objPHP = new PHPExcel();
$objActSheet = $objPHP->getActiveSheet();
$objActSheet->setCellValue('A1', '姓名');
$objActSheet->setCellValue('B1', '电话');
$objActSheet->setCellValue('C1', '省');
$objActSheet->setCellValue('D1', '城市');
$objActSheet->setCellValue('E1', '经销商');
$objActSheet->setCellValue('F1', '提交时间');
$objActSheet->setCellValue('G1', '图片');
foreach ($nlist as $k => $v){
$k +=2;
$objActSheet->setCellValue('A'.$k, $v['uname']);
$objActSheet->setCellValue('B'.$k, $v['phone']);
$objActSheet->setCellValue('C'.$k, $v['province']);
$objActSheet->setCellValue('D'.$k, $v['city']);
$objActSheet->setCellValue('E'.$k, $v['dealer']);
$objActSheet->setCellValue('F'.$k, $v['create_date']);
//进行图片处理
if ($v['img']){
$objDrawing = new PHPExcel_Worksheet_Drawing(); //必须每次重新实例化
$objDrawing->setPath('.'.$v['img']);//这里是相对路径
$objDrawing->setHeight(80);//照片高度
$objDrawing->setWidth(80);
$objDrawing->setCoordinates('G'.$k);
// 图片偏移距离
// $objDrawing->setOffsetX(12);
$objDrawing->setOffsetY(12);
$objDrawing->setWorksheet($objPHP->getActiveSheet());
}
$objActSheet->getRowDimension($k)->setRowHeight(40);//设置行高 放在前面设置有数据的行不生效
$objActSheet->getColumnDimension('G')->setWidth(20);//设置G行宽度 放在前面设置有数据的行不生效
}
$excel = PHPExcel_IOFactory::createWriter($objPHP, 'Excel2007'); //Excel2007 兼容好
ob_end_clean(); //解决乱码
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename=留资列表' . date('Ymd') . '.xlsx');
header('Cache-Control: max-age=0');
$excel->save('php://output');
exit;