on 08-24-2016 10:18 PM
Hello All,
I have a requirement in SAP Odata to read an excel file that will be uploaded in SAP UI5 application , read the contents of the file and upload the same in a ztable.
I am getting Xstring of the uploaded file as input to the CREATE_STREAM method. But i see that the Xstring of the file is different from that if upload from sap gui for the same file. Do anything needs to be done in front end to achieve the requirement .
My UI developer said that there is nothing extra that need to be done in for excel . If so can anyone explain how this can be handled from backend.
Regards
Ujwal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ujwal,
As much as I know, SAPUI5 doesn't have this functionality out of the box in its library. CSV is a valid option if you want to convert it server-side.
If you want to convert it on client-side, you can check this project GitHub - SheetJS/js-xlsx: XLSX / XLSM / XLSB / XLS / SpreadsheetML (Excel Spreadsheet) / ODS parser ... .
I have not tested this so can't comment much on this. However reading a large excel file at client-side would not be recommended as it might cause serious memory issue specially on the mobile/tablet devices. You can check this thread for more info on using this library Read contents of Excel file into Sapui5 table | SCN
Regards,
Ekansh
User | Count |
---|---|
70 | |
9 | |
8 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.