How to read xlsx file stored in storage conatiner using blob triggred nodejs function app

Question

please provide a detailed answer, I have already tried using the Azure Storage Blob client library for JavaScript but that not working.

Answer 1

@Vivek Dadhich ,

Thanks for reaching out to Q&A.

Unfortunately, Excel has no Javascript API that can be used to read .xls/.xlsx files. There are javascript addins but they needs to be run inside the Excel application itself. Please note that, Excel is a client side application, automating or reading excel files on a server is unsupported by Microsoft and it will be unstable even if you find some workarounds.

Please read this article that talks about the above-mentioned information : https://support.microsoft.com/en-us/topic/considerations-for-server-side-automation-of-office-48bcfe93-8a89-47f1-0bce-017433ad79e2

I would suggest you use Open XML SDK (.net ) in Azure functions to read .xlsx files that are present in Blob storage. This would be supported and recommended way. The following article has the implementation of using Open xml sdk in Azure blob triggered functions.

https://social.msdn.microsoft.com/Forums/en-US/1b4768e5-ff6b-4b28-8223-c7380353c0c1/read-file-content-of-excel-file-on-azure-blob-storage

I hope this helps!

Please 'Accept as answer' and ‘Upvote’ if it helped so that it can help others in the community looking for help on similar topics.