1.合并单元格
$objPHPExcel->getActiveSheet(0)->mergeCells('A1:B1');
2.给单元格添加背景色
$objPHPExcel->getActiveSheet(0)->getStyle('A1:B1')->getFill()->setFillType(\PHPExcel_Style_Fill::FILL_SOLID);
$objPHPExcel->getActiveSheet(0)->getStyle('A1:B1')->getFill()->getStartColor()->setRGB('CCCCFF');
ps:rgb值转16进制在线转换网址 http://www.sioe.cn/yingyong/yanse-rgb-16/
3.设置单元格默认行高
$objPHPExcel->getActiveSheet(0)->getDefaultRowDimension()->setRowHeight(80);
4.设置单元格默认宽度
$objPHPExcel->getActiveSheet(0)->getDefaultColumnDimension()->setWidth(15);
5.设置某行行高度
$objPHPExcel->getActiveSheet(0)->getRowDimension(1)->setRowHeight(17);
6.设置某列单元格宽度
$objPHPExcel->getActiveSheet(0)->getColumnDimension('B')->setWidth(21)
7.设置水平竖直居中
$objPHPExcel->getActiveSheet(0)->getStyle($i.'1:'.$i.'2')->getAlignment()->
setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER);//竖直居中
$objPHPExcel->getActiveSheet(0)->getStyle($i.'1:'.$i.'2')->getAlignment()
->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);//水平居中
8.设置边框
$styleArray = array(
'borders' => array(
'allborders' => array(
'style' => PHPExcel_Style_Border::BORDER_THIN,//细边框
'color' => array('argb' => '000000'),
),
),
);
$objPHPExcel->getActiveSheet(0)->getStyle('A1:K1')->applyFromArray($styleArray);//从A1到K1设置边框为细边框
9.设置导出文件的名称
header("Content-Disposition: attachment;filename='导出名字.xls'");
10.在导出的excel单元格里添加图片
$objDrawing= new PHPExcel_Worksheet_Drawing();
$objDrawing->setPath($url);//url是图片的绝对路径
// 设置宽度高度
$objDrawing->setHeight(80);//照片高度
$objDrawing->setWidth(80); //照片宽度
/*设置图片要插入的单元格*/
$objDrawing->setCoordinates('N'.$i);
// 图片偏移距离
$objDrawing->setOffsetX(10);
$objDrawing->setOffsetY(10);
$objDrawing->setWorksheet($objPHPExcel->getActiveSheet());