phpExcel中文帮助手册

1、phpExcel中文帮助手册1、设置excel的属性：创建人$objPHPExcel->getProperties()->setCreator("Maarten Balliauw");最后修改人$objPHPExcel->getProperties()->setLastModifiedBy("Maarten Balliauw");标题$objPHPExcel->getProperties()->setTitle("Office 2007 XLSX Test Document");题目$objPHPE

2、xcel->getProperties()->setSubject("Office 2007 XLSX Test Document");描述$objPHPExcel->getProperties()->setDescription("Test document for Office 2007XLSX, generated using PHP classes.");关键字$objPHPExcel->getProperties()->setKeywords("office 2007 openxml php&quo

3、t;);种类$objPHPExcel->getProperties()->setCategory("Test result file");设置当前的sheet$objPHPExcel->setActiveSheetIndex(0);设置 sheet 的 name$objPHPExcel->getActiveSheet()->setT让le('Simple');设置单元格的值复制代码彳t码示例:$objPHPExcel->getActiveSheet()->setCellValue('A1', '

4、;String');$objPHPExcel->getActiveSheet()->setCellValue('A2', 12);$objPHPExcel->getActiveSheet()->setCellValue('A3', true);$objPHPExcel->getActiveSheet()->setCellValue('C5', '=SUM(C2:C4)');$objPHPExcel->getActiveSheet()->setCellValue('B8

5、', '=MIN(B2:C5)');合并单元格复制代码代码示例：$objPHPExcel->getActiveSheet()->mergeCells('A18:E22');分离单元格复制代码代码示例：$objPHPExcel->getActiveSheet()->unmergeCells('A28:B28');保护cell复制代码彳t码示例:$objPHPExcel->getActiveSheet()->getProtection()->setSheet(true); Needs to be se

6、t to true in order to enable any worksheet protection!$objPHPExcel->getActiveSheet()->protectCells('A3:E13', 'PHPExcel');设置格式复制代码代码示例：/ Set cell number formatsecho date('H:i:s') . " Set cell number formatsn"$objPHPExcel->getActiveSheet()->getStyle('E

7、4')->getNumberFormat()->setFormatCode(PHPExcel_Styl e_NumberFormat:FORMAT_CURRENCY_EUR_SIMPLE);$objPHPExcel->getActiveSheet()->duplicateStyle( $objPHPExcel->getActiveSheet()->getStyle('E4'), 'E5:E13');设置宽width复制代码彳t码示例:/ Set column widths$objPHPExcel->getActi

8、veSheet()->getColumnDimension('B')->setAutoSize(true);$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(12);设置font复制代码代码示例：$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setName('Candara');$objPHPExcel->getActi

9、veSheet()->getStyle('B1')->getFont()->setSize(20);$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setBold(true);$objPHPExcel->getActiveSheet()->getStyle('B1')->getFont()->setUnderline(PHPExcel_Style_Font:UND ERLINE_SINGLE);$objPHPEx

10、cel->getActiveSheet()->getStyle('B1')->getFont()->getColor()->setARGB(PHPExcel_Style_C olor:COLOR_WHITE);$objPHPExcel->getActiveSheet()->getStyle('E1')->getFont()->getColor()->setARGB(PHPExcel_Style_C olor:COLOR_WHITE);$objPHPExcel->getActiveSheet()-&

11、gt;getStyle('D13')->getFont()->setBold(true);$objPHPExcel->getActiveSheet()->getStyle('E13')->getFont()->setBold(true);设置align复制代码彳t码示例:$objPHPExcel->getActiveSheet()->getStyle('D11')->getAlignment()->setHorizontal(PHPExcel_Style_Alig nment:HORIZ

12、ONTAL_RIGHT);$objPHPExcel->getActiveSheet()->getStyle('D12')->getAlignment()->setHorizontal(PHPExcel_Style_Alig nment:HORIZONTAL_RIGHT);$objPHPExcel->getActiveSheet()->getStyle('D13')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment:HORIZONTAL_RIGHT);$o

13、bjPHPExcel->getActiveSheet()->getStyle('A18')->getAlignment()->setHorizontal(PHPExcel_Style_Alig nment:HORIZONTAL_JUSTIFY);/垂直居中复制代码代码示例：$objPHPExcel->getActiveSheet()->getStyle('A18')->getAlignment()->setVertical(PHPExcel_Style_Alignm ent:VERTICAL_CENTER);设置

14、column 的 border复制代码彳t码示例:$objPHPExcel->getActiveSheet()->getStyle('A4')->getBorders()->getTop()->setBorderStyle(PHPExcel_S tyle_Border:BORDER_THIN);$objPHPExcel->getActiveSheet()->getStyle('B4')->getBorders()->getTop()->setBorderStyle(PHPExcel_S tyle_Bor

15、der:BORDER_THIN);$objPHPExcel->getActiveSheet()->getStyle('C4')->getBorders()->getTop()->setBorderStyle(PHPExcel_S tyle_Border:BORDER_THIN);$objPHPExcel->getActiveSheet()->getStyle('D4')->getBorders()->getTop()->setBorderStyle(PHPExcel_S tyle_Border:BORD

16、ER_THIN);$objPHPExcel->getActiveSheet()->getStyle('E4')->getBorders()->getTop()->setBorderStyle(PHPExcel_S tyle_Border:BORDER_THIN);设置 border 的 color复制代码彳t码示例:$objPHPExcel->getActiveSheet()->getStyle('D13')->getBorders()->getLeft()->getColor()->setARG

17、B('FF') ;$objPHPExcel->getActiveSheet()->getStyle('D13')->getBorders()->getTop()->getColor()->setARGB('FF'); $objPHPExcel->getActiveSheet()->getStyle('D13')->getBorders()->getBottom()->getColor()->setARGB(' FF');$objPHPExcel

18、->getActiveSheet()->getStyle('E13')->getBorders()->getTop()->getColor()->setARGB('FF'); $objPHPExcel->getActiveSheet()->getStyle('E13')->getBorders()->getBottom()->getColor()->setARGB(' FF');$objPHPExcel->getActiveSheet()->get

19、Style('E13')->getBorders()->getRight()->getColor()->setARGB('FF1)；设置填充颜色复制代码代码示例：$objPHPExcel->getActiveSheet()->getStyle('A1')->getFill()->setFillType(PHPExcel_Style_Fill:FILL_SOL ID);$objPHPExcel->getActiveSheet()->getStyle('A1')->getFil

20、l()->getStartColor()->setARGB('FF');$objPHPExcel->getActiveSheet()->getStyle('B1')->getFill()->setFillType(PHPExcel_Style_Fill:FILL_SOL ID);$objPHPExcel->getActiveSheet()->getStyle('B1')->getFill()->getStartColor()->setARGB('FF');加图片复制

21、代码代码示例：$objDrawing = new PHPExcel_Worksheet_Drawing();$objDrawing->setName('Logo');$objDrawing->setDescription('Logo');$objDrawing->setPath('./images/officelogo.jpg');$objDrawing->setHeight(36);$objDrawing->setWorksheet($objPHPExcel->getActiveSheet();$objDra

22、wing = new PHPExcel_Worksheet_Drawing();$objDrawing->setName('Paid');$objDrawing->setDescription('Paid');$objDrawing->setPath('./images/paid.png');$objDrawing->setCoordinates('B15');$objDrawing->setOffsetX(110);$objDrawing->setRotation(25);$objDrawin

23、g->getShadow()->setVisible(true);$objDrawing->getShadow()->setDirection(45);$objDrawing->setWorksheet($objPHPExcel->getActiveSheet();/处理中文输出问题需要将字符串转化为UTF-8编码，才能正常输出，否则中文字符将输出为空白，如下处理:$str = iconv ('gb2312', 'utf-8', $str);或者可以写一个函数专门处理中文字符串：复制代码代码示例：function conver

24、tUTF8($str)if(empty($str) return ''return iconv('gb2312', 'utf-8', $str);/从数据库输出数据处理方式从数据库读取数据如：复制代码代码示例：$db = new Mysql($dbconfig);$sql = "SELECT * FROM 表名"$row = $db->GetAll($sql); / $row 为二维数组$count = count($row);for ($i = 2; $i <= $count+1; $i+) $objPHPExc

25、el->getActiveSheet()->setCellValue('A' . $i, convertUTF8($row$i-21);$objPHPExcel->getActiveSheet()->setCellValue('B' . $i, convertUTF8($row$i-22);$objPHPExcel->getActiveSheet()->setCellValue('C' . $i, convertUTF8($row$i-23);$objPHPExcel->getActiveSheet()-

26、>setCellValue('D' . $i, convertUTF8($row$i-24);$objPHPExcel->getActiveSheet()->setCellValue('E' . $i, convertUTF8(date("Y-m-d", $row$i-25);$objPHPExcel->getActiveSheet()->setCellValue('F' . $i, convertUTF8($row$i-26);$objPHPExcel->getActiveSheet()-

27、>setCellValue('G' . $i, convertUTF8($row$i-27);$objPHPExcel->getActiveSheet()->setCellValue('H' . $i, convertUTF8($row$i-28);在默认sheet后，创建一个 worksheet在这里插入一段，之前脚本学堂也为大家介绍过几篇有关phpexcel的文章，有兴趣的朋友可以看看：使用PHPExcel判别和格式化 Excel中的日期格式的例子phpexcel 导出 excel的颜色与网页中颜色不一致的解决方法CI中使用PHPExcel导出数据到Excel复制代码代码示例：echo date('H:i:s') . " Create new Worksheet objectn"$objPHPExcel->createSheet();$objWriter = PHPExcel_IOFactory:createWriter($objExcel, 'Excel5');$objWriter-save('php:output');附，几个常用的使用方法。复制代码代码示例：<?phpinclude 'PHPExcel.php'inclu