lundi 6 avril 2020

Laravel Maatwebsite\Excel export

I have problem on exporting to excel using laravel maatwebsite excel, i can do export but it will export all in series.My problem is, I want to assign the result in every cell. Example:A1 = Agency Name, B1 = Division Name, A3:E3 = Account Title (merge), A5 - E5 = Table header, A6 - E6 = result of foreach data. In short, I want to assign the result in specific cell, to make like a formatted report. I try to search here but i didnt find result that explain or show how to pud the exported result to an specific excel cell

$ews->setCellValue('a1', 'Company name'); 
$ews->setCellValue('b1', 'Company Division');
$ews->setCellValue('A3:E3', 'Account Title');


via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire