Flask Excel Form App (Auto-generated)

This project was generated from the workbook at: /mnt/data/knazarzadeh_ESPM_Pouch_06262025_Aging_chenpaper.xlsx

What it does

• Builds a multi-page form: one "Personal Information" page + one page per Excel sheet.
• Mirrors the workbook's sheet names and uses each sheet's header row as form fields.
• Validates that all required inputs are filled before enabling "Generate & Download".
• Saves the resulting Excel file into a new timestamped subfolder under the main directory you specify on the first page.
• Uses Bootstrap, a sidebar, and displays the Forschunszentrum Jülich logo on every page.

Run locally

cd flask_excel_from_workbook
python -m venv .venv && source .venv/bin/activate
pip install -r requirements.txt
export FLASK_APP=app.py
flask run --debug

Then open http://127.0.0.1:5000/

Notes

• Field types are inferred: columns with numeric-looking samples become <input type="number">; otherwise text.
• You can refine types and dropdown choices by editing schema.json.
• The generated Excel file includes a "Personal Information" sheet plus one sheet per original workbook sheet.