How to convert Excel data into mysql without installing the plugin
Question: I have an Excel file which contains details about a database with 8 columns &
8000 rows.This data should be converted in to MySql. **I would like to use
python but not sure which library would support this conversion.** The file
which I have is Xls.I want a .sql file conversion. Could anyone help me with
the python code/suggest any other alternative???


Answer: To convert an Excel file to an SQL file python is one of the best options.
There is an **xlrd** library. The following is used to load the Excel file.

    
    
    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>")

