# 安裝 maatwebsite/excel ~~~ composer require maatwebsite/excel ~~~ # 下載 excel ~~~ $titles = [ '用戶ID', '用戶昵稱', '公司名稱', '銷售', '功能版本', '次數', '最高', '消耗', '剩余', '時間' ]; //使用 Excel::create $data_arr=[$titles,['user_id'=>100,'nick_name'=>'xxx','company'=>'百度','seller_name'=>'老王','user_type'=>1,'times'=>666,'top'=>100,'flows'=>88,'rest'=>123,'time'=>date('YmdHis')]];//從數據庫讀取的結果 //http://www.maatwebsite.nl/laravel-excel/docs/export \Excel::create('excel', function($excel) use($data_arr){ $excel->sheet('Sheetname', function($sheet) use($data_arr) { $sheet->fromArray($data_arr, null, 'A1', false, false); }); })->store('xlsx',storage_path('excel/exports')); ~~~ # 發送郵件 ~~~ // https://docs.golaravel.com/docs/5.0/mail/ 郵件配置參考 #cat .env MAIL_DRIVER=smtp MAIL_HOST=smtp.exmail.qq.com MAIL_PORT=25 MAIL_USERNAME=xxx@xxx.com MAIL_PASSWORD=xxx #cat config/mail.php //模板文件 #cat resources/views/emails/attachment.balde.php 附件內容：{{$content}} <br> 發送時間：{{date('Y-m-d H:i:s')}} //重試 3次 $tryTimes=3; do { $email='xxx@xx.com'; $attachments=['file'=>storage_path('excel/exports').'/excel.xlsx'];//上面下載的 excel 附件 $subject='mail'; $cc='xxx@xx.com';//抄送郵件 $sendResult = \Mail::send('emails.attachment', ['content' => '發送內容'], function ($message) use ($email, $attachments, $subject, $cc) { $message->to($email)->subject($subject); foreach ($attachments as $alias => $attachment) { $ext = pathinfo($attachment)['extension']; $message->attach($attachment, ['as' => "=?UTF-8?B?" . base64_encode($alias) . "?=." . $ext]);// } if (!empty($cc)) { $message->cc($cc); } }); $tryTimes--; } while ($sendResult == 0 && $tryTimes); dd($sendResult);//發送成功 2 ~~~