Laravel で CSV ダウンロード機能を実装する一例。
文字コードを SJIS で出力する場合の例。
class CsvController extends Controller { public function download() { $users = Users::get(); $response = new StreamedResponse(function () use ($users) { $stream = fopen('php://output', 'w'); stream_filter_prepend($stream, 'convert.iconv.utf-8/cp932//TRANSLIT'); fputcsv($stream, [ 'ID', '名前', 'メールアドレス' ]); foreach ($user as $key => $user) { fputcsv($stream, [ $user->id, $user->name, $user->email, ]); } fclose($stream); }); $file_name = 'ファイル名.csv'; $response->headers->set('Content-Type', 'application/octet-stream'); $response->headers->set('content-disposition', 'attachment; filename=' . $file_name); return $response; } }
class CsvController extends Controller { public function download() { $csv_headers = ['No.', 'Name', 'Date']; $csv_body = []; // DB からデータを読み込むなどし csv_body に格納 return response()->streamDownload( function () use ($csv_headers, $csv_body) { $stream = fopen('php://output', 'w'); mb_convert_variables('SJIS-win', 'UTF-8', $csv_headers); fputcsv($stream, $csv_headers); foreach ($csv_body as $line) { mb_convert_variables('SJIS-win', 'UTF-8', $line); fputcsv($stream, $line); } fclose($stream); }, 'file_name.csv', ['Content-Type' => 'application/octet-stream'] ); } }
コメント