Search code examples
laravelmaatwebsite-excelexcel-import

Maatwebsite Laravel Excel duplicate records are removed

I am using Maatwebsite Excel 2.1. Now the problem is I have an excel sheet that has 5 column names, out of which two column names are the same. So whenever I do 

Excel::load($path)->get()

I am only getting the value of the last duplicate column. For eg:

COls: First Name, LastName, Phone Number, Company Name, Company Name

Here, when I import it I am getting the value of last company name only and not the 4th one.

I cannot change the column names as they are making excel from third party govt API.

I did my research but did not get any solutions. Please help. Thank you.

Solution

  • You can use PHPExcel function instead