import date data from excel file to database using maatwebsite excel / laravel

Question

I'm trying to import data from excel file to database using maatwebsite excel package,

I'm using the following code :

namespace App\Imports;

use Maatwebsite\Excel\Facades\Excel;
use PhpOffice\PhpSpreadsheet\Spreadsheet\Shared\Date;
use App\Models\Casting;
use Carbon\Carbon;
use Illuminate\Support\Facades\Hash;
use Maatwebsite\Excel\Concerns\ToModel;
use Maatwebsite\Excel\Concerns\ToCollection;
use Illuminate\Validation\Rule;
use Maatwebsite\Excel\Concerns\WithValidation;
use Maatwebsite\Excel\Concerns\Importable;
use Maatwebsite\Excel\Concerns\WithHeadingRow;
use Auth;

class ProjectsImport implements ToModel,WithHeadingRow,WithValidation


{


     use Importable;
    /**
    * @param array $row
    *
    * @return \Illuminate\Database\Eloquent\Model|null
    */
public function model(array $row)
    {
 
  $casting = new Casting();
  $casting->date_naissance = Date::excelToTimestamp($row['date_naissance']);

}

}

But doens't work , I get the following error :

"message": "Class 'PhpOffice\\PhpSpreadsheet\\Spreadsheet\\Shared\\Date' not found",

If you have any idea please help !

BSMP · Accepted Answer · 2021-08-04 07:51:03Z

1

When you use dd() on the date column from Excel you'll see that the data comes parsed as a number WITHOUT ANY SEPARATORS. The lack of separators is what brings about the challenge as your database will be expecting data in DATE format but you will be trying to update/create a record with an integer.

SOLUTION

You can use the PHP Carbon Extension for Date and Time to convert Excel date format into PHP date format.

Simply go through the documentation and you should be up and running in no time.

edited Aug 4, 2021 at 7:51

BSMP

4,9008 gold badges36 silver badges46 bronze badges

answered Aug 3, 2021 at 23:19

Charles

3823 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

saadia Over a year ago

thank you for your answer , but the problme in in the Class 'PhpOffice\\PhpSpreadsheet\\Spreadsheet\\Shared\\Date not found

Charles Over a year ago

Hope you came right. Have been away a bit from StackOverflow.

Abhishek Trivedee · Accepted Answer · 2022-03-23 14:25:14Z

0

This is work for me in latest version of maatwebsite excel/laravel package.

$excel_date = $row[13]; //Your row line date that is : 3/17/2022
$uniq_date = ($excel_date - 25569) * 86400;
$date = gmdate('Y-m-d H:i:s', $uniq_date);

dd($date);

Output : "2022-03-17 00:00:00"

answered Mar 23, 2022 at 14:25

Abhishek Trivedee

112 bronze badges

Comments

pankaj · Accepted Answer · 2024-12-26 17:06:13Z

0

use the Carbon date function. Note that the imported file format should be a CSV file.

 Carbon::createFromFormat('d/m/Y', $row['date_column']);

answered Dec 26, 2024 at 17:06

pankaj

1,97026 silver badges37 bronze badges

Collectives™ on Stack Overflow

import date data from excel file to database using maatwebsite excel / laravel

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related