Advertisement
gundambison

controller excel

Jun 20th, 2020
1,278
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.75 KB | None | 0 0
  1. <?php
  2. /*
  3. https://docs.laravel-excel.com/2.1/blade/styling.html
  4.  
  5. Routes
  6.     Route::get('/importing','Excels@index');
  7.     Route::post('/importing','Excels@import');
  8. */
  9. namespace App\Http\Controllers;
  10. use App\Http\Controllers\Controller;
  11. use Excel;
  12. use Illuminate\Http\Request;
  13.  
  14. class Excels extends Controller{
  15. private $datas;
  16.     function index()
  17.     {
  18.         $data=[];
  19.         return view('demo.excel', $data);
  20.    
  21.     }
  22.  
  23.     function import(Request $res){
  24.         $this->datas=['title'=>'Gunawan'];
  25.         Excel::create('New file', function($excel ) {
  26.        
  27.         $excel->sheet('New sheet', function($sheet) {
  28.  
  29.             $sheet->loadView('demo.excel_import',$this->datas);
  30.  
  31.         });
  32.  
  33.         })->download('xlsx');
  34.  
  35.     }
  36. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement