操作过Excel的大大来下吧虽然知道希望渺茫

ChargeForward 2010-01-07 01:59:09

命名空间 using Microsoft.Office.Interop.Excel;
引用的是12.0.0.0版本DLL
代码如下



var missing = System.Reflection.Missing.Value;

            Application excel = new Application();   //lauch excel application

            if (excel == null)

            {

                //TODO:读不到这个Excel

            }

            else

            {

                



                excel.Visible = false; 



                excel.UserControl = true;

               

                Workbook wb = excel.Application.Workbooks.Open(path, missing, true, missing, missing, missing,

                 missing, missing, missing, true, missing, missing, missing, missing, missing);

                

                Worksheet ws = (Worksheet)wb.Worksheets.get_Item(1);

               .....

同样是两台64为服务器一台测试用一台是正网

测试的时候没有任何问题在正网服务器部署时发现没有安装Office 于是马上安装了Office2007
然后注册组件修改COM组件访问权限为Everyone

然后运行时 Application excel = new Application(); 这句没有报错也就是说可以实例化一个Excel对象

但是 Workbook wb = excel.Application.Workbooks.Open(path, missing, true, missing, missing, missing,
missing, missing, missing, true, missing, missing, missing, missing, missing);这一句会宕掉
抛出异常了



Server Error in '/' Application.

The server threw an exception. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT))

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.



Exception Details: System.Runtime.InteropServices.COMException: The server threw an exception. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT))



Source Error:



An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.



Stack Trace:



[COMException (0x80010105): The server threw an exception. (Exception from HRESULT: 0x80010105 (RPC_E_SERVERFAULT))]

   Microsoft.Office.Interop.Excel.Workbooks.Open(String Filename, Object UpdateLinks, Object ReadOnly, Object Format, Object Password, Object WriteResPassword, Object IgnoreReadOnlyRecommended, Object Origin, Object Delimiter, Object Editable, Object Notify, Object Converter, Object AddToMru, Object Local, Object CorruptLoad) +0

   Core.Store.NewImpStorage.ReadProdDataFromExcel(String path, Int32 shopId, Int32 startRowNum, String& errorTxt) in D:\Pro_SVN\trunk\Core\Store\NewImpStorage.cs:58

   views.impproddata.updateexcel.Button1_Click(Object sender, EventArgs e) in D:\Pro_SVN\trunk\views\impproddata\updateexcel.aspx.cs:50

   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +115

   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +140

   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +29

   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +2981



Version Information: Microsoft .NET Framework Version:2.0.50727.3082; ASP.NET Version:2.0.50727.3082

本地的32位机不会报错测试的那台是64位也没有报错就是正网这台总出乱子哎愁死

...全文

578 47 打赏收藏转发到动态举报

写回复

用AI写文章

47 条回复

切换为时间正序

请发表友善的回复…

发表回复

yang3389r 2010-01-07

打赏
举报

╮(╯▽╰)╭ 打嗝~！

shizhen_zhang 2010-01-07

打赏
举报

一直活在明天 2010-01-07

打赏
举报

看看打开参数有没有错，2003和2007打开参数个数不同，但是在vba里好像没有多大区别，最好不用com组件，用vs dll自己带的。要是向叶面写excel就要看有权限没有，如果没有最好配置文件加个签名，但是这样可能会不安全。</httpHandlers>

<identity impersonate="true" userName="服务器用户名（gi域）\用户名" password="密码"/>
<httpModules>

yuanhuiqiao 2010-01-07