How to Import and Export Excel File in Laravel with Maatwebsite's Excel Package

Introduction:- In the world of web development, efficient data management is crucial for any application. Laravel, a powerful PHP framework, provides developers with a variety of tools to handle data seamlessly. One such tool is the Maatwebsite Excel package, which simplifies the process of how to import and export data in Laravel applications. In this blog post, we'll explore how to apply the Maatwebsite package to effortlessly import and export excel files in the Laravel project.

Getting Started:

In this blog we will learn how to import and export the excel file in Laravel using the Maatwebsite package. To begin, you'll need to install the Maatwebsite Excel package and learn how to apply the import and export of the excel file in Laravel. Open your terminal and run the following command:

 composer require maatwebsite/excel

Once the installation is complete, add the service provider and facade to your

`config/app.php` file:

 'providers' => [
    // ...
    Maatwebsite\Excel\ExcelServiceProvider::class,
],

'aliases' => [
    // ...
    'Excel' => Maatwebsite\Excel\Facades\Excel::class,
],

Now, you're ready to start using the Maatwebsite Excel package in your Laravel project.

Importing Data:

Importing data becomes a breeze with Maatwebsite. Let's assume you have a spreadsheet with user information, and you want to import it into your Laravel application.

Create an Import Class:

Generate an import class using the Artisan command:

php artisan make:import UsersImport --model=User

This command creates an import class in the App\Imports directory.

Define the Import Logic:

In the UsersImport class, define the import logic in the collection method. This method is where you can manipulate the imported data.

namespace App\Imports;

use App\Models\User;
use Maatwebsite\Excel\Concerns\ToModel;

class UsersImport implements ToModel
{
	public function model(array $row)
	{
    	return new User([
        	'name' => $row[0],
        	'email' => $row[1],
        	// Add other fields as needed
    	]);
	}
}

Controller Implementation:

In your controller, use the Excel facade to handle the import process:

use App\Imports\UsersImport;
use Maatwebsite\Excel\Facades\Excel;
use App\Models\User;

class UserController extends Controller
{
	public function import()
	{
    		$resultData = Excel::toArray(new UsersImport, 'users.xlsx');
		foreach($resultData as $row)
    		{
			$user = new User;
			$user->name = $row[‘name’];
			$user->email = $row[‘email’];
			$user->save();			
		}
    		return redirect()->route('users.index')->with('success', 'Users imported successfully!');
	}
}

Exporting Data:

Exporting data is just as straightforward. Assume you want to export a list of users to a spreadsheet.

Create an Export Class

Generate an export class using the Artisan command:

php artisan make:export UsersExport --model=User

This command creates an export class in the App\Exports directory.

Define the Export Logic:

In the UsersExport class, define the export logic in the collection method. This method is where you can customize the data you want to export.

namespace App\Exports;

use App\Models\User;
use Maatwebsite\Excel\Concerns\FromCollection;

class UsersExport implements FromCollection
{
	public function collection()
	{
    		return User::all();
	}
}

Controller Implementation:

In your controller, use the Excel facade to handle the export process:

use App\Exports\UsersExport;
use Maatwebsite\Excel\Facades\Excel;

class UserController extends Controller
{
	public function export()
	{
    		return Excel::download(new UsersExport,’users’.date('Y-m-d').'.csv',
            	Excel:CSV, ['Content-Type' => 'text/csv']
        	);
	}
}

Conclusion

By incorporating the Maatwebsite Excel package into your Laravel project, you can significantly streamline the process of importing and exporting data. Whether you're dealing with user information, product details, or any other data set, Maatwebsite provides an elegant solution to enhance your application's data management capabilities. Take advantage of the flexibility and simplicity offered by this package to empower your Laravel applications with seamless data handling.