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
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
xls2db-0.0.8.tar.gz
(3.3 kB
view details)
File details
Details for the file xls2db-0.0.8.tar.gz.
File metadata
- Download URL: xls2db-0.0.8.tar.gz
- Upload date:
- Size: 3.3 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
a929907219717148b03b740a8d379f600473ad1e57e9a9ee0498fad48c7fedb3
|
|
| MD5 |
8805bdffd225d9cb8c9e7b69d8bd392f
|
|
| BLAKE2b-256 |
089171a28e9874093692a0a512d15e45cc81cf2c32b0be2ac64e637cbb7a639b
|
