import export data into excel

Aturannya :

Saya Menggunakan :
Php Versi (7.2.6)
Laravel Versi (5.5)

1. Masukan kedalam composer.json=> "maatwebsite/excel": "~2.1.0"

2. Buka config/app.php

'providers' => [ .... 'Maatwebsite\Excel\ExcelServiceProvider', ], 'aliases' => [ .... 'Excel' => 'Maatwebsite\Excel\Facades\Excel', ],

     kemudian ketikan di terminal=> composer update

3. Buat Controller dengan file DataKaryawanController.php

<?php namespace App\Http\Controllers\admin; use Illuminate\Http\Request; use App\Http\Controllers\Controller; use Illuminate\Support\Facades\Redirect; use App\Product; use App\DataKaryawan; class ExcelController extends Controller { /** * Create a new controller instance. * * @return void */ public function importExportView(){ return view('import_export'); } /** * Create a new controller instance. * * @return void */ public function importFile(Request $request){ if($request->hasFile('sample_file')){ $path = $request->file('sample_file')->getRealPath(); $data = \Excel::load($path)->get(); if($data->count()){ foreach ($data as $key => $value) { $arr[] = ['title' => $value->title, 'body' => $value->body]; } if(!empty($arr)){ DB::table('products')->insert($arr); dd('Insert Recorded successfully.'); } } } dd('Request data does not have any files to import.'); } /** * Create a new controller instance. * * @return void */ public function exportFile($type){ $products = Product::get()->toArray(); return \Excel::create('hdtuto_demo', function($excel) use ($products) { $excel->sheet('sheet name', function($sheet) use ($products) { $sheet->fromArray($products); }); })->download($type); } }

4.Tambahkan pada routes=>web.php

Route::get('export-file-karyawan/{type}', 'admin\DataKaryawanController@exportFile')->name('export.file_karyawan');

5. Buat File didalam folder views simpan dengan perhitungangaji.blade.php

@extends('layouts.admin') @section('content') <section class="content-header"> <h1> Data Karyawan </h1> <ol class="breadcrumb"> <li><a href="#"><i class="fa fa-dashboard"></i>Home</a></li> <li class="active"><a href="{{URL::to('datakaryawan/index')}}">List Data Karyawan</a></li> </ol> </section> <section class="content"> <div class="row"> <div class="col-md-12"> <div class="pull-left"> {!! Form::open(['method'=>'GET','url'=>'/searchdatakaryawan','role'=>'search']) !!} <div class='form-group clearfix'> <div class='col-md-10'> <div class="input-group custom-search-form"> <input type="text" class="form-control" name="search" placeholder="Search..."> <span class="input-group-btn"> <span class="input-group-btn"> <button class="btn btn-default" type="submit"><i class="fa fa-search"></i> Search</button> </span> </span> </div> </div> </div> {!! Form::close() !!} </div> <div class="row"> <div class="col-xs-12 col-sm-12 col-md-12"> </div> </div> <div class='pull-right'> <button type="button" class="btn btn-default btn-sm"> <a href="{{ route('export.file_karyawan',['type'=>'xls']) }}"> <span class="glyphicon glyphicon-save-file"></span> Save File </a> </button> </div> <br> <table class="table table-striped table-hover"> <thead> <tr> <th>No.</th> <th><b>Nama</b></th> <th><b>NIP/NIDN</b></th> <th><b>Gaji</b></th> <th><b>Tunjangan</b></th> <th><b>Total Gaji</b></th> </tr> </thead> <status> @foreach($data_karyawan as $i=>$data_karyawans) <tr> <td>{{$i+1}}</td> <td> {{ $data_karyawans->nama_lengkap }} </td> <td> {{ $data_karyawans->nip }} </td> <td> {{ $data_karyawans->gaji }} </td> <td> {{ $data_karyawans->gaji*0.01 }} </td> <td> {{ $data_karyawans->gaji*0.01 + $data_karyawans->gaji+400000 }} </td> </tr> @endforeach </tstatus> </table> </div> </div> </section> @endsection