1# Read Excel sheet with pandas and using Sqlite DB
2
3# Setup code
4
5engine = create_engine('sqlite://', echo=False)
6df = pd.read_excel(file, sheet_name=sheetname)
7df.to_sql("test", engine, if_exists="replace", index=False)
8results = engine.execute("Select * from test")
9final = pd.DataFrame(results, columns=df.columns)