I installed the Excel package in my laravel installation it's work fine but only problem is I don't know how to create header of the excel data does anyone know?
public function Exportcsv(Request $recuestdata){
$data = $recuestdata['row'];
$export_paye[] =[
'Order Number',
'Customer Email',
'Delivery Date',
];
$myFile = Excel::create('Order export', function($excel) use ($export_paye,$data) {
// Set the spreadsheet title, creator, and description
$excel->setTitle('Order export');
$excel->setDescription('Order export');
// Build the spreadsheet, passing in the payments array
$excel->sheet('sheet1', function($sheet) use ($data) {
$sheet->fromArray($data , null, 'A1', false, false);
});
});
$myFile = $myFile->string('xlsx');
$response = array(
'name' =>"test.xlsx", //no extention needed
'file' => "data:application/vnd.openxmlformats-officedocument.spreadsheetml.sheet;base64,".base64_encode($myFile) //mime type of used format
);
return response()->json($response);
}
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire