Laravel PHPExcel 使用

原作者的

https://github.com/PHPOffice/PHPExcel
https://github.com/PHPOffice/P ... ng.md
---

laravel包

https://github.com/Maatwebsite/Laravel-Excel

https://github.com/Maatwebsite ... ME.md

Installation

Require this package in your composer.json and update composer. This will download the package and PHPExcel of PHPOffice.

"maatwebsite/excel": "~2.0.0"

After updating composer, add the ServiceProvider to the providers array in config/app.php

'Maatwebsite\Excel\ExcelServiceProvider',

You can use the facade for shorter code. Add this to your aliases:

'Excel' => 'Maatwebsite\Excel\Facades\Excel',

The class is bound to the ioC as excel

$excel = App::make('excel');

To publish the config settings in Laravel 5 use:

php artisan vendor:publish

This will add an excel.php config file to your config folder.

注:  app里面设置好后providers，aliases设置好后，在需要用到的控制器里use Excel;之后就可以直接用了，如：导出

Excel::create($filename, function($excel) use($data) {
        $excel->sheet('Sheetname', function($sheet) use($data) {
            $sheet->fromArray($data);
        });

    })->download('xls');

http://www.maatwebsite.nl/laravel-excel/docs/export

1.Excel可以支持100万行记录，Excel 2003最大支持65536行，从2007版开始支持104万行，Excel极限是65536条。