$PHPExcel=new \PHPExcel(); //实例化PHPExcel类，类似于在桌面上新建一个Excel表格
$PHPSheet= $PHPExcel->getActiveSheet(); //获取当前活动sheet的操作对象
$PHPSheet->setTitle('配货产品列表'); //给当前活动sheet设置名称
//设置列宽
$PHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(10);
$PHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(35);
$PHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(35);
$PHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(25);
$PHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(25);
$PHPExcel->getActiveSheet()->setCellValueExplicit('A1', date('md', time()))
->getStyle('A1')->getFont()->setSize(14)->setBold(true);//字号、加粗
$PHPExcel->getActiveSheet()->mergeCells('A1:E1' . $last);//合并A1-E1之间的单元格
$PHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);//居中显示，HORIZONTAL_RIGHT 居右，HORIZONTAL_LEFT 居左
$PHPExcel->getActiveSheet()->getRowDimension($last)->setRowHeight(30);//设置行高，$last表示行号
$PHPExcel->getActiveSheet()->getStyle('A' . $last)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);//水平居中
