xls2db
xls2db is a python program that takes an excel spreadsheet following a certain schema into an sqlite database that can be opened using python’s sqlite3 module. It can also be used as a module.
Why??
Because fuck you, that’s why.
But seriously: I was getting sick of doing data entry for this toy project of mine using cursor.execute()’s, so I figured I’d try entering the data into an excel spreadsheet, converting it into the db, and then manipulating it from there. Crazy, I know.
Usage:
As a script:
xls2db infile.xls outfile.db
As a module:
from xls2db import xls2db
xls2db("infile.xls", "outfile.db")
For more, visit <https://github.com/jesusabdullah/xls2db> .
1 maintainer
Metadata
1 maintainer
Release files for xls2db 0.0.8
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| xls2db-0.0.8.tar.gz | 3.3 kB | Details |
Release files / xls2db-0.0.8.tar.gz
| Download URL | xls2db-0.0.8.tar.gz |
|---|---|
| Size | 3.3 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
a929907219717148b03b740a8d379f600473ad1e57e9a9ee0498fad48c7fedb3
|
|
BLAKE2b-256 checksum How to use checksums |
089171a28e9874093692a0a512d15e45cc81cf2c32b0be2ac64e637cbb7a639b
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
