How richardffrank/excel-to-ppt works
Project type and purpose
• This is a standalone Python desktop tool (“Excel-to-PPT”) that reads a user-provided Excel workbook and a PowerPoint template and produces a finished .pptx output.
File structure
• Top level:
• Assets/ – contains constants, sample Excel & PPTX templates
• Transformations/ – core business logic modules (Classes.py, Excel.py, Mapping.py, PowerPoint.py)
• UserInterface.py – GUI code
• startup.py – application entry-point (also used by PyInstaller)
• requirements.txt – dependencies (e.g., pandas, openpyxl, python-pptx)
• No microservices—this is a monolith with a clear logical layering.
Main components and interactions
a. User Interface (UserInterface.py + startup.py)
– Shows file pickers for Excel & PPTX template
– Triggers the transformation pipeline
b. Asset Store (Assets/)
– Excel template (.xlsx)
– PPTX template (.pptx)
– Constants.py (annotation keys)
c. Excel Parser (Transformations/Excel.py)
– Reads Excel sheet rows into in-memory data structures
– Uses pandas or openpyxl
d. Mapping & Data Models (Transformations/Mapping.py + Transformations/Classes.py)
– Transforms raw Excel rows to a list of “SlideData” objects
– Validates Slide ID, Slide Type, Content Location, Content
e. PPTX Generator (Transformations/PowerPoint.py)
f. External Libraries
– pandas/openpyxl for Excel I/O
– python-pptx for PowerPoint manipulation
– PyInstaller (optional) for bundling
Architectural patterns & design principles
• Layered architecture:
• Presentation layer (UI)
• Business logic layer (Transformations modules)
• Data layer (file I/O & templates)
• Single-responsibility: each module has a clear job (parsing vs. mapping vs. generating).
• Sequential pipeline: UI → Excel Parser → Mapper → PPT Generator → File output.