服务器导出Excel

[xuchunyao]

异常详细信息: System.UnauthorizedAccessException: 检索 COM 类工厂中 CLSID 为 {000209FF-0000-0000-C000-000000000046} 的组件时失败，原因是出现以下错误: 80070005。
我是2000操作系统,组件服务-计算机-我的电脑-dcom配置找到Microsoft Excel 应用程序里右键没有属性，只提示配置属性成功，可是我想设定他是交互的，如何设定？

[j45kp]

• Go to the Start-Run menu item.
• Type in "DCOMCNFG" and hit enter.
• This should load the "Component Services" MMC (you can also load from Administrative Tools - Component Services"
• Expand "Component Services"
• Expand "Computers"
• Expand "My Computer"
• Select the "DCOM Config" item
• Select the "Microsoft Excel Application" item.
• Right click and select Properties
• Select the Security Tab and you should see the following:




• Under "Launch and Activation Permissions" select the "Customize" option.
• Click the "Edit" button
Windows XP Windows 2003 Server
• Click the "Add" button to add a new account to the list.
• On the dialog that is displayed click the Locations button

(this is because by default your domain will be selected and we need a local account)

In this dialog scroll the list to the top (sometimes the first item is not visible) but scroll to the top and select the first item which is your computer name. In the list below "CCROWE" is the name of my computer.




• Click the OK button
• On the dialog that is displayed enter "ASPNET" as the account name (make sure location is set to the name of the computer that IIS is on) on Windows XP or if you are running on Windows 2003 Server you must enter the account that the Application Pool is running as, by default "Network Service"
Windows XP Windows 2003 Server

Note: A quicker way on Windows XP is to just enter the computer name and the account
so in my case that would be:

ccrowe\ASPNET

•
• Click the OK button
• Now make sure you select the following options for the "ASP.NET Machine Account" or the account that is the application pool identity ( by default Network Service)

• Local Launch : Allow
• Remote Launch : [blank]
• Local Activation : Allow
• Remote Activation : [blank]
These settings can be seen below:

Windows XP Windows 2003 Server

Click the OK button and test your web application again and it should work fine.
Note: Remember if you are running on Windows 2003 Server you must use the application pool identity as the account and not the ASPNET account.

[clever_yang]

楼主可以试试:

开始->运行->dcomcnfg

Component Serivices

-Computer

-My Computer

在DCOM Config 中找到"Microsoft Excel Application".

在XP系统，我添加了IIS默设用户：Internet Guest Accout(Computername/IUSER_USER)，即　如果找不到该用户可点击"Add(添加)"->"Advanced(高级)"，用"Find now(立即查找)"找到相应的用户。添加进去以后,把"Local launch(本地启动)"和"Local Activation(本地激活)"在允许权限框里打勾

[wts_net]

学习

[A海阔天空]

我也遇到过这样的问题了。当时改了以后还是不行,本地可以。上传到服务器上就不行了