Python Excel Converter
This project converts data into an Excel format using the openpyxl library. It allows users to input data and generate a formatted Excel file.
-
Clone the repository:
git clone https://github.com/StixKnowledge/pythonConversionToExcel.git cd pythonConversionToExcel -
Create a virtual environment (optional but recommended):
python3 -m venv venv source venv/bin/activate # On Windows use `venv\Scripts\activate`
-
Install the required packages:
pip install -r requirements.txt
pythonConversionToExcel/
│
├── .env # Environment variables
├── requirements.txt # List of required Python packages
├── .gitignore # Files and folders to be ignored by Git
├── data/ # Directory containing input data files
│ ├── APPLICATION-for-MARRIAGE-LICENSE.xlsx
│ └── couple_img.png # Image used in the Excel file
│
├── src/ # Source code directory
│ └── Convert_to_excel.py # Main script for converting data to Excel
│
└── Excel/ # Directory where generated Excel files are saved
To run the script, use the following command:
python src/Convert_to_excel.pyThis will generate an Excel file in the Excel folder based on the input data.