sql - How to convert Excel data into mysql without installing the plugin -

sql - How to convert Excel data into mysql without installing the plugin -

i have excel file contains details database 8 columns & 8000 rows.this info should converted in mysql. i utilize python not sure library back upwards conversion. file have xls.i want .sql file conversion. help me python code/suggest other alternative???

to convert excel file sql file python 1 of best options. there xlrd library. next used load excel file.

class="snippet-code-html lang-html prettyprint-override">import xlrd book = xlrd.open_workbook("<file_name>") sheet = book.sheet_by_name("<sheet_name>") database = mysqldb.connect (host="localhost", user = "root", passwd = "<password>", db = "<db_name>")

mysql sql excel