$objPHPExcel->getActiveSheet()->mergeCells('A1:J1');//合并单元格(如果要拆分单元格是需要先合并再拆分的,否则程序会报错)
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1','寄件方信息:');
$objPHPExcel->getActiveSheet()->mergeCells('B2:E2');//合并单元格(如果要拆分单元格是需要先合并再拆分的,否则程序会报错)
$objPHPExcel->getActiveSheet()->mergeCells('G2:H2');//合并单元格(如果要拆分单元格是需要先合并再拆分的,否则程序会报错)
$objPHPExcel->setActiveSheetIndex(0)->setCellValue('A3','货品及寄件信息:');
$objPHPExcel->getActiveSheet()->mergeCells('B3:J3');//合并单元格(如果要拆分单元格是需要先合并再拆分的,否则程序会报错)
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setAutoSize(true);//内容自适应
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('G')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('I')->setAutoSize(true);
$objPHPExcel->getActiveSheet()->getColumnDimension('J')->setAutoSize(true);
$objPHPExcel->getActiveSheet()
->setCellValue('A2', '寄件人公司名称')
->setCellValue('B2', "$userdealer")
->setCellValue('G2', "$sendername")
->setCellValue('J2', "$mobile")
->setCellValue('F2', '寄件联系人')
->setCellValue('I2', '联系电话')
->setCellValue('A4', '类别')
->setCellValue('B4', '墨盒型号')
->setCellValue('C4', '数量')
->setCellValue('D4', '发件日期')
->setCellValue('E4', '承运方')
->setCellValue('F4', '运费方式')
->setCellValue('G4', '承运单号')
->setCellValue('H4', '预到货日期')
->setCellValue('I4', '收件方地址')
->setCellValue('J4', '指定签收人');
$index=3;//初始下标从1开始
if($model){
foreach ($model as $key => $value) {
$objPHPExcel->getActiveSheet()->getStyle('C'. ($index + 2).':C'.(5 + $count-1))->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER); //左右居中
$objPHPExcel->getActiveSheet()->mergeCells('D'.($index + 2).':D'.(5 + $count-1));//合并单元格(如果要拆分单元格是需要先合并再拆分的,否则程序会报错)
$objPHPExcel->getActiveSheet()->mergeCells('E'.($index + 2).':E'.(5 + $count-1));//合并单元格(如果要拆分单元格是需要先合并再拆分的,否则程序会报错)
$objPHPExcel->getActiveSheet()->mergeCells('F'.($index + 2).':F'.(5 + $count-1));//合并单元格(如果要拆分单元格是需要先合并再拆分的,否则程序会报错)
$objPHPExcel->getActiveSheet()->mergeCells('G'.($index + 2).':G'.(5 + $count-1));//合并单元格(如果要拆分单元格是需要先合并再拆分的,否则程序会报错)
$objPHPExcel->getActiveSheet()->mergeCells('H'.($index + 2).':H'.(5 + $count-1));//合并单元格(如果要拆分单元格是需要先合并再拆分的,否则程序会报错)
$objPHPExcel->getActiveSheet()->mergeCells('I'.($index + 2).':I'.(5 + $count-1));//合并单元格(如果要拆分单元格是需要先合并再拆分的,否则程序会报错)
$objPHPExcel->getActiveSheet()->mergeCells('J'.($index + 2).':J'.(5 + $count-1));//合并单元格(如果要拆分单元格是需要先合并再拆分的,否则程序会报错)
$objPHPExcel->getActiveSheet()
->setCellValue('A' . ($index + 2), '耗材')
->setCellValue('B' . ($index + 2), $value[0])
->setCellValue('C' . ($index + 2), 1)
->setCellValue('D' . ($index + 2), "$ordertime")
->setCellValue('E' . ($index + 2), '顺丰')
->setCellValue('F' . ($index + 2), '顺丰到付')
->setCellValue('G' . ($index + 2), "$waybillNo")
->setCellValueExplicit('H' . ($index + 2), '')
->setCellValue('I' . ($index + 2), "$s_address")
->setCellValue('J' . ($index + 2), "$s_tel");
$index++;
}
}
$objPHPExcel->getActiveSheet()->setTitle('导出');
$objPHPExcel->setActiveSheetIndex(0);
$filename='ECC Data export - '.date('Ymd').".xlsx";
$session['exfilename'] = $filename;
ob_end_clean();
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");
header('Content-Disposition:inline;filename="'.$filename.'"');
header("Content-Transfer-Encoding: binary");
header("Last-Modified: " . gmdate("D, d M Y H:i:s") . " GMT");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Pragma: no-cache");
$objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
$objWriter->save($filepath.$filename);
效果图