I want to run the powershell in Azure function as http trigger, where powershell script has function to open the excel and to read it, while trying to open it it displays the below error

Question

I want to run the powershell in Azure function as http trigger, where powershell script has function to open the excel and to read it, while trying to open it it displays the below error

Mugileeshwaran J S 20

Retrieving the COM class factory for component with CLSID {00000000-0000-0000-0000-000000000000} failed due to the following error: 80040154 Class not registered (0x80040154 (REGDB_E_CLASSNOTREG)).
2023-08-10T10:29:06Z

Register COM Object

I also tried placing the dll file in the location and tried to run, but same error
User's image

Mugileeshwaran J S 20 Reputation points

2023-08-31T06:55:55.8466667+00:00

i want solution using COM Objects..
Mike Urnun 9,856 Reputation points Microsoft Employee

2023-09-12T05:35:00.5666667+00:00

Hello @Mugileeshwaran J S Sorry for the late reply. If you're still hitting the same error, could you try out changes in the following answer? https://stackoverflow.com/a/11077524/9393813
Mugileeshwaran J S 20 Reputation points

2023-09-12T05:49:35.7766667+00:00

The don't think so above solution will support the azure functions.?

My actual file root will, will i able to run the following command, here?

C:\home\site\wwwroot\data\
Mike Urnun 9,856 Reputation points Microsoft Employee

2023-09-18T17:33:40.3266667+00:00

@Mugileeshwaran J S Were you able to make any headway based on Ben's answer below?

Accepted answer

1 additional answer

Your answer

Mugileeshwaran J S 20 Reputation points

2023-08-31T06:55:55.8466667+00:00

i want solution using COM Objects..
Mike Urnun 9,856 Reputation points Microsoft Employee

2023-09-12T05:35:00.5666667+00:00

Hello @Mugileeshwaran J S Sorry for the late reply. If you're still hitting the same error, could you try out changes in the following answer? https://stackoverflow.com/a/11077524/9393813
Mugileeshwaran J S 20 Reputation points

2023-09-12T05:49:35.7766667+00:00

The don't think so above solution will support the azure functions.?

My actual file root will, will i able to run the following command, here?

C:\home\site\wwwroot\data\
Mike Urnun 9,856 Reputation points Microsoft Employee

2023-09-18T17:33:40.3266667+00:00

@Mugileeshwaran J S Were you able to make any headway based on Ben's answer below?

Answer 1

Mike Urnun 9,856 Microsoft Employee

Hello @Mugileeshwaran J S - Unfortunately, as far as Azure Functions, this doesn't seem possible: https://feedback.azure.com/d365community/idea/564859b0-f224-ec11-b6e6-000d3a4f0da0

Answer 2

Ben Gimblett 4,550 Microsoft Employee

Generally speaking COM isn't supported in App Service / Functions due to the sandbox that your code runs in

An almost identical Q&A on this (and trying to access Excel) is here https://learn.microsoft.com/en-us/answers/questions/247908/how-to-register-microsoft-component-object-model-i

App Service supports windows containers (as well as AKS), but as far as I know windows containers aren't supported yet by Functions. They are also not supported yet on Container Apps.

So you could host an API in App Service on a windows container - this would give much more access to the guest OS and should unblock you here

Mugileeshwaran J S 20 Reputation points

2023-09-19T12:40:37.9266667+00:00

Anyway, i cannot install MS Office inside a Azure Container due to its licensing restriction, Can you suggest some alternative to use COM Object in Azure?
Rich Matheisen 47,766 Reputation points

2023-09-29T01:54:53.06+00:00

How about the ImportExcel Powerhell module?

Share via

I want to run the powershell in Azure function as http trigger, where powershell script has function to open the excel and to read it, while trying to open it it displays the below error

1 additional answer

Your answer