Skip to Content
0
Oct 24, 2019 at 06:04 AM

Uploading Excel to HANA XS/XSA

212 Views Last edit Oct 24, 2019 at 08:24 AM 3 rev

Hi Everyone,

I have a requirement to upload a huge excel file (~500k) to HANA DB. I have achieved it using XSJS, but I had to convert XLSX to CSV before upload.

Question here is, Can I read XLSX file at server side? I did not find any useful pointer on this for both XS and XSA.

Following are my observations:

XS >> adding library for excel, din work

XSA >> nodejs has no full-fledged excel package in SAP registry

Kindly suggest me any working approach to crack this scenario.

Thanks,

Vignesh Sankar.