php PHPExcel应用，phpphpexcel应用

php PHPExcel应用，phpphpexcel应用

<?php
require_once 'Classes/PHPExcel.php';

$objPHPExcel = new PHPExcel();

//创建人
$objPHPExcel->getProperties()->setCreator('wangjunjie');

//最后修改人
$objPHPExcel->getProperties()->setLastModifiedBy('wjj');

//标题
$objPHPExcel->getProperties()->setTitle("title");

//描述
$objPHPExcel->getProperties()->setDescription('description');

//关键字
$objPHPExcel->getProperties()->setKeywords('keywords');

//种类
$objPHPExcel->getProperties()->setCategory('category');

//设置当前的sheet
$objPHPExcel->setActiveSheetIndex(0);

//设置sheet的name
$objPHPExcel->getActiveSheet()->setTitle('hello');

//设置单元格的值
$objPHPExcel->getActiveSheet()->setCellValue('A1', 'string');
$objPHPExcel->getActiveSheet()->setCellValue('A2', 2);
$objPHPExcel->getActiveSheet()->setCellValue('A3', true);

$objPHPExcel->getActiveSheet()->setCellValue('C2', 5);
$objPHPExcel->getActiveSheet()->setCellValue('C4', 5);
$objPHPExcel->getActiveSheet()->setCellValue('C5', '=SUM(C2:C4)');

$objPHPExcel->getActiveSheet()->setCellValue('B8', '=MIN(B2:C5)');
$objPHPExcel->getActiveSheet()->setCellValue('B2', 20);
$objPHPExcel->getActiveSheet()->setCellValue('C5', 50);

//合并单元格
$objPHPExcel->getActiveSheet()->mergeCells('A18:E22');

//分离单元格 参数是 合并单元格的范围
//$objPHPExcel->getActiveSheet()->unmergeCells('A18:E22');

//保护cell 这个还有点儿问题 设置的是 A3:E13得单元个受保护 但是所有的单元格都受保护
$objPHPExcel->getActiveSheet()->getProtection()->setSheet(true);
$objPHPExcel->getActiveSheet()->protectCells('A3:E13','PHPExcel');

//设置列宽
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(50);
//设置行高
$objPHPExcel->getActiveSheet()->getRowDimension(10)->setRowHeight(40);

//设置字体的样式
//设置字体
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setName('Candara');
//设置字体大小
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setSize(12);
//设置粗体
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setBold(true);
//设置下划线
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->setUnderline(PHPExcel_Style_Font::UNDERLINE_SINGLE);
//设置颜色
$objPHPExcel->getActiveSheet()->getStyle('A1')->getFont()->getColor()->setARGB(PHPExcel_Style_Color::COLOR_RED);
//设置水平对齐方式
$objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
//设置垂直对齐方式
$objPHPExcel->getActiveSheet()->getStyle('A1')->getAlignment()->setVertical(PHPExcel_Style_Alignment::VERTICAL_CENTER);
//设置表格边框样式
$objPHPExcel->getActiveSheet()->getStyle('A3')->getBorders()->getTop()->setBorderStyle(PHPExcel_Style_Border::BORDER_DOTTED);
//设置表格的颜色 没有设置成功 不知道是什么原因
$objPHPExcel->getActiveSheet()->getStyle('A3')->getBorders()->getRight()->getColor()->setRGB(PHPExcel_Style_Color::COLOR_RED);
//填充表格的背景色
$objPHPExcel->getActiveSheet()->getStyle('A8')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);

//单元格加图片
$objDrawing = new PHPExcel_Worksheet_Drawing();
$objDrawing->setPath('90b6a0cc80593d6eb25e39b0f38b68c23.png')
              ->setHeight(100)
              ->setWidth(80)
              ->setCoordinates('E6')
              ->setWorksheet($objPHPExcel->getActiveSheet());

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('hello.xls');