| 1234567891011121314151617 |
- import sqlite3
- import pandas as pd
- import sqlalchemy
- from sqlalchemy import create_engine
- file = "Planung_2020.xlsx"
- sheet = "Planung"
- output = "result.xlsx"
- engine = create_engine("sqlite://", echo=False)
- df = pd.read_excel(file, sheet_name=sheet)
- df.to_sql("planung", engine, if_exists="replace", index=False)
- results = engine.execute("SELECT * FROM planung")
- final = pd.DataFrame(results, columns=df.columns)
- final.to_excel(output, index=False)
|
