question

VivekDadhich-3190 avatar image
0 Votes"
VivekDadhich-3190 asked SumanthMarigowda-MSFT edited

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

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

azure-functions
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

MughundhanRaveendran-MSFT avatar image
0 Votes"
MughundhanRaveendran-MSFT answered VivekDadhich-3190 commented

@VivekDadhich-3190 ,

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.


· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

@VivekDadhich-3190 , Just wanted to know if the above answer was helpful or not. Please let me know

0 Votes 0 ·
VivekDadhich-3190 avatar image VivekDadhich-3190 MughundhanRaveendran-MSFT ·

Thanks for the answer but that's not what I was looking for, first you gave info about javascript API in ms excel (I am not using ms office anywhere, it's just a .xlsx file stored as a blob in my azure storage container), and then about XML SDK(but I have to use javascript only). Anyways thanks!

0 Votes 0 ·