php使用phpexcel生成excel包含图片并导出

开发环境:linux

框架:thinkphp3.2

在之前遇到一个场景,是把excel表格中的数据解析出来,接触到了phpexcel,

先给个链接 http://blog.csdn.net/fei003/article/details/72897685

这个需要把商品信息导出表格,并且表格中还包含图片,所以这次又查了下,写下这次使用

PHPexcel的经历以及遇到的坑

首先把完整版代码贴出来,类库还是放在了vendor中

public function getExcel(){

        $ids = I('post.ids');
        $goods = $this->goods_model->select();  //查找自己所需要的数据

        // 实例化excel
        // 引入文件
        Vendor("PHPExcel.PHPExcel");
        vendor('PHPExcel/PHPExcel/Writer/Excel2007.php');
        $phpExcel = new \PHPExcel();
        $objDrawing = new \PHPExcel_Worksheet_Drawing();
        $phpExcel->getProperties()->setTitle("商品价格表");
        $phpExcel->getProperties()->setSubject("趣买呗商品价格表");
        // 对单元格设置居中效果
        $phpExcel->getActiveSheet()->getStyle('A')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $phpExcel->getActiveSheet()->getStyle('B')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $phpExcel->getActiveSheet()->getStyle('C')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $phpExcel->getActiveSheet()->getStyle('D')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $phpExcel->getActiveSheet()->getStyle('E')->getAlignment()->setHorizontal(\PHPExcel_Style_Alignment::HORIZONTAL_CENTER);
        $phpExcel->getActiveSheet()->getStyle('