Laravel Excel WithHeadingRow cannot find header index

Question

i have some problem that Laravel WithHeadingRow does not working.

for example, i have this kind of excel file.

productId	productName
2132	example_name

but i can't load rowheader using WithHeadingRow.

code:

class RandomRotationProductImport implements ToModel, WithHeadingRow
{
    public function model(array $row): ?RandomRotationProduct
    {
        return new RandomRotationProduct([
            'product_id' => $row['product_id'],
            'product_name' => $row['product_name']
        ]);
    }

    public function headingRow(): int
    {
        return 0;
    }
}

but this cause the error: "message": "Undefined index: product_id"

is there anything to solve this problem?

Aml · Accepted Answer · 2021-10-27 06:45:24Z

0

i think name must be the same as in file . so it should be
$row['productId']
$row['productName']

answered Oct 27, 2021 at 6:45

Aml

8516 silver badges8 bronze badges

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

1 Comment

sb0321 Over a year ago

I think that is not the answer. if you see this documentation: docs.laravel-excel.com/3.1/imports/heading-row.html, it's formatting automatically. and i also tried your solution

Collectives™ on Stack Overflow

Laravel Excel WithHeadingRow cannot find header index

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related