Question : Formatting an Excel Column
Answered by : emmanuel-owusu-addai
// Format column as percentage
$sheet->setColumnFormat(array( 'C' => '0%'
));
// Format a range with e.g. leading zeros
$sheet->setColumnFormat(array( 'A2:K2' => '0000'
));
// Set multiple column formats
$sheet->setColumnFormat(array( 'B' => '0', 'D' => '0.00', 'F' => '@', 'F' => 'yyyy-mm-dd',
));
Source : https://docs.laravel-excel.com/2.1/export/format.html | Last Update : Tue, 05 Jul 22
Question : Available excel column formatting
Answered by : emmanuel-owusu-addai
PHPExcel_Style_NumberFormat::FORMAT_GENERAL
PHPExcel_Style_NumberFormat::FORMAT_TEXT
...
Source : https://docs.laravel-excel.com/2.1/reference-guide/formatting.html | Last Update : Tue, 05 Jul 22