Import Export to Excel and CSV using Maatwebsite in Laravel 5

In this section, we are going to use Maatwebsite so that we can import-export to CSV and Excel. We will use Laravel 5 to do this. We will use a database to store the imported CSV or Excel file. By using the Maatwebsite, we can download or export CSV or Excel files from the table of our database.

We can easily get the data by using the package of Maatwebsite. It is also useful to group by data, and we can create multiple sheets. In our below example, we have described the items table data. We can use CSV, XLS, and XLSV format to download it, and we can also use the file of CSV, XLS, and XLSX to import the data. In our Laravel 5 project, we can implement export and import function by following the step by step process, which is described as follows:

Step 1:

In this step, we will do Installation. We will use our file named composer.json and then use the required package and put the following line into it according to our Laravel version.

Laravel 5

Laravel 4

Now we will run the following command:

Now we will use our file named config/app.php, and then we will add the aliase and service provider into it:

  ‘providers’ => [  ….  ‘MaatwebsiteExcelExcelServiceProvider’,  ],  ‘aliases’ => [  ….  ‘Excel’ => ‘MaatwebsiteExcelFacadesExcel’,  ],  

Config

We will use the below command if we use Laravel 5 like this:

We will use the below command if we use Laravel 4 like this:

In order to create a config file, this command will be very useful. This file will be used in the excel package.

Step 2:

In the second step, we are going to Create Table and Model. We will use the item table to create a migration. We will create this by using the php artisan command of Laravel 5, which is described as follows:

When we successfully execute the above command, we will use the database/migrations path to get the one file. Now we will use our migration file and add the following code into it to create item tables like this:

  use IlluminateDatabaseSchemaBlueprint;  use IlluminateDatabaseMigrationsMigration;  class CreateItemsTable extends Migration  {     public function up()     {         Schema::create(‘items’, function (Blueprint $table) {             $table->increments(‘id’);             $table->string(‘title’);             $table->text(‘description’);             $table->timestamps();         });     }     public function down()     {         Schema::drop(“items”);     }  }  

When we successfully create this “items” table, we need to create an Item model. For this, we will use the app/Item.php path, and then we will add the following code into it:

app/item.php:

  namespace App;  use IlluminateDatabaseEloquentModel;  class Item extends Model  {     public $fillable = [‘title’,’description’];  }  

Step 3:

In this step, we are going to Create Route. We will create this for the import-export file. For this, we will use our file named app/Http/routes.php, and then we will put the below route:

  Route::get(‘importExport’, ‘MaatwebsiteDemoController@importExport’);  Route::get(‘downloadExcel/{type}’, ‘MaatwebsiteDemoController@downloadExcel’);  Route::post(‘importExcel’, ‘MaatwebsiteDemoController@importExcel’);  

Step 4:

In this file, we are going to Create Controller. We will Create MaatwebsiteDemoController as a new controller. We will use the app/Http/Controllers/MaatwebsiteDemoController.php path to create this controller. All importExcel requests, importExport, return response, and downloadExcel can be managed by this controller. Now we will use the controller file and add the following content into it:

app/Http/Controllers/MaatwebsiteDemoController.php:

  use Input;  use AppItem;  use DB;  use Excel;  class MaatwebsiteDemoController extends Controller  {  public function importExport()  {  return view(‘importExport’);  }  public function downloadExcel($type)  {  $data = Item::get()->toArray();  return Excel::create(?tutoraspire?_example’, function($excel) use ($data) {  $excel->sheet(‘mySheet’, function($sheet) use ($data)          {  $sheet->fromArray($data);          });  })->download($type);  }  public function importExcel()  {  if(Input::hasFile(‘import_file’)){  $path = Input::file(‘import_file’)->getRealPath();  $data = Excel::load($path, function($reader) {  })->get();  if(!empty($data) && $data->count()){  foreach ($data as $key => $value) {  $insert[] = [‘title’ => $value->title, ‘description’ => $value->description];  }  if(!empty($insert)){  DB::table(‘items’)->insert($insert);  dd(‘Insert Record successfully.’);  }  }  }  return back();  }  }  

Step 5:

In this step, we are going to Create View. We will create layout by creating the file named importExport.blade.php. This file will be useful to write the design code. We will add the below code into that file:

importExport.blade.php:

  <html lang=”en”>  <head>  <title>Import – Export Laravel 5</title>  <link rel=”stylesheet” href=”https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css” >  </head>  <body>  <nav class=”navbar navbar-default”>  <div class=”container-fluid”>  <div class=”navbar-header”>  <a class=”navbar-brand” href=”#”> Laravel 5 – Import and Export CSV and Excel </a>  </div>  </div>  </nav>  <div class=”container”>  <a href=”../{{ URL::to(‘downloadExcel/xls’) }}”><button class=”btn btn-success”>Download Excel xls</button></a>  <a href=”../{{ URL::to(‘downloadExcel/xlsx’) }}”><button class=”btn btn-success”>Download Excel xlsx</button></a>  <a href=”../{{ URL::to(‘downloadExcel/csv’) }}”><button class=”btn btn-success”>Download CSV</button></a>  <form style=”border: 4px solid #a1a1a1;margin-top: 15px;padding: 10px;” action=”{{ URL::to(‘importExcel’) }}” class=”form-horizontal” method=”post” enctype=”multipart/form-data”>  <input type=”file” name=”import_file” />  <button class=”btn btn-primary”>Import File</button>  </form>  </div>  </body>  </html>  

Now our above script is ready to run. In order to run the above script quickly, we will use our browser. When we open the browser, we will see the preview like this:

Import Export to Excel and CSV using Maatwebsite in Laravel 5

Import File:

Import Export to Excel and CSV using Maatwebsite in Laravel 5

Next TopicSend Email with Laravel 7/6 using Markdown Mailable Class

advantage of laravel features of laravel history of laravel how to install laravel laravel forms laravel hashing laravel installation laravel interview questions laravel introduction laravel routing laravel tutorial laravel views what is laravel xampp installation

Import Export to Excel and CSV using Maatwebsite in Laravel 5

Import Export to Excel and CSV using Maatwebsite in Laravel 5

Add remove input fields dynamically using jQuery with Bootstrap

Best Laptops for Machine Learning

You may also like