PHP excel导出 表格 ,带图片
安装
安装命令:composer require phpoffice/phpexcel
先看下结果
这里是方法
/**
* 该方法是生成excel表格的
* @param $data
* @param string $filename
* @param string $format
* @throws \PHPExcel_Exception
* @throws \PHPExcel_Reader_Exception
* @throws \PHPExcel_Writer_Exception
*/
public static function export($data,$filename='excel',$format='xls')
{
$excel = new PHPExcel();
/*设置文本对齐方式*/
$excel->getDefaultStyle()->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
$excel->getDefaultStyle()->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);
$objActSheet = $excel->getActiveSheet();
$header = array_keys($data[0]);
$arr = array('A','B','C','D','E','F','G','H','I','J','K','L','M','N',