|All requests||>||Import Excel CSV into MySQL table||>||Request new recommendation||>||Featured requests||>||No recommendations|
by RAJESH BHATT - 7 years ago (2015-07-17)
I have tables in MySQL database. This is the structure of my database tables:
table 1 - tbl_main_categories:
My excel sheet data as follows(product.xls)
How to import file product.xls to MySQL table (tbl_products), as it contains ids from table tbl_sub_categories where as in my Excel there is name of sub_categories?
Please suggest me a library as I am beginner to PHP world.
by Manuel Lemos 22420 - 7 years ago (2015-07-20) Comment
You can use this class if you export your Excel spreadsheet to the CSV format.
It is important that the spreadsheet headers match the database field names.