Export questions

[MrBean14]

Hello,

I'm getting more and more excited about the Maatwebsite functionality.
As a real newbie I explored the manual and was able to write very quickly a first export today.

I might have some questions though for which I do not find more information. I hope I can ask them here.

My controller:

public function export() 
    {
        $times = Time::all()->sortBy("car_id");
        return Excel::download(new Times2Export, 'tijdsregistratie.xlsx');
    }

My export:

<?php

namespace App\Exports;

use App\Time;
use Carbon\Carbon;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithMapping;
use Maatwebsite\Excel\Concerns\WithHeadings;
use Maatwebsite\Excel\Concerns\ShouldAutoSize;

class Times2Export implements FromCollection, WithMapping, WithHeadings, ShouldAutoSize
{

    public function collection()
    {
        return Time::all()->sortBy("car_id");
    }

   public function headings(): array
    {
        return [
            'Auto',
            'Taak',
            'Werknemer',
            'Starttijd',
            'Stoptijd',
            'Duur',
        ];
    }

    /**
    * @var Time $time
    */
    public function map($time): array
    {

        $dt = Carbon::parse($time->stop)->diffInSeconds(Carbon::parse($time->start));
        $duur = (is_null($time->stop)) ? 0 : $dt;

        return [
            $time->car->brand . " " . $time->car->type . " (" . $time->car->license . ")",
            $time->task->name,
            $time->employee->name,
            $time->start,
            $time->stop,
            $duur,
        ];
    }
}

My questions:

1. I would like to have the header in bold. Is this possible?
2. In the controller I'm sorting the cars by car_id. In the excel file I would like to get an empty line between each car (while each car can have a different number of lines).
3. For each car, I would like to make a calculation for the column "duur" (calculating the total of each "duur" value of each line per car.
4. I now export the "Duur" field in "seconds". How can I put them in excel as HH:mm:ss ?

PS While typing I even think I might have put a double line in different places. I probably can remove the line before the download in the controller.

Sorry if my questions are appropriate.

Thanks in advance for any help.

Best regards,
Davy

[MrBean14]

Is above possible or not please?
(Sorry I did put this in the wrong category before).

[anthonytp]

I would like to have the header in bold. Is this possible?

Yes, the documentation describes how to style cells

I now export the "Duur" field in "seconds". How can I put them in excel as HH:mm:ss ?

Use the Carbon::diff function, rather than diffInseconds, to get a DateInterval object and then call format

use Carbon\Carbon;
$start = Carbon::parse('2021-05-13 09:00:00');
$diff = $start->diff(Carbon::now())->format('%H:%I:%S');