This project is a simple backup of excel data into a SQLite database. The backup process involves reading an Excel file and writing the data into a SQLite database.
- Make sure you have Python 3 installed.
- Clone the repository.
- Install the required dependencies by running
pip install -r requirements.txtin the project directory. - Run the backup script by running
python backup/write_excel_to_sqlite.pyin the project directory.
- Python 3
- pandas
- openpyxl
- sqlalchemy
The project is structured as follows:
excel_to_sqlite.py: contains the code to read Excel data and write it to a SQLite database.requirements.txt: contains the list of required Python packages.
Contributions are welcome! If you find any issues or have suggestions for improvements, please open an issue or submit a pull request.
This project is licensed under the MIT License. See the LICENSE file for details.