Laravel Maat 网站自动行高

Question

将数据导出到 Excel 时，我必须为 B、C 和 D 列分配多个换行符。我在代码中使用了 PHP_EOL 来换行。

导出后，我可以在一行中看到所有数据，但我希望每一行都显示下面“预期输出”下显示的数据。

public function collection()
{
    $index = 0;
    $data = collect($this->data)->map(function($lead, $Index) use($index) {
        $index = $index + 1;
        return collect([
            ($Index+1),
            $lead->lead_date ? date('d/m/Y h:i a', strtotime($lead->lead_date)) : "",
            $lead->organisation.PHP_EOL.$lead->industry_type,
            $lead->address.PHP_EOL.$lead->city.PHP_EOL.$lead->state,
            $lead->first_name.PHP_EOL.$lead->last_name.PHP_EOL.$lead->designation_name,
            $lead->product_type,
            $lead->account_type,
            $lead->created_time,
            $lead->contact_number.PHP_EOL. $lead->email_id,
            $lead->sales_person,
        ]);
    });
    return collect($data);
}

public function registerEvents(): array
{
    return [

        AfterSheet::class    => function(AfterSheet $event) {
            $columns = ["A", "B", "C", "D", "E", "F", "G", "H", "I", "J", "K", "L", "M", "N", "O", "P", "Q", "R", "S", "T"];
            foreach ($columns as $column) {
                $event->sheet->getColumnDimension($column)->setAutoSize(true);
            }

        }
    ];
}

电流输出

预期输出