导出EXCEL报错 PS:failed due to the following error: 80080005 服务器运行失败

[LiDaiQi_2014]

这是我在服务器上查看的日志

声明一下 ,在本地测试可以成功导出EXCEL文件

Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 2014-10-27 19:47:09
Event time (UTC): 2014-10-27 11:47:09
Event ID: 644156bd90ba43138ac31137a78005ba
Event sequence: 1580
Event occurrence: 10
Event detail code: 0

Application information:
Application domain: /LM/W3SVC/2/ROOT-2-130588802102690591
Trust level: Full
Application Virtual Path: /
Application Path: D:\Wikirig\
Machine name: WIN-D838RZ3D8ED

Process information:
Process ID: 1344
Process name: w3wp.exe
Account name: NT AUTHORITY\SYSTEM

Exception information:
Exception type: COMException
Exception message: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80080005 服务器运行失败 (Exception from HRESULT: 0x80080005 (CO_E_SERVER_EXEC_FAILURE)).
at System.Runtime.Remoting.RemotingServices.AllocateUninitializedObject(RuntimeType objectType)
at System.Runtime.Remoting.Activation.ActivationServices.CreateInstance(RuntimeType serverType)
at System.Runtime.Remoting.Activation.ActivationServices.IsCurrentContextOK(RuntimeType serverType, Object[] props, Boolean bNewObj)
at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck)
at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
at System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
at System.Activator.CreateInstance(Type type, Boolean nonPublic)
at System.Activator.CreateInstance(Type type)
at LunaErp.Web.MainView.Business.OrderView.OutExcel(DataTable dtt, DataTable dtData, String filename, Int32 exceptinstartline, Int32 orderstartline, Int32 AddressNumber) in e:\OldERP\LunaErp.Web\MainView\Business\OrderView.aspx.cs:line 668
at LunaErp.Web.MainView.Business.OrderView.ExcelData() in e:\OldERP\LunaErp.Web\MainView\Business\OrderView.aspx.cs:line 284
at LunaErp.Web.MainView.Business.OrderView.btnExcel_Click(Object sender, EventArgs e) in e:\OldERP\LunaErp.Web\MainView\Business\OrderView.aspx.cs:line 1751
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)



Request information:
Request URL: http://220.241.237.99:8888/MAINview/Business/OrderView.aspx?OrderCode=PI6573
Request path: /MAINview/Business/OrderView.aspx
User host address: 113.87.58.110
User:
Is authenticated: False
Authentication Type:
Thread account name: WIN-D838RZ3D8ED\Administrator

Thread information:
Thread ID: 46
Thread account name: WIN-D838RZ3D8ED\Administrator
Is impersonating: False
Stack trace: at System.Runtime.Remoting.RemotingServices.AllocateUninitializedObject(RuntimeType objectType)
at System.Runtime.Remoting.Activation.ActivationServices.CreateInstance(RuntimeType serverType)
at System.Runtime.Remoting.Activation.ActivationServices.IsCurrentContextOK(RuntimeType serverType, Object[] props, Boolean bNewObj)
at System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck)
at System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
at System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark)
at System.Activator.CreateInstance(Type type, Boolean nonPublic)
at System.Activator.CreateInstance(Type type)
at LunaErp.Web.MainView.Business.OrderView.OutExcel(DataTable dtt, DataTable dtData, String filename, Int32 exceptinstartline, Int32 orderstartline, Int32 AddressNumber) in e:\OldERP\LunaErp.Web\MainView\Business\OrderView.aspx.cs:line 668
at LunaErp.Web.MainView.Business.OrderView.ExcelData() in e:\OldERP\LunaErp.Web\MainView\Business\OrderView.aspx.cs:line 284
at LunaErp.Web.MainView.Business.OrderView.btnExcel_Click(Object sender, EventArgs e) in e:\OldERP\LunaErp.Web\MainView\Business\OrderView.aspx.cs:line 1751
at System.Web.UI.WebControls.Button.OnClick(EventArgs e)
at System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument)
at System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument)
at System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData)
at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


Custom event details:

[LiDaiQi_2014]

大神大神快快来

[全栈极简]

使用NPOI导出Excel。http://blog.csdn.net/chinacsharper/article/details/12999435

[LiDaiQi_2014]

引用 2 楼 guwei4037 的回复:

使用NPOI导出Excel。http://blog.csdn.net/chinacsharper/article/details/12999435

弱弱的问一下 你这个可以自由导入吗,就是我需要的数据可能是一部分,而且还会涉及到到计算处理 图片 以及添加文字 等等

[全栈极简]

你可以参考一下这个系列教程。http://tonyqus.sinaapp.com/tutorial

[LiDaiQi_2014]

引用 4 楼 guwei4037 的回复:

你可以参考一下这个系列教程。http://tonyqus.sinaapp.com/tutorial

好的 谢谢 我回去研究下

[於黾]

看看这个,也许对你有帮助

[LiDaiQi_2014]

引用 7 楼 Z65443344 的回复:

看看这个,也许对你有帮助

请问下 , 你们都推荐NOPI导出 , 是不是说 Excel组件有它的局限性,还是说本身就有问题,

[於黾]

引用 8 楼 LiDaiQi_2014 的回复:

[quote=引用 7 楼 Z65443344 的回复:] 看看这个,也许对你有帮助

请问下 , 你们都推荐NOPI导出 , 是不是说 Excel组件有它的局限性,还是说本身就有问题,[/quote] 局限性非常大 首先你服务器上必须按照office,还必须跟你引用的版本一致,然后还要正确的注册com组件,还要给相应的权限 导入导出的时候还要开个外部excel进程,不正确杀死进程可能会导致内存泄露等问题

[LiDaiQi_2014]

最后问一下, 你看下图 , NOPI是否能做到这种EXCEL,几乎都是自定义数据显示在哪个单元格里面的,不是普通的一股脑全部导一起哦

[於黾]

NPOI可以对单元格进行操作,可以合并单元格,可以修改单元格背景色 好像仅仅不能修改单元格内某个文字的颜色,因为它最低只能对单元格进行操作

[LiDaiQi_2014]

虽然没有找到答案 , 但是还是知道了一些, 结贴了