Last post Jul 09, 2020 09:59 AM by Mikesdotnetting
Jul 08, 2020 08:43 AM|Le Lam|LINK
I get error when I process Export to Exel on My Application Web ASP.Net:
"Server execution failed (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE))"
On DCOMCnfg , check again configuration, i see:
Tab: Identity -> This User: Config Accout Administrator
I process config Change Option: The Interactive User -> Application Export to Exel is OK
Why do I use admin accounts to configure for Indeity errors?
Jul 09, 2020 05:52 AM|XuDong Peng|LINK
Hi Le Lam,
According to your description, the cause of the issue may be a security problem in the way of starting the COM server.
For this, you need to configure to verify the information. And you solved the issue by setting the administrator as the user.
But there may be other reasons for this issue:
For more details, you could also read this document.
Jul 09, 2020 07:13 AM|Le Lam|LINK
Thank XuDong Peng!
The Problem Here:
After, I setting user: The Interactive User.
My Application Is OK
Performance DCOM Server is OK.
Jul 09, 2020 09:59 AM|Mikesdotnetting|LINK
Don't use Office Interop on a web server. It is not supported and Microsoft explicitly advise against it (https://support.microsoft.com/en-gb/help/257757/considerations-for-server-side-automation-of-office).
If you want to work with Excel in a web application, use an Open Office XML library like EPPlus instead.
Some examples of EPPlus: https://www.mikesdotnetting.com/category/34/epplus