Laravel框架使用maatwebsite/excel 导出表格样式自定义

controller

<?php

namespace AppHttpControllersAdmin;

use AppHttpControllersPublicController;
use AppModelsShopGoods;
use AppModelsFile;
use AppModelsShopPackage;
use AppModelsShopPackageGoods;
use AppModelsShopOrder;
use AppModelsMember;
use AppUtilsCodeUtil;
use AppUtilsConstantUtil;
use IlluminateHttpRequest;
use AppHttpControllersController;

use Excel;
use PHPExcel_Worksheet_Drawing;

class PackageController extends Controller
{
    
    public function export(Request $request)
    {
        ini_set('memory_limit', '500M');
        set_time_limit(0);//设置超时限制为0分钟

        $package_id = $request->input("id");
        $list = ShopPackage::find($package_id);
        $goods = ShopPackageGoods::where('package_id',$package_id)->get();
        $order = ShopOrder::where('package_id',$package_id)->orderBy('id','asc')->limit(1)->first();
        $user = Member::where('id',$list['user_id'])->value('nickname');
        
        $newNumber = substr(strval($package_id+10000),1,4);
        $filename = '和品美术包裹明细'.$newNumber;
        $cellData[] = [$filename];
        $cellData[] = ['图片','编号+名称','金额总','备注'];
        
        $total = 0;
        foreach($goods as $kk=>$vv){
            $pic = File::where('id',$vv->goods_pic)->value('uri');
            $cellData[] = [$pic,$vv->goods_name,$vv->goods_price,'无'];
            $total += $vv->goods_price;
        }
        
        $kh = '客户姓名：'.$user;
        $sh = '收货地址：'.$order->consignee.' '.$order->mobile.' '.$order->province.' '.$order->city.' '.$order->district.' '.$order->address;
        $cellData[] = [$kh,$sh,'总计金额',$total];
        
        $cell_count = count($cellData);
        
        Excel::create($filename,function ($excel) use ($cellData,$cell_count){
            $excel->sheet('score',function ($sheet) use ($cellData,$cell_count) {
                
                //init列
                $title_array = ['A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q',
                    'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z', 'AA', 'AB', 'AC', 'AD', 'AE', 'AF', 'AG', 'AH'];
                //遍历数据
                for($i=0;$i<sizeof($cellData);$i++){
                    foreach($cellData[$i] as $k=>$v){
                        
                        // 设置宽度：
                        $sheet->setWidth(array( 'A' => 30,'B' => 84,'C' => 30,'D' => 30));
                        // 设置高度：
                        $sheet->setHeight(array(
                            ($i * 20 + 1) => 40,//设置每行的高度
                            ($i * 20 + 2) => 40,
                        ));
                        // 设置单元格字体样式:
                        $sheet->cells(('A1:D200'), function ($cells) {
                            $cells->setFontSize(14);//字体大小
                            $cells->setFontFamily('simsun');//字体样式
                            $cells->setValignment('center');//字体垂直居中
                            $cells->setAlignment('center');//字体水平居中
                        });
                        //字体自动换行
                        $sheet->getStyle('A1:D200')->getAlignment()->setWrapText(TRUE);
                        
                        if($i == 0){
                            $sheet->mergeCells('A1:D1');
                        }
                        //设置图片列高度
                        $i>1 && $sheet->setHeight($i+1, 85);
                        //设置图片列宽度
                        $sheet->setWidth(array('F'=>12));
                        //判断图片列，如果是则放图片
                        if($k == 0 && $i>1 && $i < ($cell_count-1)){
                            $objDrawing = new PHPExcel_Worksheet_Drawing;
                            $objDrawing->setPath('.'.$v);
                            $objDrawing->setCoordinates($title_array[$k] . ($i+1));
                            $objDrawing->setHeight(90);
                            // 写入图片在指定格中的X坐标值
                            $objDrawing->setOffsetX ( 36 );
                            // 写入图片在指定格中的Y坐标值
                            $objDrawing->setOffsetY ( 13 );
                            $objDrawing->setRotation(1);
                            $objDrawing->setWorksheet($sheet);
                            continue;
                        }
                        //否则放置文字数据
                        $sheet->cell($title_array[$k] . ($i+1), function ($cell) use ($v) {
                            $cell->setValue($v);
                        });    
                    }                    
                }
            });
        })->export('xls');
    }
    
}

view

<form class="layui-form" action="/Package/export" enctype="multipart/form-data" method="post" id="ajaxform" style="10%;float:left;">
    {{csrf_field()}}
    <input type="hidden" name="id" value="{{$vo['id']}}">
    <div class="panel-body">
        <button class="layui-btn layui-btn-sm"><i class="layui-icon">&#xe601;</i>导出</button>
    </div>
</form>

注：导出图片时，图片一定要在本地存在才可以导出

效果如下：