i tried everything phpspreadsheet document and maatwebsite excel like implement WithStyles nothing works, like border, font size, etc

The only thing works , is fill value to certain column

public function registerEvents(): array
{
    return [
        AfterSheet::class => function(AfterSheet $event) use( $styleArray ) {
            $event->sheet->freezePane('A2', 'A2');
            $event->sheet->getCell('B15')->setValue('Some ff');
        },
    ];
}

how do i custom style some column ? like border, fontSize, color

Last updated 2 years ago

never mind, i found the issue, csv cant be styled need to use xlsx