> Markdown version of [/events/world-congress-2026-europe-virtual-stage/sessions/1591-replacing-excel-with](https://www.wearedevelopers.com/events/world-congress-2026-europe-virtual-stage/sessions/1591-replacing-excel-with). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Replacing Excel with SAP APIs & Python validation


- **Event:** World Congress 2026 Europe - Virtual Stage

## Recording

[Watch recording](https://www.wearedevelopers.com/videos/1944-replacing-excel-with-sap-apis-python-validation)

## Description

Many enterprise reportings still depend on manual Excel uploads, fragile scripts, and “don’t-touch-it” legacy code. That mix makes reporting slow, error-prone, and hard to audit — especially with increasing governance expectations.
 
In this session, I share a practical modernization: replacing Excel-based inputs with direct SAP API extraction, transforming the data in Python, and integrating the output into an existing reporting solution. The work started with understanding undocumented legacy scripts and the implicit business rules they encoded; AI-assisted developer tools (e.g., Copilot) helped to accelerate code understanding before making changes.
 
Two aspects shaped the final design. First, API-derived data deviated from historical reports because of synchronization/timing effects — reports had to be generated in the correct time window to be consistent. Second, replacing the manual Excel layer surfaced a long-standing deviation between the intended business logic and the legacy report’s actual behavior. This created an opportunity to streamline and harmonize the logic, improving consistency, runtime, and scalability of the reporting pipeline while reducing manual effort and key-person dependencies. 
 
To rebuild trust, a validation harness was create: a Python script that automatically compares the “manual” and “automated” outputs, flags deviations, and visualizes differences so reviewers can triage issues quickly. This reduces reliance on individual availability (vacation, sick leave) for critical reporting checks and made the whole process more resilient. Unlike generic “automation with AI” talks, this is a governance-first story about validation, rollout, and preserving reporting integrity in production. You’ll leave with concrete patterns for baselining, reconciliation, and monitoring when modernizing enterprise pipelines.
 


## Speaker

### [Aldin Sljivar](https://www.wearedevelopers.com/@aldin-sljivar)

Associate Vice President (Data, DevOps, Reporting Automation) at Deutsche Börse AG


## Related talks at this congress

- [AI as a Test Designer: Transforming Experience into Automated Testing](https://www.wearedevelopers.com/events/world-congress-2026-europe-virtual-stage/sessions/1482-ai-as-a-test) — Alisa Hrustic
- [What If Apps Built Themselves? AI-Powered Low-Code for the Industrial Enterprise](https://www.wearedevelopers.com/events/world-congress-2026-europe-virtual-stage/sessions/1639-what-if-apps-built) — Kerstin Stier
- [AI in Regulated Industry - Validating AI-Enabled Products with PLM and Digital Twins](https://www.wearedevelopers.com/events/world-congress-2026-europe-virtual-stage/sessions/1485-ai-in-regulated) — Murli Mohan Srinivas
- [A True Story About Speeding Up the Wrong Things](https://www.wearedevelopers.com/events/world-congress-2026-europe-virtual-stage/sessions/1478-a-true-story-about) — Jo Hasenau, Petra Hasenau