要導(dǎo)出CSV或Excel文件，推薦使用Maatwebsite/Laravel-Excel包。 1. 安裝該包：composer require maatwebsite/excel；2. 可選發(fā)布配置：php artisan vendor:publish；3. 創(chuàng)建導(dǎo)出類：php artisan make:export；4. 在控制器中調(diào)用Excel::download方法返回下載響應(yīng)；5. 自定義導(dǎo)出數(shù)據(jù)可通過實現(xiàn)collection或query方法；6. 使用WithHeadings、WithMapping等接口控制格式；7. 大數(shù)據(jù)量時啟用FromQuery和onQueue隊列處理以優(yōu)化性能。

When you need to export data to CSV or Excel in a Laravel application, there are a few solid packages that make the process straightforward. The most commonly used one is Maatwebsite/Laravel-Excel , which supports both formats and integrates smoothly with Laravel's ecosystem.

Why use a package instead of writing your own?

Trying to handle CSV or Excel exports manually can lead to messy code and edge cases (like handling commas inside fields, encoding issues, or complex Excel formatting). Using a well-maintained package like Laravel Excel saves time and avoids common pitfalls.

Install and set up Laravel Excel

To get started, install the package via Composer:

 composer require maatwebsite/excel

Then, publish the configuration (optional but recommended):

 php artisan vendor:publish --provider="Maatwebsite\Excel\ExcelServiceProvider"

This gives you access to config files where you can tweak things like default export format, delimiter for CSVs, etc.

Once installed, you can create an export class using Artisan:

 php artisan make:export UsersExport --model=User

This generates a class in the App/Exports directory where you define what data to return.

Exporting data from a controller

You don't want users triggering exports directly from a model or command line — it should happen in a controller so you can return the file as a downloadable response.

Here's how to do it in a controller method:

 use App\Exports\UsersExport;
use Illuminate\Http\Request;
use Maatwebsite\Excel\Facades\Excel;

public function exportUsers(Request $request)
{
    return Excel::download(new UsersExport(), 'users.csv');
}

Change 'users.csv' to 'users.xlsx' if you prefer Excel format. This will trigger a file download when the route is accessed.

Make sure to define the route properly:

 Route::get('/export-users', [UserController::class, 'exportUsers'])->name('export.users');

Customizing the exported data

If you need to modify the data before exporting (eg, filter by date, add computed columns), open your export class and adjust the collection() or query() method.

For example, filtering users created in the last 30 days:

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

class UsersExport implements FromCollection
{
    public function collection()
    {
        return User::where('created_at', '>=', now()->subDays(30))->get();
    }
}

Or if you want to format specific cells or rows, you can implement additional concerns like WithMapping , WithHeadings , or ShouldAutoSize .

Some useful interfaces include:

• WithHeadings – to define custom column headers
• WithMapping – to transform each row before export
• ShouldAutoSize – to automatically adjust column widths in Excel

These give you fine-grained control over the final output without reinventing the wheel.

Handling large datasets efficiently

If you're exporting thousands of records, memory usage can become an issue. Laravel Excel has built-in support for chunked queries and queue-based exports to avoid timeouts and high memory consumption.

To export large datasets in chunks, update your export class like this:

 use Maatwebsite\Excel\Concerns\FromQuery;
use Maatwebsite\Excel\Concerns\Exportable;

class UsersExport implements FromQuery
{
    use Exportable;

    public function query()
    {
        return User::query(); // Automatically chunks the query
    }
}

And optionally, dispatch the export to a queue:

 public function exportUsers(Request $request)
{
    return Excel::download(new UsersExport(), 'users.xlsx')->onQueue('exports');
}

This way, the export runs in the background, and the user doesn't have to wait for it to finish.

Depending on your needs, Laravel Excel can be simple or quite powerful. Whether you're just exporting a list of users or generating complex reports with styling and formulas, it's got you covered. Just remember to keep your export logic clean, test different formats, and optimize for performance when needed.

基本上就這些。

以上是將數(shù)據(jù)導(dǎo)出到Laravel中的CSV/Excel（提及通用軟件包）。的詳細內(nèi)容。更多資訊請關(guān)注PHP中文網(wǎng)其他相關(guān)文章！