I have a requirement to send multiple emails at once by importing an Excel file. Currently, I am successfully importing the Excel file and storing the data in a variable as an array. I am utilizing maatwebsite/excel version 3.1 for this task. However, after importing the file, the data is being stored in the variable as a nested array with null values in the remaining columns of the Excel file. I attempted to use array_filter but encountered issues. You can view the current response screenshot here - response in console .
Within EmailsController:
public function sendEmailUsingFileAndSave(Request $request)
{
//variables like $content, $fromemail, $fromname are defined here
$file = $request->file('file');
$import = new EmailsImport;
Excel::import($import, $file);
return $emails = $import->data;
foreach($emails as $email)
{
Mail::send('email.content', ['content' => $content], function($message)
use ($email, $subject, $fromemail, $fromname) {
$message->to($email)->subject($subject);
$message->from($fromemail, $fromname);
});
}
}
Located in app\imports folder, EmailsImport.php contains:
<?php
namespace App\Imports;
use Illuminate\Support\Collection;
use Maatwebsite\Excel\Concerns\ToCollection;
use Maatwebsite\Excel\Concerns\Importable;
use Maatwebsite\Excel\Concerns\WithValidation;
class EmailsImport implements ToCollection, WithValidation
{
use Importable;
public $data;
public function collection(Collection $rows)
{
$this->data = $rows;
}
}
The expected response should be:
(2) ["<a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="7312111033160b121e031f165d101c1e">[email protected]</a>","<a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="93ebeae9d3f6ebf2fee3fff6bdf0fcfe">[email protected]</a>", "<a href="/cdn-cgi/l/email-protection" class="__cf_email__" data-cfemail="a2c3c0c1e2c3cccdd6cac7d08cc1cdcf">[email protected]</a>"]You can download a sample Excel file here - sample excel file
I have been facing challenges with this process for some time now. Would appreciate any assistance in resolving this issue.