Laravel 8 Import Excel to MySQL Database Excel file - Codingonly4u

 

Laravel 8 Import Excel to MySQL Database Excel file 

1. Install the new laravel 8 project 
2. Configure Database details and model
3. Install maatwebsite/excel package for excel
4. Create Routes for import
5. Create controller 
6. Create blade / view files
7. Run laravel project with import excelsheet

1. Install laravel project:

In step first, create a new laravel project named excelimport. Use the below command for creating a project

composer create-project laravel/laravel excelimport

2.Configure Database details and make a model:

In the second step, set up database configuration in the .env file in laravel 8.

3. Install maatwebsite/excel Package

composer require maatwebsite/excel

 config/app.php

    'providers' => [ 

      Maatwebsite\Excel\ExcelServiceProvider::class, ], 

    'aliases' => [ 

      'Excel' => 

      Maatwebsite\Excel\Facades\Excel::class, ],

3. Create Route and Files in the Resource view folder

4. Create the Controller method below like this.

in controller first, convert excel to an array using the below command

$data = Excel::toArray(new User(), $request->file('meeting_file'));

Excel has multiple sheets you can select particular sheet like this.

Get Excel Sheet 1 $data[0]

Get Excel Sheet 2 $data[1]

Get Excel Sheet 3 $data[2]

Now Insert data using foreach

foreach($data as $k=>$row)

  {

           //$i = 0;

        foreach($row as $k1=>$row1)

         {

                    /*Skip Heading*/

                    if($k1 == 0)

                        continue;

            

                    $first_excel_column = $row[$k1][0];

                    $second_excel_column = $row[$k1][1];

                    $third_excel_column = $row[$k1][2];

                        

                    // if Excel column has date/time then convert like this

                            

                            $datetime=$second_excel_column ;

                            $unix_date = ($datetime - 25569) * 86400;

                            $datetime = 25569 + ($unix_date / 86400);

                            $unix_date = ($datetime - 25569) * 86400;

                            $datetime_val =  gmdate("Y-m-d H:i:s", $unix_date);

                    $modal=new Modal();

                    $modal->column1=$first_excel_column;

                    $modal->column1=$datetime_val ;

                    $modal->column1=$third_excel_column ;

                    $modal->save();

        }

}