Upload the Excel File (.xlsx) to sap.ui.table in SAPUI5 (using SAPUI5 Standard Controls)

[former_member494689]

Hi Experts,

How can upload the excel file data (.xlsx) to sap.ui.table model data using SAPUI5 standard controls?

Please kindly provide references/samples. （※if possible, do not want to use third-party JS library）

Best Regards,

Thiri

[former_member540067]

Yes. Follow my blog for steps.

https://blogs.sap.com/2020/05/27/read-data-from-excel-file-.xlsx-in-sap-ui5-app-and-display-contents...

[former_member494689]

Hi Anmol Chadha,

Thanks for quick feedback.

In your blog, xlsx.js library is using to read excel data to json data.

Instead of this, I would like to use sapui5 standard control. Is it possible?

For example, we can use FileReader.readAsText for CSV upload.

Best Regards,

Thiri

[former_member494689]

Hi Anmol Chadha,

Here is my code. But it doesn't work.

var file1 = oFileUploader.getFocusDomRef().files[0];

if (file && window.FileReader) {

var reader = new FileReader();

reader.onload = function(e) {

var strResult = e.currentTarget.result;

};

reader.readAsText(file, 'ISO-8859-1');

}

Best Regards,

Thiri