Custom Header and Footer without trailing commas

[stankobrin]

I am need of some assistance. I am trying to create a custom export that includes a collection of data, but also a header and footer in a very specific manor for a 3rd party system to consume the file.

I am generating a header row using custom headings():

  public function headings(): array
    {

        $newDate = new DateTime();
        $date = $newDate->format('Ymd');
        $time = $newDate->format('His');

        return [
            'Header',
            $date,
            $time,
        ];
    }

Which works perfectly, however as the collection output contains 24 columns, when I output the file, the header renders like this:
Header,20211021,065529,,,,,,,,,,,,,,,,,,,,,,

The requirement is to have it output like this:
Header,20211021,065529

I am looking for a way to remove the trailing commas just in the header and the footer

For the footer, I have registered a custom event:

public function registerEvents(): array
    {
        return [
            // Handle by a closure.
            AfterSheet::class => function (AfterSheet $event) {
                $last_row = count($this->transactions) + 1 + 1;
                $rowCount = count($this->transactions) + 2;
                
                $event->sheet->setCellValue(sprintf('A%d', $last_row), 'Footer');
                $event->sheet->setCellValue(sprintf('B%d', $last_row), $rowCount);
            },
        ];
    }

Which again works perfectly but outputs with the same issue:

Actual:
Footer,49,,,,,,,,,,,,,,,,,,,,,,,

Required:
Footer,49

Any assistance in figuring this out would be hugely appreciated!

Thanks
Stan

[patrickbrouwers]

I don't think PhpSpreadsheet supports that. You'll probably have to open the file and do a replace in there.

[stankobrin]

Would merging the columns not fix the problem?

[stankobrin]

With regards to opening and replacing - could this be done via code as this file is supposed to generate in real-time to the end-user?

[patrickbrouwers]

No I think it will always result in the same