Connects Excel to a database connector to transfer information to and fro.
Project description
Excel Database Connector
Connects Excel to a database connector to transfer information to and fro. Fyle is an expense management system.
Installation
This project requires Python 3+.
-
Download this project and use it (copy it in your project, etc).
-
Install it from pip.
$ pip install excel-db-connector
Usage
This connector is very easy to use.
- First you'll need to create a connection using the main class FyleSDK.
import sqlite3 from excel_db_connector import ExcelConnector dbconn = sqlite3.connect('/tmp/temp.db') excel_connector = ExcelConnector(dbconn)
- After that you'll be able to extract data from excel and store it in the db
# Create the tables to for all objects excel_connector.create_tables('/tmp/create_tables.sql') excel_connector.extract('excel.xlsx', 'table_name')
Contribute
To contribute to this project follow the steps
- Fork and clone the repository.
- Run
pip install -r requirements.txt
- Setup pylint precommit hook
- Create a file
.git/hooks/pre-commit
- Copy and paste the following lines in the file -
#!/usr/bin/env bash git-pylint-commit-hook
- Run
chmod +x .git/hooks/pre-commit
- Create a file
License
This project is licensed under the MIT License - see the LICENSE file for details
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Filename, size | File type | Python version | Upload date | Hashes |
---|---|---|---|---|
Filename, size excel_db_connector-0.3.0-py3-none-any.whl (4.3 kB) | File type Wheel | Python version py3 | Upload date | Hashes View |
Filename, size excel-db-connector-0.3.0.tar.gz (3.1 kB) | File type Source | Python version None | Upload date | Hashes View |
Close
Hashes for excel_db_connector-0.3.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | fccbca7e9316efe8cbe687caf0c105a154fa57ea0648f60fa513d0b1a4aa0c02 |
|
MD5 | f27e6edd63e46079579b53b2959297e1 |
|
BLAKE2-256 | 0dcbdd620f74bf179afb43c1fd9dee1a36cbf1dc67cab8c30b7ae45952f5796c |