How to make a excel file with laravel excel with beautified or nice looking tables?-CodePudding

Heres my problem. I want to make a good looking table for my orders and inventory stock as excel files. But I can't find how to import tables in the file and save it and not create another new file.

Please help me on what can I do here!

Laravel Version : 8.1.10

Laravel Excel Version : 3.1

Thanks!

CodePudding user response：

It's ok that you want show beautified your excel file, if you use untidy code and config it will has lot of load and burden on your php-cgi.

you can use phpspreadsheet for this work after that you can change cell color with this code:

$spreadsheet->getActiveSheet()->getStyle('B2')->getFont()->getColor()->setARGB(\PhpOffice\PhpSpreadsheet\Style\Color::COLOR_RED);