thinkphp3.2中實現phpexcel導出帶生成圖片示例

2024-09-09 15:20:23

字體：大中小

來源：轉載

供稿：網友

首先下載PHPEXCEL 下載地址：http://phpexcel.codeplex.com/ https://github.com/PHPOffice/PHPExcel

把Classes目錄下的文件（PHPExcel.php和PHPExcel文件夾），放到ThinkPHP/Library/Org/Util目錄下

PHPExcel.php 改名為：PHPExcel.class.php

// 導出exl



  publicfunctionlook_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')-><a href="/tags.php/select/" target="_blank">select</a>();







    // 導出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);







    <a href="/tags.php/foreach/" target="_blank">foreach</a>($dataas$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= <a href="/tags.php/iconv/" target="_blank">iconv</a>("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');

    //Vevb.com

    $objWriter->save('php://output'); //文件通過瀏覽器下載



    // END



  }