Level 5
an excel file and a db table is inherently 2 different things. There is no way to convert an excel table to a database table
Nov 20, 2022
6
Level 8
Creating database tables with excel file uploads
Hey Folks,
Is there any laravel package or library that helps in excel file upload and store it as a database table?
Any information here will be very helpful.
Thanks,
Level 17
As @lumethys said... Or do you want to store the contents of an excel file in a table? Then this https://laravel-excel.com/ could help a lot...
Level 8
Yeah @krs I want to store the contents on a table but with headers on the excel becoming columns and data being stored in rows. I don't want to be defining the models before hand, I want the tables to be created dynamically. Thanks, I will check the package out.
Level 102
@madprabh where would the table name come from? And I assume all columns will just be varchar or similar?
use this package to easily get the table row, and convert that to a create table sql query https://github.com/spatie/simple-excel#retrieving-header-row-values
It can also load the data to you can insert it
Level 8
@Sinnbeck The table name will be provided by the user and to being with all columns can be considered varchar but in the near future I'd like to detect the type of data and set the column accordingly.
Thank you so much for this. I will check this out.
Level 102
@madprabh You can of course try detecting the type of data, but be aware that excel encodes certain fields in a weird way. For instance dates are integers. There might be a way to detect the format from excel (never needed to so I havent dug into it)
Please or to participate in this conversation.