Upload excel file in sap ui table

[Former Member]

Hello Experts,

We have a requirement from our client where we need to upload a locally stored excel to the frontend ui table.I am using sap.ui.unified.FileUploader control for performing upload operation.

The requirement is to parse the excel in ui front-end and display the contents of the excel in ui table (columns are same in both the excel and ui table) as soon as the user uploads excel file.

I tried to achieve this in front-end only using JavaScript but couldn't achieve it.

So kindly suggest me parsing of excel and displaying in the table can be done from front-end side or we need to use OData service for achieving this.

Any help will be appreciated.

Thanks,

Imran

[EkanshCapgemini]

Hi Imran,

We also had one similar requirement earlier. After some analysis, we got to know that we can achieve this functionality with ActiveX control but this has some issues with IE as well as security concerns. Then we went through Back-end route but there is another limitation that you have to convert the file to CSV file instead of excel. You can check my blog

Regards,

Ekansh

[santhu_gowdaz]

this may help you,

Excel upload to internal table - is it possible | SCN

[Former Member]

This message was moderated.

[Former Member]

Hi Indrajit,

Thanks for your reply. But in our project we are not using HANA.

So we cannot go for HANA Extended services.

If you have any other solution then please let me know.

Regards,

Imran

[Former Member]

Sorry mohammed..Don't know other approach

[Former Member]

No Problem Indrajit. Thanks for your suggestions.

Regards,

Imran