<?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');
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');