php lavarel框架导出文件

php artisan make:controller ExcelController --plain

Route::get('excel/export','ExcelController@export');

Route::get('excel/import','ExcelController@import');

<?php

namespace App\Http\Controllers;

use Illuminate\Foundation\Bus\DispatchesJobs;

use Illuminate\Routing\Controller as BaseController;

use Illuminate\Foundation\Validation\ValidatesRequests;

use Illuminate\Foundation\Auth\Access\AuthorizesRequests;

use PHPExcel;//引入excel类

use IOFactory;

use DB;

class ExcelController extends Controller

{

     //导出

    public function Excel(){

        $query=DB::table('change')->get();//查询表

        //print_r($query);

        if(!$query) return false;//判断是否为空值

        $obj=new PHPExcel();//实例化excel类

        include_once('../app/libs/PhpExcel/PHPExcel/IOFactory.php');//引入IOFactory.php

        $obj->getProperties()-> setTitle("export") ->setDescription("none");

        $obj-> setActiveSheetIndex(0);

        $fields = DB::select("SHOW COLUMNS FROM `change`");//查询goods表中所有列名

         //print_r($fields);die;

        $col = 0;//定义列

        foreach($fields as $field){

            $field =$field['Field'];

            $obj-> getActiveSheet() -> setCellValueByColumnAndRow($col, 1,$field);

            $col++;

        }

        $row = 2;//定义行

        foreach($query as $data)

        {

            $col =0;

            foreach($fields as $field)

            {

                //print_r($data);

                $field =$field['Field'];

                $obj->getActiveSheet()->setCellValueByColumnAndRow($col,$row,!empty($data["$field"])?$data["$field"]:'');

                $col++;

            }

            $row++;

        }

        $obj-> setActiveSheetIndex(0);

        $objWriter =IOFactory :: createWriter($obj, 'Excel5');

        header('Content-Type:application/vnd.ms-excel');

        header('Content-Disposition:attachment;filename="Brand_' .date('Y-m-d') . '.xls"');

        header('Cache-Control:max-age=0');

        $objWriter-> save('php://output');

    }

}

//Excel文件导入功能

    public function import()

    {

        $filePath = 'storage/exports/'.iconv('UTF-8', 'GBK', '用户信息').'.xls';

        Excel::load($filePath, function($reader) {

            $data = $reader->all();

            dd($data);

        });

}