$PHPExcel=new \PHPExcel(); //實例化PHPExcel類，類似于在桌面上新建一個Excel表格

$PHPSheet= $PHPExcel->getActiveSheet(); //獲取當(dāng)前活動sheet的操作對象

$PHPSheet->setTitle('配貨產(chǎn)品列表'); //給當(dāng)前活動sheet設(shè)置名稱

//設(shè)置列寬

$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);//設(shè)置行高，$last表示行號

$PHPExcel->getActiveSheet()->getStyle('A' . $last)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);//水平居中