export data from excel to sqlite database [closed]

Try this fresh code exceltosql:

'''This code uses the openpyxl package for playing around with excel using Python codeto convert complete excel workbook (all sheets) to an SQLite databaseThe code assumes that the first row of every sheet is the column nameEvery sheet is stored in a separate tableThe sheet name is assigned as the table name for every sheet'''import sqlite3import openpyxlfrom openpyxl import load_workbookimport redef slugify(text, lower=1):    if lower == 1:        text = text.strip().lower()    text = re.sub(r'[^\w _-]+', '', text)    text = re.sub(r'[- ]+', '_', text)    return text#Replace with a database namecon = sqlite3.connect('test.db')#replace with the complete path to youe excel workbookwb = load_workbook(filename=r'abc.xlsx')sheets = wb.get_sheet_names()for sheet in sheets:    ws = wb[sheet]     columns= []    query = 'CREATE TABLE ' + str(slugify(sheet)) + '(ID INTEGER PRIMARY KEY AUTOINCREMENT'    for row in ws.rows[0]:        query += ', ' + slugify(row.value) + ' TEXT'        columns.append(slugify(row.value))    query += ');'    con.execute(query)    tup = []    for i, rows in enumerate(ws):        tuprow = []        if i == 0:            continue        for row in rows:            tuprow.append(unicode(row.value).strip()) if unicode(row.value).strip() != 'None' else tuprow.append('')        tup.append(tuple(tuprow))    insQuery1 = 'INSERT INTO ' + str(slugify(sheet)) + '('    insQuery2 = ''    for col in columns:        insQuery1 += col + ', '        insQuery2 += '?, '    insQuery1 = insQuery1[:-2] + ') VALUES('    insQuery2 = insQuery2[:-2] + ')'    insQuery = insQuery1 + insQuery2    con.executemany(insQuery, tup)    con.commit()con.close()