Report Generator

A backend-powered automation tool to generate custom Excel reports using FastAPI.

🚀 Features

• Generate daily, weekly, and monthly reports from connected databases
• Export processed data to Excel format
• RESTful API endpoints using FastAPI
• Frontend UI for file uploads and date range selection

🔧 Tech Stack

• Backend: Python, FastAPI
• Frontend: HTML, CSS (basic)
• Database: Microsoft SQL Server (Azure + Local)
• Excel Handling: openpyxl, pandas

📁 Project Structure

app/
├── routes/              # API endpoints
├── services/            # Excel processing logic
├── static/              # Images and static files
├── templates/           # HTML templates
├── uploads/             # User uploaded Excel files
├── output_files/        # Generated reports
└── config_sample.ini    # Sample DB config (real config excluded)

⚙️ Setup

1. Clone the repo:

   git clone https://github.com/your-username/report-generator.git
   cd report-generator

2. Install dependencies:

   pip install -r requirements.txt

3. Create a config.ini file in the app/ folder using the format in config_sample.ini.

4. Run the server:

   uvicorn app.main:app --reload

📌 Notes

• The real config.ini is excluded from the repository for security.
• Adjust database table names and credentials in your local config.ini.

📄 License

This project is for educational and demo purposes.