ABAP RAP: Upload data from Excel file

[adel_adel]

Hi,

I was wondering if it is possible to upload the data from an Excel file  without saving the rawstring data in the database?  without any modification on the front-end.

In most tutorial what I have seen, the attachment content is saved in a database tabel.

Thanks in advane

[Marian_Zeis]

You can use the free version of https://spreadsheet-importer.com/

Which requires minimal integration in the frontend and no modification of the backend.

[adel_adel]

Thank you for your reply. Does this mean the following:

1. Extension in de front-end is needed: Using that component allows the user to select a file and send the binry cntent of the file to the backend.

2. The binary data wil be the input for the action (functon import in Odata terms).

Is there any solution without updating the front-end and without storing the binary data in table (like in the most onlne tutorials)?

[Marian_Zeis]

1. Yes, a extension i necessary. The documentation can be found under GettingStarted with samples for Fiori Elements and Freestyle.
But no, not the binary is send to the backend but the data.
The component extracts the data from the excel, parses and validates it and send then as data to the backend. Thats why you can use any OData Backend.
2. No need to create a action, the standard Create and Update process is used.

So no need to handle binary data in the backend.