thinkphp3.2中实现phpexcel导出带生成图片示例

　　首先下载PHPEXCEL 下载地址：

　　把Classes目录下的文件（PHPExcel.php和PHPExcel文件夹），放到ThinkPHP\Library\Org\Util目录下

　　PHPExcel.php 改名为 ：PHPExcel.class.php

　　 // 导出exl public function look_down(){ $id = I(get.id); $m = M (offer_goods); $where[offer_id] = $id; $data = $m->field(goods_id,goods_sn,goods_name,barcode,goods_type,price)->select(); // 导出Exl import(Org.Util.PHPExcel); import(Org.Util.PHPExcel.Worksheet.Drawing); import(Org.Util.PHPExcel.Writer.Excel2007); $objPHPExcel = new \PHPExcel(); $objWriter = new \PHPExcel_Writer_Excel2007($objPHPExcel); $objActSheet = $objPHPExcel->getActiveSheet(); // 水平居中（位置很重要，建议在最初始位置） $objPHPExcel->setActiveSheetIndex(0)->getStyle(A)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->setActiveSheetIndex(0)->getStyle(B1)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->setActiveSheetIndex(0)->getStyle(C)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->setActiveSheetIndex(0)->getStyle(D)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->setActiveSheetIndex(0)->getStyle(E)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objPHPExcel->setActiveSheetIndex(0)->getStyle(F)->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER); $objActSheet->setCellValue(A1, 商品货号); $objActSheet->setCellValue(B1, 商品名称); $objActSheet->setCellValue(C1, 商品图); $objActSheet->setCellValue(D1, 商品条码); $objActSheet->setCellValue(E1, 商品属性); $objActSheet->setCellValue(F1, 报价(港币)); // 设置个表格宽度 $objPHPExcel->getActiveSheet()->getColumnDimension(A)->setWidth(16); $objPHPExcel->getActiveSheet()->getColumnDimension(B)->setWidth(80); $objPHPExcel->getActiveSheet()->getColumnDimension(C)->setWidth(15); $objPHPExcel->getActiveSheet()->getColumnDimension(D)->setWidth(20); $objPHPExcel->getActiveSheet()->getColumnDimension(E)->setWidth(12); $objPHPExcel->getActiveSheet()->getColumnDimension(F)->setWidth(12); // 垂直居中 $objPHPExcel->getActiveSheet()->getStyle(A)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle(B)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle(D)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle(E)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER); $objPHPExcel->getActiveSheet()->getStyle(F)->getAlignment()->setVertical(\PHPExcel_Style_Alignment::VERTICAL_CENTER); foreach($data as $k=>$v){ $k +=2; $objActSheet->setCellValue(A.$k, $v[goods_sn]); $objActSheet->setCellValue(B.$k, $v[goods_name]); $img = M(goods)->where(goods_id = .$v[goods_id])->field(goods_thumb)->find(); // 图片生成 $objDrawing[$k] = new \PHPExcel_Worksheet_Drawing(); $objDrawing[$k]->setPath(./Upload/.$img[goods_thumb]); // 设置宽度高度 $objDrawing[$k]->setHeight(80);//照片高度 $objDrawing[$k]->setWidth(80); //照片宽度 /*设置图片要插入的单元格*/ $objDrawing[$k]->setCoordinates(C.$k); // 图片偏移距离 $objDrawing[$k]->setOffsetX(12); $objDrawing[$k]->setOffsetY(12); $objDrawing[$k]->setWorksheet($objPHPExcel->getActiveSheet()); // 表格内容 $objActSheet->setCellValue(D.$k, $v[barcode]); $objActSheet->setCellValue(E.$k, $v[goods_type]); $objActSheet->setCellValue(F.$k, $v[price]); // 表格高度 $objActSheet->getRowDimension($k)->setRowHeight(80); } $fileName = 报价表; $date = date(Y-m-d,time()); $fileName .= _{$date}.xls; $fileName = iconv(utf-8, gb2312, $fileName); //重命名表 // $objPHPExcel->getActiveSheet()->setTitle(test); //设置活动单指数到第一个表,所以Excel打开这是第一个表 $objPHPExcel->setActiveSheetIndex(0); header(Content-Type: application/vnd.ms-excel); header(Content-Disposition: attachment;filename=\$fileName\); header(Cache-Control: max-age=0); $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, Excel5); $objWriter->save(php://output); //文件通过浏览器下载 // END }

　　水平居中，垂直居中，高度 等设置。注意放的位置，如果你放在末尾，那么是下一样生效。放到头部，第一行生效（上面代码是第一行生效，如果放到foreach里面就是下一行生效）。

　　import介绍。import(Org.Util.PHPExcel.Writer.Excel2007); 文件位置：Org\Util\PHPExcel\Writer\Excel2007.class.php

　　图片地址一定要是本地。objDrawing[ objDrawing[k]->setPath(./Upload/.$img[goods_thumb]); 图片位置：安装目录/Upload/xxx

　　以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持脚本之家。