zbs-api-new/app/Exports/BanzuiExcelExport.php

<?php

namespace App\Exports;

use App\Models\User;
use Illuminate\Support\Facades\Log;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithEvents;
use Maatwebsite\Excel\Concerns\WithHeadings;
use Maatwebsite\Excel\Concerns\WithTitle;
use Maatwebsite\Excel\Events\AfterSheet;

class BanzuiExcelExport implements FromCollection, WithHeadings, WithEvents
{
    protected $data;
    public function __construct($data){
        $this->data = $data;
    }
    public function collection()
    {
        return $this->data;
    }


    public function headings(): array
    {
        return['进货月份',
'进货人（批发商）昵称',
'进货人（批发商）手机号',
'半醉浓香型件数',
'半醉酱香型件数',
'件数合计',
'每件补助',
'补助金额',
'补助接收者昵称',
'补助接收者手机号',
'补助接收者身份'
];
    }

    public function setRowHeight(array $rouHeight)
    {
        $this->RowHeight=$rouHeight;
    }

    public function registerEvents(): array
    {
        return [
            AfterSheet::class => function(AfterSheet $event) {
                // 合并单元格，从 A1 到 C1
                $sheet = $event->sheet;
//                $sheet->mergeCells('A1:C1');
//                $sheet->setCellValue('A1','进货人信息');

                // 设置字体加粗、居中等样式
//                $sheet->getStyle('A1')->getFont()->setBold(true);
//                $sheet->getStyle('A1')->getAlignment()->setHorizontal('center');
//
////                $sheet->mergeCells('D1:I1');
////                $sheet->setCellValue('D1','进货数量及金额');
//
//                // 设置字体加粗、居中等样式
//                $sheet->getStyle('D1')->getFont()->setBold(true);
//                $sheet->getStyle('D1')->getAlignment()->setHorizontal('center');
//
////                $sheet->mergeCells('J1:L1');
////                $sheet->setCellValue('J1','拿补助的人信息');
//
//
//                // 设置字体加粗、居中等样式
//                $sheet->getStyle('J1')->getFont()->setBold(true);
//                $sheet->getStyle('J1')->getAlignment()->setHorizontal('center');
//
////                $sheet->mergeCells('M1:N1');
////                $sheet->setCellValue('M1','补助明细及金额');
//
//                $sheet->getStyle('M1')->getFont()->setBold(true);
//                $sheet->getStyle('M1')->getAlignment()->setHorizontal('center');
//
//                $sheet->getColumnDimension('B')->setWidth(20);
//                $sheet->getColumnDimension('K')->setWidth(20);
//                $sheet->setHeight=20;

                $data = $this->data;
                for ($row = 0; $row <= count($data); $row++) {
                    // 其他操作，如设置单元格值等
                    if ($row === count($data)) {
                        $sheet->mergeCells('A'. ($row + 1). ':F'. ($row + 1));

                        $sheet->getStyle('A'. ($row + 1))->getAlignment()->setHorizontal('center');
                        $sheet->setCellValue('A'. ($row + 1),'碱单半醉酒补助金额:'.$data[$row-1][0]);
                        $sheet->mergeCells('G'. ($row + 1). ':K'. ($row + 1));
                        $sheet->setCellValue('G'. ($row + 1),'补助发放时间及方式:'.$data[$row-1][1]);

                        $sheet->getStyle('G'. ($row + 1))->getAlignment()->setHorizontal('center');

                    }
                }

                $sheet->getStyle('A:K')->getAlignment()->setHorizontal('center');
                $sheet->getColumnDimension('A')->setWidth(20);
                $sheet->getColumnDimension('B')->setWidth(20);
                $sheet->getColumnDimension('C')->setWidth(20);
                $sheet->getColumnDimension('I')->setWidth(20);
                $sheet->getColumnDimension('J')->setWidth(20);
            },
        ];
    }
}