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.
Source Distribution
Built Distribution
Close
Hashes for excel_db_connector-0.2.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | 79aad5c7b69559e03023649d96dfce07b9f80ef058990b490e3c4ec70228f11d |
|
MD5 | da5be9a8e7e7416da5bc6225a1cfd31f |
|
BLAKE2b-256 | 739148a46b5ba05b43ad7b26262a80cb65b1fa0507f0c843498fab019d6a0fd6 |