Why Laravel-Excel reads first row as column name

Question

I need to read an .xls file and put it into an array. I'm using laravel-excel package for reading excel files.

I have a Excel file like this :

I need to have an array like this :

[
 '9921234567' => 'First Text',
 '9929876544' => 'Second Text',
 '9927654321' => 'Third Text',
 '9928765432' => 'Fourth Text',

]

What I have tried so far :

 Excel::load('sample.xls', function($reader) {
     $reader->dd();
 });

Problem:

The problem is it reads the first row as column!

0 => RowCollection {#619
      #title: "Sheet1"
      #items: array:3 [
        0 => CellCollection {#623
          #title: null
          #items: array:2 [
            9921234567 => 9929876544.0
            "first_text" => "Second Text"
          ]
        }
        1 => CellCollection {#624
          #title: null
          #items: array:2 [
            9921234567 => 9927654321.0
            "first_text" => "Third Text"
          ]
        }
        2 => CellCollection {#625
          #title: null
          #items: array:2 [
            9921234567 => 9928765432.0
            "first_text" => "Fourth Text"
          ]
        }
      ]
    }

Look, I don't want to first row values count as column name!

Any helps would be great appreciated.

Community · Accepted Answer · 2020-06-20 09:12:55Z

6

You linked answer in documentation

Table heading as attributes By default the first row of the excel file will be used as attributes.

You can change the default inside the config excel::import.heading. Available options are: true|false|slugged|ascii|numeric|hashed|trans|original

I never used laravel but just set it to false and check what will happen.

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Mar 21, 2017 at 8:42

Vini

6265 silver badges18 bronze badges

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

Comments

J.C. Gras · Accepted Answer · 2019-02-07 16:51:43Z

1

The documentation says:

By default the first row of the Excel file will be used as attributes

So, I recommend to use noHeading function:

Excel::load('sample.xls', function($reader) {
     $reader->noHeading();
     $reader->dd();
 });

answered Feb 7, 2019 at 16:51

J.C. Gras

5,4621 gold badge44 silver badges46 bronze badges

Comments

KuKeC · Accepted Answer · 2017-03-21 08:43:08Z

0

You need to loop thru each row. After that you can create your custom array when you loop thru all columns

Excel::load('sample.xls', function($reader) {
    $reader->each(function($sheet) {
        // Loop through all rows
        $sheet->each(function($row) {
            // Loop through all columns
        });
    });
})

This is just basic code for excel import, you need to adjust it to your example.

Hope it helps

answered Mar 21, 2017 at 8:43

KuKeC

4,6405 gold badges34 silver badges62 bronze badges

1 Comment

Hamed Kamrava Over a year ago

No no... same problem

Collectives™ on Stack Overflow

Why Laravel-Excel reads first row as column name

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related