Skip to Content
0
Former Member
Aug 07, 2016 at 05:00 AM

XLS Format Excel upload in SAP UI5

992 Views

Hi Folks,

I am a SAP Odata ABAPer working along with a Ui5 developer to develop an app.

We are developing a Ui5 app which has functionality to upload Excel data and process the data in backend through Odata.

The problem we are facing is Odata is able to recognise only .CSV format and convert it in to readable format,

The XSTRING data sent by Ui5 to Odata when the uploaded format is .XLS does not look compatible.

I have read few articles on this issue where people just started using .CSV files for the solution, Can anyone guide if anyone of the following is possible.

1) Is it possible in Odata to convert the XSTRING of Data from Ui5 in case of XLS format in to readable format?

2) Is it possible that Ui5 can convert the uploaded XLS format file to fetch the data in to an array and send it to backend ?

3) My friend in Angular Javascript uses plugin to convert the XLS to JSON format and send the data to Backend. Is the plugin functionality possible in Ui5 ?

4) Is there any standard Odata service for such XLS upload which i can use ?

Thanks for reading up till now. If you have views on any of the above doubts, Please drop your comment.