Laravel excel import undefined index

Question

When I'm trying to import xlsx file I have error:

{
    "message": "Undefined index: $",
    "status_code": 500
}

but if I save this file to csv and try to import all work like a charm. What is wrong with xslx format?

can u show me your code?? – Kuldeep Mishra Jan 23 '18 at 12:55 — Kuldeep Mishra, Jan 23 '18 at 12:55
please, share with us a snippet of your code. – Anderson Andrade Jan 23 '18 at 12:56 — Anderson Andrade, Jan 23 '18 at 12:56

score 6 · Answer 1 · answered Aug 21 '19 at 07:39

6

Just putting my 2 cents....

Check that your excel headings are small letters - $row['SomeHeading'] = $row['someheading']

answered Aug 21 '19 at 07:39

migsAV

289
3
11

score 0 · Answer 2 · answered Jan 23 '18 at 13:56

0

I've found the solution. It's very simple but I can't found it on google for few hours. If you get this error just try to re-save excel file. It's some issue with encoding.

answered Jan 23 '18 at 13:56

rostyslav

49
1
7

Laravel excel import undefined index

2 Answers2