ASP.NET application call excel throw "The remote procedure call failed"

Question

Following is the Microsoft Excel Application Properties in DCOM Config in my web server (Windows Server 2022).

It is work fine when no account remote login to the server. My web application can read and write Excel file.

But I find that my web application throw "The remote procedure call failed" when

any account login the web server.

May I know any setting or config can solve it?

Answer 1

Microsoft does not currently recommend, and does not support, Automation of Microsoft Office applications from any unattended, non-interactive client application or component (including ASP, ASP.NET, DCOM, and NT Services), because Office may exhibit unstable behavior and/or deadlock when Office is run in this environment.

https://learn.microsoft.com/en-us/office/client-developer/integration/considerations-unattended-automation-office-microsoft-365-for-unattended-rpa

Try this instead.

https://learn.microsoft.com/en-us/troubleshoot/developer/visualstudio/csharp/language-compilers/query-excel-data-aspx-page