I want to export csv file using Maatwebsite in laravel. The process is running well, but in the csv file contains blank line in last data when i open it using notepad. Displayed at image below
This is the function to get the data
public function view(): View
{
$data = DB::table('transaction as a')
->join('transaction_details as b', 'a.id', 'b.header_id')
->select('b.order_number', 'b.changed_number')
->whereIn('a.id', $this->id)
->where('a.approve', 1)
->get();
return view('vendor.voyager.transaction.excel-csv.generate-csv', [
'data' => $data
]);
}
public function getCsvSettings(): array
{
return [
'enclosure' => ''
];
}
This is function to call the function above
public function generate(Request $request)
{
$id = $request->ids;
return Excel::store(new ExportTransaction($id), 'test.csv', 'ftp');
}
How to solve my problem to remove blank line in the csv fie
via Chebli Mohamed
Aucun commentaire:
Enregistrer un commentaire