Connects Excel to a database connector to transfer information to and fro.
Excel Database Connector
Connects Excel to a database connector to transfer information to and fro. Fyle is an expense management system.
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
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')
To contribute to this project follow the steps
- Fork and clone the repository.
pip install -r requirements.txt
- Setup pylint precommit hook
- Create a file
- Copy and paste the following lines in the file -
#!/usr/bin/env bash git-pylint-commit-hook
chmod +x .git/hooks/pre-commit
- Create a file
This project is licensed under the MIT License - see the LICENSE file for details
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|
Hashes for excel_db_connector-0.3.0-py3-none-any.whl