blocks|key|3007810|text|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3007811|将读/写权限授予IIS用户或组用户|ordered-list-item|3007812|Start+->+run+->+inetmgr|3007813|3007814|为默认网站启用ASP.NET身份验证|3007815|对于64位|3007816|+(x64)，请创建此文件夹:+C:\Windows\SysWOW64\config\systemprofile\Desktop|3007817|3007818|对于32位(x86)，请创建此文件夹:+C:\Windows\System32\config\systemprofile\Desktop|3007819|如果windows服务在systemprofile下运行，则需要Desktop文件夹。此文件夹是在XP和更早的Windows+Server版本上自动创建的，但不是为Vista和Windows+2008+Server创建的。|3007820|entityMap^0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|-4|4|5|6|T|7|@]|8|@]|9|$]]|$1|A|3|B|4|C|6|U|7|@]|8|@]|9|$]]|$1|D|3|E|4|C|6|V|7|@]|8|@]|9|$]]|$1|F|3|-4|4|5|6|W|7|@]|8|@]|9|$]]|$1|G|3|H|4|5|6|X|7|@]|8|@]|9|$]]|$1|I|3|J|4|5|6|Y|7|@]|8|@]|9|$]]|$1|K|3|L|4|C|6|Z|7|@]|8|@]|9|$]]|$1|M|3|-4|4|5|6|10|7|@]|8|@]|9|$]]|$1|N|3|O|4|5|6|11|7|@]|8|@]|9|$]]|$1|P|3|Q|4|5|6|12|7|@]|8|@]|9|$]]|$1|R|3|-4|4|5|6|13|7|@]|8|@]|9|$]]]|S|$]]

<ol>
<li>give the read / write permission to the IIS user or group users</li>
<li>Start -> run -> inetmgr

enable the ASP.NET authentication for your default website</li>
</ol>

3.
For 64-bit (x64), create this folder:
C:\Windows\SysWOW64\config\systemprofile\Desktop

For 32-bit (x86), create this folder:
C:\Windows\System32\config\systemprofile\Desktop

The windows service, if running under the systemprofile, needs the Desktop folder. This folder was automatically created on XP and older Windows Server versions, but not for Vista and Windows 2008 Server.

blocks|key|2795373|text|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2795374|请确保在服务器上安装了Office运行时。|ordered-list-item|2795375|如果您使用的是Windows+Server2008，则使用office互操作是一项冗长的配置，以下是步骤。|2795376|2795377|更好的方法是迁移到Open+XML，或者您可以按如下方式进行配置|2795378|2795379|安装MS+Office+Pro最新版本(我用的是2010专业版)|unordered-list-item|2795380|Create+User+ExcelUser。Assign+WordUser+with+Admin+Group|2795381|转到Computer+->+Manage|2795382|Add+User+with以下options|2795383|User+Options+Password+Never+Expires|2795384|Password+Change+Be+Change|2795385|2795386|Com%2B配置|2795387|Properties|2795388|General+|2795389|
|2795390|转到控制面板->管理员->组件服务->+|2795391|2795392|打开Microsoft+Word+97+-+2003+Properties|2795393|2795394|General+->身份验证级别:+None|2795395|2795396|Security+|2795397|2795398|自定义所有3个权限以允许Excel+->此用户使用->+ExcelUser+|2795399|
+App以确保一切正常|2795400|3.在DCOM配置中更改Microsoft+Excel应用程序的安全设置。|2795401|控制面板-->管理工具-->组件服务-->计算机-->+myComputer+-->DCOM配置-->+Microsoft+Excel应用程序。|2795402|右键单击以获取属性对话框。转到安全选项卡并自定义权限|2795403|请看这里的帖子：Error+while+creating+Excel+object，Excel+manipulations+in+WCF+using+COM|offset|length|2795404|entityMap|0|LINK|mutability|MUTABLE|url|http://social.msdn.microsoft.com/Forums/en-US/b6388275-b295-4e55-8c25-6d8788eac1ca/error-while-creating-excel-object|1|http://social.msdn.microsoft.com/Forums/vstudio/en-US/1d5f1c83-10a7-4322-80a9-0a4348c738c9/excel-manipulations-in-wcf-using-com^0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|8|X|0|16|10|1|0^^$0|@$1|2|3|-4|4|5|6|25|7|@]|8|@]|9|$]]|$1|A|3|B|4|C|6|26|7|@]|8|@]|9|$]]|$1|D|3|E|4|C|6|27|7|@]|8|@]|9|$]]|$1|F|3|-4|4|5|6|28|7|@]|8|@]|9|$]]|$1|G|3|H|4|5|6|29|7|@]|8|@]|9|$]]|$1|I|3|-4|4|5|6|2A|7|@]|8|@]|9|$]]|$1|J|3|K|4|L|6|2B|7|@]|8|@]|9|$]]|$1|M|3|N|4|L|6|2C|7|@]|8|@]|9|$]]|$1|O|3|P|4|L|6|2D|7|@]|8|@]|9|$]]|$1|Q|3|R|4|L|6|2E|7|@]|8|@]|9|$]]|$1|S|3|T|4|L|6|2F|7|@]|8|@]|9|$]]|$1|U|3|V|4|L|6|2G|7|@]|8|@]|9|$]]|$1|W|3|-4|4|5|6|2H|7|@]|8|@]|9|$]]|$1|X|3|Y|4|5|6|2I|7|@]|8|@]|9|$]]|$1|Z|3|10|4|5|6|2J|7|@]|8|@]|9|$]]|$1|11|3|12|4|L|6|2K|7|@]|8|@]|9|$]]|$1|13|3|14|4|5|6|2L|7|@]|8|@]|9|$]]|$1|15|3|16|4|L|6|2M|7|@]|8|@]|9|$]]|$1|17|3|14|4|5|6|2N|7|@]|8|@]|9|$]]|$1|18|3|19|4|L|6|2O|7|@]|8|@]|9|$]]|$1|1A|3|14|4|5|6|2P|7|@]|8|@]|9|$]]|$1|1B|3|1C|4|L|6|2Q|7|@]|8|@]|9|$]]|$1|1D|3|14|4|5|6|2R|7|@]|8|@]|9|$]]|$1|1E|3|1F|4|L|6|2S|7|@]|8|@]|9|$]]|$1|1G|3|14|4|5|6|2T|7|@]|8|@]|9|$]]|$1|1H|3|1I|4|L|6|2U|7|@]|8|@]|9|$]]|$1|1J|3|1K|4|5|6|2V|7|@]|8|@]|9|$]]|$1|1L|3|1M|4|5|6|2W|7|@]|8|@]|9|$]]|$1|1N|3|1O|4|5|6|2X|7|@]|8|@]|9|$]]|$1|1P|3|1Q|4|5|6|2Y|7|@]|8|@]|9|$]]|$1|1R|3|1S|4|5|6|2Z|7|@]|8|@$1T|30|1U|31|1|32]|$1T|33|1U|34|1|35]]|9|$]]|$1|1V|3|-4|4|5|6|36|7|@]|8|@]|9|$]]]|1W|$1X|$4|1Y|1Z|20|9|$21|22]]|23|$4|1Y|1Z|20|9|$21|24]]]]

<ol>
<li>Make sure that you have Office runtime installed on the server. </li>
<li>If you are using Windows Server 2008 then using office interops is a lenghty configuration and here are the steps.</li>
</ol>

Better is to move to Open XML or you can configure as below

<ul>
<li>Install MS Office Pro Latest (I used 2010 Pro)</li>
<li>Create User ExcelUser. Assign WordUser with Admin Group</li>
<li>Go to Computer -> Manage</li>
<li>Add User with below options</li>
<li>User Options Password Never Expires</li>
<li>Password Cannot Be Change</li>
</ul>

Com+ Configuration

<ul>
<li>Go to Control Panel - > Administrator -> Component Services -> DCOM Config</li>
<li>Open Microsoft Word 97 - 2003 Properties</li>
<li>General -> Authentication Level : None</li>
<li>Security -> Customize all 3 permissions to allow everyone</li>
<li>Identity -> This User -> Use ExcelUser /password</li>
<li>Launch the Excel App to make sure everything is fine</li>
</ul>

3.Change the security settings of Microsoft Excel Application in DCOM Config.

Controlpanel --> Administrative tools-->Component Services -->computers --> myComputer -->DCOM Config --> Microsoft Excel Application.

Right click to get properties dialog. Go to Security tab and customize permissions

See the posts here: <a href="http://social.msdn.microsoft.com/Forums/en-US/b6388275-b295-4e55-8c25-6d8788eac1ca/error-while-creating-excel-object" rel="noreferrer">Error while creating Excel object</a> , <a href="http://social.msdn.microsoft.com/Forums/vstudio/en-US/1d5f1c83-10a7-4322-80a9-0a4348c738c9/excel-manipulations-in-wcf-using-com" rel="noreferrer">Excel manipulations in WCF using COM</a>

blocks|key|180495|text|这看起来像是权限问题。我建议运行processMonitor来确定需要哪些权限。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|180496|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

This looks like a permission problem. I suggest running processMonitor to determine what permissions are needed.

blocks|key|184620|text|type|unstyled|depth|inlineStyleRanges|entityRanges|data|184621|我刚刚创建了一个简单的应用程序|blockquote|184622|184623|184624|应用程序的目标处理器是什么？我猜它是x86+-所以要么将它设置为x64，要么设置为anycpu。|offset|length|style|CODE|184625|我认为您遇到的问题是由于64位进程试图访问32位dll造成的。|184626|此外，如果您无法更改目标处理器，您可以尝试从IIS中的应用程序池设置启用32位应用程序。|184627|entityMap^0|0|0|0|0|I|3|W|3|15|6|0|0|0^^$0|@$1|2|3|-4|4|5|6|R|7|@]|8|@]|9|$]]|$1|A|3|B|4|C|6|S|7|@]|8|@]|9|$]]|$1|D|3|-4|4|5|6|T|7|@]|8|@]|9|$]]|$1|E|3|-4|4|5|6|U|7|@]|8|@]|9|$]]|$1|F|3|G|4|5|6|V|7|@$H|W|I|X|J|K]|$H|Y|I|Z|J|K]|$H|10|I|11|J|K]]|8|@]|9|$]]|$1|L|3|M|4|5|6|12|7|@]|8|@]|9|$]]|$1|N|3|O|4|5|6|13|7|@]|8|@]|9|$]]|$1|P|3|-4|4|5|6|14|7|@]|8|@]|9|$]]]|Q|$]]

<blockquote>
 I just created a simple application
</blockquote>

What is the target processor of the application? I am guessing it is <code>x86</code> - so either set it to <code>x64</code> or <code>anycpu</code>.

I think the issue you are having is due to a 64bit process trying to access a 32bit dll.

Also, if you can't change the target processor you could try to enable 32-bit Applications from the Application Pools settings in IIS.

blocks|key|2795484|text|您是否在服务器上安装了Excel？您正在使用的互操作接口用于自动化Excel，这需要在那里安装Excel应用程序。每个页面请求周期都可能启动一个单独的excel.exe实例。我强烈建议不要将此作为web应用程序的一部分。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2795485|你为什么要这样做？如果你想生成Excel文档，有更好的方法，包括本文中提到的OpenXML。请不要在服务器上运行Excel！|2795486|OpenXML软件开发工具包下载链接：http://www.microsoft.com/en-us/download/details.aspx?id=5124|offset|length|2795487|entityMap|0|LINK|mutability|MUTABLE|url|http://www.microsoft.com/en-us/download/details.aspx?id=5124^0|0|0|J|1O|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@$F|S|G|T|1|U]]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]]]

Do you have Excel installed on the server? The interop interfaces you're using are used to automate Excel which requires that the Excel application is installed there. Each page request cycle will potentially launch a separate instance of excel.exe. I would strongly advise against doing this as part of a web application.

Why do you want to do this? If you are wanting to generate Excel documents, there are much better ways to do this, including OpenXML as mentioned elsewhere on this thread. Please do not run Excel on the server!

Link to OpenXML SDK download: <a href="http://www.microsoft.com/en-us/download/details.aspx?id=5124" rel="nofollow">http://www.microsoft.com/en-us/download/details.aspx?id=5124</a>

blocks|key|2795492|text|使用读取和写入excel..它是免费的，并且是开源的|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2795493|对于示例|2795494|using+NPOI.HSSF.UserModel;
using+NPOI.SS.UserModel;

//.....

private+void+button1_Click(object+sender,+EventArgs+e)
{
++++HSSFWorkbook+hssfwb;
++++using+(FileStream+file+=+new+FileStream(@"c:\test.xls",+FileMode.Open,+FileAccess.Read))
++++{
++++++++hssfwb=+new+HSSFWorkbook(file);
++++}

++++ISheet+sheet+=+hssfwb.GetSheet("Arkusz1");
++++for+(int+row+=+0;+row+<=+sheet.LastRowNum;+row%2B%2B)
++++{
++++++++if+(sheet.GetRow(row)+!=+null)+//null+is+when+the+row+only+contains+empty+cells+
++++++++{
++++++++++++MessageBox.Show(string.Format("Row+{0}+=+{1}",+row,+sheet.GetRow(row).GetCell(0).StringCellValue));
++++++++}
++++}
}++|code-block|syntax|javascript|2795495|查看此Stackoverflow+question|offset|length|2795496|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/5855813/npoi-how-to-read-file-using-npoi^0|0|0|0|3|M|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|X|8|@]|9|@$K|Y|L|Z|1|10]]|A|$]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

use <a href="http://npoi.codeplex.com/" rel="nofollow noreferrer">NPOI</a> to read and write excel..it's free and open source 

for exapmle

<pre><code>using NPOI.HSSF.UserModel;
using NPOI.SS.UserModel;

//.....

private void button1_Click(object sender, EventArgs e)
{
 HSSFWorkbook hssfwb;
 using (FileStream file = new FileStream(@"c:\test.xls", FileMode.Open, FileAccess.Read))
 {
 hssfwb= new HSSFWorkbook(file);
 }

 ISheet sheet = hssfwb.GetSheet("Arkusz1");
 for (int row = 0; row &lt;= sheet.LastRowNum; row++)
 {
 if (sheet.GetRow(row) != null) //null is when the row only contains empty cells 
 {
 MessageBox.Show(string.Format("Row {0} = {1}", row, sheet.GetRow(row).GetCell(0).StringCellValue));
 }
 }
} 
</code></pre>

see this <a href="https://stackoverflow.com/questions/5855813/npoi-how-to-read-file-using-npoi">Stackoverflow question</a>

blocks|key|184649|text|对我有效的解决方案是更改启动应用程序池的用户(ApplicationPoolIdentity显然没有足够的权限访问COM对象)。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|184650|祝好运!|184651|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

solution that worked for me is to change user under which Application Pool is started (ApplicationPoolIdentity obviously has not enough rights to access COM object).

Good luck!

blocks|key|2795531|text|使用这个|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2795532|在管理员组中创建用户|2795533|在web配置中添加此用户详细信息，如下所示|2795534|<system.web>
+++<identity+impersonate="true"
++++userName="User+Name"
++++password="Password"+/>
++++`enter+code+here`</system.web>|code-block|syntax|javascript|2795535|重新启动IIS并再次检查|2795536|-托尼-|2795537|entityMap^0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|Q|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|R|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|S|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|T|8|@]|9|@]|A|$I|J]]|$1|K|3|L|5|6|7|U|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|V|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|W|8|@]|9|@]|A|$]]]|P|$]]

Use this 

<h1>create a user in admin group</h1>

<h1>add this user details in web config like below</h1>

<pre><code>&lt;system.web&gt;
 &lt;identity impersonate="true"
 userName="User Name"
 password="Password" /&gt;
 `enter code here`&lt;/system.web&gt;
</code></pre>

<h1>restart the IIS and check again</h1>

-tony-

blocks|key|3008047|text|尝试执行以下操作：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|3008048|对于服务用户，请确保Office程序集显式设置为systemprofile.|3008049|set++DCOM+|unordered-list-item|3008050|下的systemprofile.|ordered-list-item|3008051|setDCOM|3008052|文件夹下的开发和Office文件夹的版本。|3008053|3008054|3008055|3008056|您可以在找到更多详细信息|3008057|entityMap^0|0|0|0|0|1|1|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|A|$]]|$1|G|3|H|5|I|7|X|8|@]|9|@]|A|$]]|$1|J|3|K|5|I|7|Y|8|@]|9|@]|A|$]]|$1|L|3|M|5|I|7|Z|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|10|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|11|8|@]|9|@]|A|$]]|$1|P|3|-4|5|6|7|12|8|@]|9|@]|A|$]]|$1|Q|3|R|5|6|7|13|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|14|8|@]|9|@]|A|$]]]|T|$]]

try to do the following:

<ol>
<li>Make sure Office interop assemblies are installed.</li>
<li>Check the version of the assemblies on development and production.</li>
<li>Create Desktop folder under systemprofile.</li>
<li>set the DCOM security explicitly for the service user.</li>
</ol>

you can find more details <a href="http://waheedrous.wordpress.com/2014/01/26/error-office-interop-assemblies/" rel="nofollow">here</a>

blocks|key|2795577|text|有时，您创建了新的应用程序池，但无法通过DCOMCNFG解决它。然后还有另一种方法可以做：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2795578|将应用程序池的Identity+(型号名称)设置为LocalSystem。|offset|length|style|BOLD|2795579|我不知道根本原因，但它解决了我的问题一次。|2795580|entityMap^0|0|7|8|P|B|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@$D|N|E|O|F|G]|$D|P|E|Q|F|G]]|9|@]|A|$]]|$1|H|3|I|5|6|7|R|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|K|$]]

Sometimes, you create new application pool and cann't solve it via DCOMCNFG. Then there is another method to do:

Set the Identity (Model Name) of application pool to LocalSystem.

I don't know the root cause, but it solve my problem one time.

blocks|key|181994|text|就我个人而言，我运行了这些确切的步骤：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|181995|*安装互操作程序集:您可以从微软网站https://www.microsoft.com/en-us/download/details.aspx?id=3508&tduid=(09cd06700e5e2553aa540650ec905f71)(256380)(2459594)(TnL5HPStwNw-yuTjfb1FeDiXvvZxhh.R.Q)()安装|offset|length|181996|*检查程序集版本:检查开发和生产机器上的程序集版本。程序集将位于GAC中，在窗口7中，此文件夹为%25windir%25\assembly。|181997|*创建桌面文件夹:该服务使用系统配置文件下的桌面文件夹，因此如果不在此处，则需要创建此文件夹，以下是该文件夹的位置:对于64位应用程序:+C:\Windows\SysWOW64\config\systemprofile\Desktop对于32位应用程序:+C:\Windows\System32\config\systemprofile\Desktop|181998|*添加DCOM用户权限：|181999|-启动run窗口并键入'dcomcnfg‘。|182000|-展开Component+Services+->+Computers+->+My+Computer+->+DCOM+Config.|182001|-查找Microsoft+Excel应用程序。右键单击它并选择属性，然后选择Security选项卡。|182002|-选择“Launch+and+Activation+Permissions”和“Access+Permission”下的Customize单选按钮，然后单击两者的Edit按钮添加用户，如下所示。|182003|-单击Add按钮和用户'IIS_IUSRS‘和'NETWORK+SERVICE’，并授予他们完全权限。|182004|-转到Identity选项卡并选择"The+interactive+user“选项。|182005|-单击Apply和OK。|182006|entityMap|0|LINK|mutability|MUTABLE|url|https://www.microsoft.com/en-us/download/details.aspx?id=3508&tduid=(09cd06700e5e2553aa540650ec905f71)(256380)(2459594)(TnL5HPStwNw-yuTjfb1FeDiXvvZxhh.R.Q)()^0|0|I|4D|0|0|0|0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|17|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|18|8|@]|9|@$D|19|E|1A|1|1B]]|A|$]]|$1|F|3|G|5|6|7|1C|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|1D|8|@]|9|@]|A|$]]|$1|J|3|K|5|6|7|1E|8|@]|9|@]|A|$]]|$1|L|3|M|5|6|7|1F|8|@]|9|@]|A|$]]|$1|N|3|O|5|6|7|1G|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1H|8|@]|9|@]|A|$]]|$1|R|3|S|5|6|7|1I|8|@]|9|@]|A|$]]|$1|T|3|U|5|6|7|1J|8|@]|9|@]|A|$]]|$1|V|3|W|5|6|7|1K|8|@]|9|@]|A|$]]|$1|X|3|Y|5|6|7|1L|8|@]|9|@]|A|$]]|$1|Z|3|-4|5|6|7|1M|8|@]|9|@]|A|$]]]|10|$11|$5|12|13|14|A|$15|16]]]]

Personally, I ran these exact steps: 
* Install Interop Assemblies: you can install from Microsoft's website <a href="https://www.microsoft.com/en-us/download/details.aspx?id=3508&amp;tduid=(09cd06700e5e2553aa540650ec905f71)(256380)(2459594)(TnL5HPStwNw-yuTjfb1FeDiXvvZxhh.R.Q)()" rel="nofollow">https://www.microsoft.com/en-us/download/details.aspx?id=3508&amp;tduid=(09cd06700e5e2553aa540650ec905f71)(256380)(2459594)(TnL5HPStwNw-yuTjfb1FeDiXvvZxhh.R.Q)()</a> 
* Check assemblies version: check the version of the assemblies on development and production machines. The assemblies will be in the GAC, in widows 7 this folder is %windir%\assembly. 
* Create a Desktop folder: the service uses the desktop folder under systemprofile so you will need to create this folder if not there, here is the location of the folder:
For 64 bit applications : C:\Windows\SysWOW64\config\systemprofile\Desktop
For 32 bit applications : C:\Windows\System32\config\systemprofile\Desktop 
* Add DCOM user permissions: 
---start the run window and type 'dcomcnfg'. 
---Expand Component Services –> Computers –> My Computer –> DCOM Config. 
---Look for Microsoft Excel Application. Right click on it and select properties, then select the Security tab. 
---Select the Customize radio button under 'Launch and Activation Permissions' and 'Access Permission' and click the Edit button for both to add users as follows. 
---------Click the Add button and users 'IIS_IUSRS' and 'NETWORK SERVICE' and give them full privileges. 
---Go to the Identity tab and select "The interactive user" option. 
---Click Apply and OK.

blocks|key|184694|text|太晚了，无法回应。但是，如果这对仍然面临这个问题的人有所帮助。我通过以下方式解决了这个问题：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|184695|→将站点设置在专用池上，而不是共享池上。|184696|→支持32位应用程序。|184697|将应用程序池的标识设置为LocalSystem的→。|184698|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|J|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|K|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|L|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|M|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|I|$]]

Too late to respond. But, if this helps someone who is still facing the issue. I got this fixed by:

→ Set site on dedicated pool instead of shared one.

→ Enable 32 bit application support.

→ Set identity of the application pool to LocalSystem.

blocks|key|180616|text|两天前遇到了这个问题，整整花了两天时间，所以我发现我需要在DCOMCNFG+-->+My+Computer+Properties+-->+Com+Security+-->+Launch+and+Activation+Permissions+-->+Edit+defaults中授予IUSR用户组访问权限，并赋予IUSR所有权限。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|180617|希望它能帮助某些人……|180618|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Came across this issue two days back, spent whole complete two days, So I found that I need to give the access to IUSR user group at 
DCOMCNFG --> My Computer Properties --> Com Security --> Launch and Activation Permissions --> Edit defaults and give all rights to IUSR.

hope it will help someone....

blocks|key|182039|text|如果您尝试在64位上进行此配置，则必须在以下位置进行DCOMconfig配置(请参阅上面的其他答案)：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|182040|C:\WINDOWS\SysWOW64>mmc+comexp.msc+/32|code-block|syntax|javascript|182041|根据Setting+Process-Wide+Security+Using+DCOMCNFG的说法。|offset|length|182042|在此之后，我可以在没有管理员权限的情况下为IIS_IUSRS配置它。|style|CODE|182043|entityMap|0|LINK|mutability|MUTABLE|url|https://docs.microsoft.com/en-us/windows/win32/com/setting-processwide-security-using-dcomcnfg^0|0|0|2|18|0|0|L|9|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|X|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|Y|8|@]|9|@$I|Z|J|10|1|11]]|A|$]]|$1|K|3|L|5|6|7|12|8|@$I|13|J|14|M|N]]|9|@]|A|$]]|$1|O|3|-4|5|6|7|15|8|@]|9|@]|A|$]]]|P|$Q|$5|R|S|T|A|$U|V]]]]

If you are trying to configure this on 64bit, you have to do your DCOMconfig configuration (see other answers above) in:
<pre><code>C:\WINDOWS\SysWOW64&gt;mmc comexp.msc /32
</code></pre>
according to <a href="https://docs.microsoft.com/en-us/windows/win32/com/setting-processwide-security-using-dcomcnfg" rel="nofollow noreferrer">Setting Process-Wide Security Using DCOMCNFG</a>.
After this, I was able to configure this for <code>IIS_IUSRS</code> without administrator privileges.

I just created a simple application and hosted in IIS6.0. In code I'm just instantiating excel objects.

<pre><code>using excel = Microsoft.Office.Interop.Excel.Application;

namespace TestHosting
{
 public partial class WebForm1 : System.Web.UI.Page
 {
 protected void Page_Load(object sender, EventArgs e)
 {
 excel excelObj=new Microsoft.Office.Interop.Excel.Application();
 }
 }
}
</code></pre>

Its giving me following error

<pre><code> "Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005 Access is denied." (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)).
</code></pre>

System Configuration:

Windows server 2008,enterprise edition with 64 bit.
service pack 2

I tried with many possible solutions found on internet,but none of them were worked for me.

Some solution I tried are below

1) creating Desktop application under the path "C:\Windows\SysWOW64\config\systemprofile"
2)setting full permission/control for Microsfot.EXcelApplicaiton in DCOMCNFG
3)Killing all excel instances in Task Manager

Please help me in this regard,this is just sample app but in my original app is mostly about read and writing data from/to excel.

"Retrieving the COM class factory for component.... error: 80070005 Access is denied." (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))

Windows Server

身份验证

软件开发

服务器

Windows

我刚刚创建了一个简单的应用程序并托管在IIS6.0中。在代码中，我只是实例化excel对象。using excel = Microsoft.Office.Interop.Excel.Application;namespace TestHosting{    public partial class WebForm1 :...

问“正在检索组件的COM类工厂...错误: 80070005访问被拒绝。”(来自HRESULT的异常: 0x80070005 (E_ACCESSDENIED))
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问“正在检索组件的COM类工厂...错误: 80070005访问被拒绝。”(来自HRESULT的异常: 0x80070005 (E_ACCESSDENIED))EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问“正在检索组件的COM类工厂...错误: 80070005访问被拒绝。”(来自HRESULT的异常: 0x80070005 (E_ACCESSDENIED))
EN