Import Excel data into smart table in SAPUI5

[tezk]

Hi,

I have an excel file that contains some data and I want to mass upload that data into smart table in SAPUI5. Is it possible to put data from excel into smart table and send it to backend? If yes, could you please tell me the way to achieve it.

Thanks,

Teja.

[Marian_Zeis]

Hi tezk

i developed something for this use case:

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

It´s maybe helpful.

If you have any questions, you can contact me.

Regards

[jhodel18]

Hi Teza,

I looked into this similar requirement recently and the first thing that came to my mind is -- how does SAP do it? I did some investigation and found out that standard SAP upload the excel file directly to ABAP backend, then do some processing logic like data validation then send the data back to the UI (which is already through OData) where the control used is SmartTable. I think you could apply the same approach to your requirement.

At first, I thought of the same approach you described above, but once I learned that SAP's approach is more simple, I discarded that idea.

[maheshpalavalli]

True, this is a better solution especially from the performance wise , tezk, just keep in mind, that you need to have a temporary table in the backend or the actual table with some sort of status(intermediate or temporary) to achieve this.

[tezk]

Hi Jhodel,

Thank you for providing the way to do it. I will look into this approach.

Thanks

Teja.

[TheGokke]

I just wrote a blog on how I achieved this without temporary table (this was bothering me).

It under review but I'll link it here once it is published by SAP.

[tezk]

Hi Andy,

That's great. Waiting for your blog post. Please post the link here once it is published.

Thanks,

Teja.

[TheGokke]

Here it is: https://blogs.sap.com/2020/08/26/native-excel-migration-tool-for-fiori-semi-dynamic/