title: python sqlite3 creating a DB from excel
body: <p>I'm trying to create a DB from an excel spreadsheet. I have the below code, the issue is when i run my code my database creates a table for each column. I would like to create a table for each spreadsheet listed in the workbook. sheet names are sheet1 and sheet2.</p>
  <pre><code>import sqlite3
  import pandas as pd
  filename=&quot;script&quot;
  con=sqlite3.connect(filename+&quot;.db&quot;)
  wb=pd.read_excel(filename+'.xlsx',sheet_name='sheet1')
  for sheet in wb:
  wb[sheet].to_sql(sheet,con, index=False)
  con.commit()
  con.close()
  </code></pre>