How to map dynamic excel rows to sql database columns

Question

I am trying to import an excel using Laravel with dynamically changing columns(names as well as sequence) . I am looking for a way to map these columns against Sql db columns.

Mudassar Zahid · Accepted Answer · 2020-01-25 12:50:41Z

1

Please share your code for clarification;

you can use this package to import and change dynamically in callback;

https://github.com/rap2hpoutre/fast-excel

$users = (new FastExcel)->import('file.xlsx', function ($line) {
    //here you can perform custom action on your data
    return User::create([
        'name' => $line['Name'],
        'email' => $line['Email']
    ]);
});

answered Jan 25, 2020 at 12:50

Mudassar Zahid

112 bronze badges

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

Collectives™ on Stack Overflow

How to map dynamic excel rows to sql database columns

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related