How to import and export excel in laravel

Laravel is a commonly used PHP development framework, which has the characteristics of rapid development and easy maintenance. In actual development, it often involves the import and export of data, more specifically, the import and export of Excel files. How does Laravel implement data import and export? This article will introduce how to import and export Excel files through Laravel.

1. Install Laravel Excel

Laravel Excel is a package for PHPExcel, which can easily import and export Excel files. Therefore, before implementing import and export, we need to install Laravel Excel first.

Install through Composer and execute the following command:

composer require maatwebsite/excel

After the installation is complete, you need to add the following content to config/app.php:

'providers' => [
    // ...
    MaatwebsiteExcelExcelServiceProvider::class,
],

'aliases' => [
    // ...
    'Excel' => MaatwebsiteExcelFacadesExcel::class,
]

2. Excel file export

First, let’s look at how to export Excel files. Laravel Excel provides a way to define the export of Excel files similar to how you define a database data model. We can define the contents of the exported Excel file through an Excel template, and then fill the data into the template. The following is the specific implementation method:

1. Define the Excel file template

Execute the following command in the root directory of the project:

php artisan make:export UsersExport --model=User

This command will be in the app/Exports directory Generate a class named UsersExport below. This class implements the FromModel interface and is used to export data from the model to an Excel file.

2. Fill in data

After defining the Excel file template, we need to fill it with data through code. The code is implemented as follows:

namespace AppHttpControllers;

use AppExportsUsersExport;
use AppHttpControllersController;
use MaatwebsiteExcelFacadesExcel;

class UsersController extends Controller
{
    public function export()
    {
        return Excel::download(new UsersExport, 'users.xlsx');
    }
}

3. Generate Excel file

After completing the data filling, you can generate the Excel file. To perform the export operation, the code is implemented as follows:

Excel::download(new UsersExport, 'users.xlsx');

The above code will generate an Excel file named users.xlsx.

3. Importing Excel files

Importing Excel files is similar to exporting Excel files. You also need a data model to import the data in the Excel file into the database. The following is the specific implementation method:

1. Define Excel file template

First, you need to define a ContractsFromView interface to implement data filling. The code is implemented as follows:

namespace AppImports;

use IlluminateContractsViewView;
use MaatwebsiteExcelConcernsFromView;

class UsersImport implements FromView
{
    private $users;

    public function __construct(array $users)
    {
        $this->users = $users;
    }

    public function view(): View
    {
        return view('exports.users', [
            'users' => $this->users
        ]);
    }
}

In implementation After the interface, you need to define a file named users.blade.php in the resources/views/exports directory. The code is as follows:

<table>
    <thead>
    <tr>
        <th>Name</th>
        <th>Email</th>
        <th>Gender</th>
    </tr>
    </thead>
    <tbody>
    @foreach($users as $user)
        <tr>
            <td>{{ $user['name'] }}</td>
            <td>{{ $user['email'] }}</td>
            <td>{{ $user['gender'] }}</td>
        </tr>
    @endforeach
    </tbody>
</table>

This template will fill user data into an HTML table.

2. Import Excel file

After defining the data model, you can import the data into the database through the Excel::import function of Laravel Excel. The specific code As follows:

namespace AppHttpControllers;

use AppImportsUsersImport;
use MaatwebsiteExcelFacadesExcel;

class UsersController extends Controller
{
    public function import()
    {
        $file = request()->file('file');

        $users = Excel::toArray(new UsersImport, $file);

        // 可以在此处将 $users 插入数据库
    }
}

In the above code, we first select the Excel file through the input box, then obtain the Excel file and convert it into an array type. For imported data, we can insert $users into the database at // where $users can be inserted into the database .

4. Summary

Laravel Excel has provided us with a database-like operation, making it very simple to import and export Excel files. Laravel Excel works seamlessly with Eloquent models and also supports other file formats such as CSV, PDF, and HTML. We only need to install Laravel Excel according to the above method and define the appropriate model to import and export data in Laravel.

The above is the detailed content of How to import and export excel in laravel. For more information, please follow other related articles on the PHP Chinese website!