Laravel excel maatwebsite 3.1 import, date column in excel cell returns as unknown format number. How to solve this?

php laravel maatwebsite-excel
Reno Anthus picture Reno Anthus · Mar 28, 2019 · Viewed 19.5k times · Source

By using Maatwebsite/Laravel-Excel version 3.1 to import excel sheet, here I faced an issue date time column of the excel sheet returns unknown number. How to solve this? Example : Consider Cell value "29/07/1989" and returns as "32178" when import.

Answer

Qraxin picture Qraxin · Mar 28, 2019

The numbers come from excel itself, dates stored in excel as numeric values. http://www.cpearson.com/excel/datetime.htm

For Laravel framework 5.6 and maatwebsite/excel package version 3.1, to convert date from excel numbers to normal date format, this function PhpOffice\PhpSpreadsheet\Shared\Date::excelToDateTimeObject($dateFromExcel) can be used. It accepts integer(excel date) and returns DateTime object.

More information can be found here https://github.com/Maatwebsite/Laravel-Excel/issues/1832

From this answer: https://stackoverflow.com/a/55139981/9133724

Related questions

Call to undefined method Maatwebsite\Excel\Excel::load()

I'm trying to import excel file (.xlsx) using maatwebsite 3.0. How to fix This error Call to undefined method Maatwebsite\Excel\Excel::load() My controller public function importsave(Request $request) { if($request->hasFile('excel')) { $path = $request->file('excel')-&…

Read More
Reading excel file in Laravel

I'm using Maatwebsite's library for reading and creating excel file. The creating was easy and somehow intuitive, but when it comes to reading one, I simply can't figure it out. This is how my excel file looks like: I figured …

Read More
PHP Laravel read csv

I have a CSV file where the data is in landscape orientation.ex: name, test name age, 20 gender,Male where the first column is the headers and the second the data, i tried using laravel maatwebsite/Excel and the response …

Read More