This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
''' | |
This code uses the openpyxl package for playing around with excel using Python code | |
to convert complete excel workbook (all sheets) to an SQLite database | |
The code assumes that the first row of every sheet is the column name | |
Every sheet is stored in a separate table | |
The sheet name is assigned as the table name for every sheet | |
''' | |
''' | |
20210908 Forked from antiproblemist/excel2sql.py |