Upload and Process Excel Files in SAP CAP using Fiori Elements [2026]
🎯Github repository:
https://github.com/Frontmaniaac/SAP-C...
☕ Support the channel:
https://buycoffee.to/abapexplained
📊 In this tutorial you’ll learn how to upload and process Excel files in SAP CAP using Fiori Elements.
🚀 We start with a file upload triggered from the UI, handle the binary stream in a CAP service, convert it into a buffer, read Excel data row by row, apply simple business logic (like a 💸 20% price discount), and persist the result in a database entity, all without unnecessary complexity.
👀 You’ll see:
-📥 how file uploads work in SAP CAP
-🌊 why uploaded files arrive as streams and how to handle them correctly
-📄 how to read .xlsx files in Node.js
-🔄 how to map Excel rows to CAP entities
-🏷️ where MIME types matter during upload and processing
🔗 Libraries and references used in this video:
📦 Excel parsing library: https://www.npmjs.com/package/read-ex...
📚 Common MIME types (MDN):
https://developer.mozilla.org/en-US/d...