Importing Multiple Sheets in Laravel Excel:
Laravel Excel is a powerful package that simplifies working with Excel files in Laravel applications. One of the key features of Laravel Excel is the ability to import data from multiple sheets within a single Excel file. This feature is particularly useful when dealing with complex datasets that are organized across various sheets. In this article, we'll explore how to import multiple sheets using Laravel Excel, providing a step-by-step guide to streamline the process.
Getting Started with Laravel Excel
Before diving into importing multiple malaysia phone number" sheets, ensure you have Laravel Excel installed in your Laravel project. If not, you can install it via Composer:
bash
Copy code
composer require maatwebsite/excel
Next, publish the configuration file:
bash
Copy code
php artisan vendor:publish --provider="Maatwebsite\Excel\ExcelServiceProvider" --tag=config
This will create a configuration file at config/excel.php.
Basic Setup for Importing Multiple Sheets
To import data from multiple sheets, you need to define an import class for each sheet. These import classes will handle the data extraction from each respective sheet. Let's walk through the process.
1. Create Import Classes
First, create import classes for each sheet you want to import. For example, if you have an Excel file with two sheets: Users and Orders, create two import classes.
bash
Copy code
php artisan make:import UsersImport --model=User
php artisan make:import OrdersImport --model=Order
These commands will generate import classes in the App\Imports directory.
2. Define Each Import Class
Edit each import class to specify how the data should be imported. For instance, for the Users sheet:
php
Copy code
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],
'password' => \Hash::make($row[2]),
]);
}
}
Similarly, for the Orders sheet:
php
Copy code
namespace App\Imports;
use App\Models\Order;
use Maatwebsite\Excel\Concerns\ToModel;
class OrdersImport implements ToModel
{
public function model(array $row)
{
return new Order([
'order_number' => $row[0],
'user_id' => $row[1],
'amount' => $row[2],
]);
}
}
3. Create a Combined Import Class
Next, create a new import class to combine the individual sheet imports. This class will implement the WithMultipleSheets interface.
bash
Copy code
php artisan make:import MultipleSheetsImport
Edit the MultipleSheetsImport class:
php
Copy code
namespace App\Imports;
use Maatwebsite\Excel\Concerns\WithMultipleSheets;
class MultipleSheetsImport implements WithMultipleSheets
{
public function sheets(): array
{
return [
'Users' => new UsersImport(),
'Orders' => new OrdersImport(),
];
}
}
In the sheets method, return an associative array where the keys are the sheet names and the values are instances of the respective import classes.
4. Handle the Import in a Controller
Finally, create a controller method to handle the file upload and import process.
php
Copy code
namespace App\Http\Controllers;
use App\Imports\MultipleSheetsImport;
use Illuminate\Http\Request;
use Maatwebsite\Excel\Facades\Excel;
class ImportController extends Controller
{
public function import(Request $request)
{
$request->validate([
'file' => 'required|mimes:xls,xlsx',
]);
Excel::import(new MultipleSheetsImport, $request->file('file'));
return back()->with('success', 'Data imported successfully.');
}
}
5. Create a Form for File Upload
Create a simple form in your Blade view to upload the Excel file.
html
Copy code
<form action="{{ route('import') }}" method="POST" enctype="multipart/form-data">
@csrf
<input type="file" name="file" required>
<button type="submit">Import</button>
</form>
Ensure your routes file (routes/web.php) has a route for the import method:
php
Copy code
use App\Http\Controllers\ImportController;
Route::post('import', [ImportController::class, 'import'])->name('import');
Conclusion
Importing multiple sheets in Laravel Excel is a straightforward process that involves creating import classes for each sheet and a combined import class to handle them. By following this guide, you can efficiently manage and import complex datasets organized across multiple sheets in your Laravel applications. This powerful feature of Laravel Excel not only simplifies data handling but also enhances the flexibility and scalability of your application. |
