Read excel data from frontend using SAP ODATA

[former_member420959]

Hello all,

I am trying to excel from SAP UI5 application . I created an entity type of media and getting xstring of the file from the frontend in create_stream.

But not able to read the data correctly. I am able to read data using CSV but having problems with excel.

Can anyone suggest the correct way of reading the data from XLS or XLSX file and store the data to a table.

Regards

Ujwal

[AshwinDutt]

Hello Ujwal,

You can download the data directly as excel from GW.

Please check.

Excel Support - SAP Gateway Foundation (SAP_GWFND) - SAP Library

Sample -

/sap/opu/odata/IWFND/RMTSAMPLEFLIGHT/FlightCollection?$format=xlsx

Regards,

Ashwin

[former_member420959]

Thanks Ashwin for your quick reply.

My requirement is to upload the data in excel from local system through GW not download.

[AshwinDutt]

What is the mime type is being passed for excel for the Create_Stream ?

[former_member420959]

application/pdf