How to create an excel upload and read functionality in RAP

[abaper_guy]

I have a requirement where i need to develop a fiori app (preferably using Fiori Element + RAP) where user gets an option to upload Excel file and when he uploads, it should trigger an event where I can write my logic to read the data from excel and do my abap operations on it.

I think there is an annotation @Semantics.largeobject to have an excel import option created in UI via fiori elements but as per understanding , it will directly upload the excel data in DB (as RAWstring) . In my case, I dont want to store the excel data in DB , just want some abap related event/method to trigger where I can my custom abap code to read this and do the processing I want.

@Semantics.largeObject:
      { mimeType: 'MimeType',
      fileName: 'Filename',

Any help, would be appreciated 🙂

[junwu · Accepted solution]

here you go 

https://community.sap.com/t5/technology-blog-posts-by-members/abap-rap-excel-upload-through-custom-a...

but it is not supported for onpremise yet.

[junwu · Accepted solution]

just google, there are other ones, which will do the excel extraction from frontend and send the extracted data to backend.