/** * Bind PHPExcel classes * @return void */ protected function bindPHPExcelClass() { // Set object $me = $this; // Bind the PHPExcel class $this->app['phpexcel'] = $this->app->share(function () use($me) { // Set locale $me->setLocale(); // Set the caching settings $me->setCacheSettings(); // Init phpExcel $excel = new PHPExcel(); $excel->setDefaultProperties(); return $excel; }); }
/** * Create a new file * @param $filename * @param callable|null $callback * @return LaravelExcelWriter */ public function create($filename, $callback = null) { // Writer instance $writer = clone $this->writer; // Disconnect worksheets to prevent unnecessary ones $this->excel->disconnectWorksheets(); // Inject our excel object $writer->injectExcel($this->excel); // Set the filename and title $writer->setFileName($filename); $writer->setTitle($filename); // Do the callback if ($callback instanceof Closure) { call_user_func($callback, $writer); } // Return the writer object return $writer; }
// Route::get('/dynamic_table', function () { // return view('test/dynamic_table'); // }); // Route::get('/index', function () { // return view('test/horizontal_menu'); // // }); // Route::get('/',) Route::get('/', 'HomeController@index'); Route::get('/assets', 'AssetController@index'); Route::post('/getdevicefromasset', 'AssetController@getdevicefromasset'); Route::get('/device', 'DeviceController@index'); Route::post('/getassetfromdevice', 'DeviceController@getassetfromdevice'); Route::post('/createdevice', 'DeviceController@createdevice'); Route::get('/people', 'PeopleController@index'); Route::post('/createpeople', 'PeopleController@createpeople'); Route::get('/service', 'ServiceController@index'); Route::post('/createservice', 'ServiceController@createservice'); Route::get('/editdevice/{id}', 'DeviceController@edit'); Route::post('/editdevice/{id}', 'DeviceController@editdevice'); Route::post('/deleteasset', 'AssetController@deleteAsset'); Route::post('/deletedevice', 'DeviceController@deletedevice'); Route::post('/deletedeviceall', 'DeviceController@deletedeviceall'); Route::get('/test', function () { $rows = array(array('id' => 1, 'name' => 'marlon')); PHPExcel::create($name, function ($excel) use($rows) { $excel->sheet('当天报名', function ($sheet) use($rows) { $sheet->fromArray($rows); }); })->store('xls', storage_path('excel')); }); Route::post('/search', 'HomeController@search');