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
-
Notifications
You must be signed in to change notification settings - Fork 7
Convert excel wokrbook (All Sheets) to sqlite database
License
antiproblemist/excel2sql
Folders and files
Name | Name | Last commit message | Last commit date | |
---|---|---|---|---|
Repository files navigation
About
Convert excel wokrbook (All Sheets) to sqlite database
Resources
License
Stars
Watchers
Forks
Releases
No releases published
Packages 0
No packages published