Excel2SQL

This script converts tables created in excel into SQL queries for easoy conversion of excel to SQL.

Getting Started

You'll need Python3 and OpenPyxl

Prerequisites

Windows

pip install --user openpyxl 

Linux

pip3 install --user openpyxl 

The excel file has to be formatted correctly, please look at the included demo excel file for proper operation.

Installing

To start run the following commands. Windows

python Excel2SQL.py -i INPUT_FILE/INPUT_DIRECTORY -d OUT_DIRECTORY

Linux

python3 Excel2SQL.py -i INPUT_FILE/INPUT_DIRECTORY -d OUT_DIRECTORY

If the code runs successfully you should have an INPUT_FILE.sql in your OUT_DIRECTORY

Built With

• Python3 - The Language Used
• OpenPyxl - The Library Used

Authors

• Mohammad Taha Bin Firoz - Taha Firoz
• Mohammad Ziad Siddiqui - Ziad Coolio
• Abdul Manaan - Abul Manaan

See also the list of contributors who participated in this project.

License

This project is licensed under the GPL V3 License - see the LICENSE.md file for details