Level 33
here an excellent package for Excel Import and Export
try this one may help you
I want to upload an excel file to my database, but my database tables have this structure
$table->id();
$table->string('orderNumb');
$table->integer('customer_id');
$table->string('loading_point');
$table->date('looade_date');
$table->string('border_name');
$table->integer('team_id');
$table->string('truck_number');
$table->string('trailer_number');
$table->integer('master_qty');
$table->integer('slave_qty');
How can i insert team_id,border_id because a user can not know this ids because this ids comes from another table,
what can i do a user can fill the name as well and import the excel without mixed the data.
Please or to participate in this conversation.