Access Excel Data in RAP BO Classes

[ravenclaw]

andre.fischer

There are a lot of requirements coming from the customers on using excel functionality in RAP based BOs. They want to upload an excel file in the Fiori Elements App (FEAPP) and then in our RAP handler/saver classes we need to access the uploaded data to write additional logic before updating back into tables or in some cases CBOs.

We need some guidance on how to approach this general customer requirement. Could you shed some light on this topic? Thank you.

Best Regards,

Ravenclaw(Tanmoy)

[ravenclaw]

marcel.hermanns volker.drees renzo.colle

[Marian_Zeis]

Hi Tanmoy,

i developed a component you can use which integrate in Fiori Elements without sending the excel file to the backend. see this blog
https://blogs.sap.com/2023/02/17/simplifying-excel-upload-in-fiori-elements-the-open-source-and-easy.../

My Documentation:

https://docs.spreadsheet-importer.com/

Live Demo:

https://livedemo.spreadsheet-importer.com/

[ravenclaw]

Thnak you my friend for the quick reply.