Asp.NetÖÐWord,ExcelµÈoffice com×é¼þ²Ù×÷ȨÏÞµÄÎÊÌâ
½üÈÕÔÚ´ò¿ªÔÀ´Ð´µÄÒ»¸öÍøÒ³³ÌÐòÔËÐÐʱ£¬³öÏÖÁËExcel²Ù×÷ȨÏÞµÄÎÊÌ⣬¾ßÌåµÄ˵¾ÍÊÇÔÚ´úÂëÖе÷ÓÃÏÂÃæÕâ¶ÎÓëExcel²Ù×÷ÓйصÄÓï¾äʱ£¬
¡¡¡¡Application curExcelApp = new ApplicationClass();
¡¡¡¡ÌáʾȨÏÞ²»×㣬¾ßÌåµÄÌáʾÄÚÈÝÈçÏ£º
¡¡¡¡¼ìË÷ COM À๤³§ÖÐ CLSID Ϊ {00024500-0000-0000-C000-000000000046} µÄ×é¼þʱʧ°Ü£¬ÔÒòÊdzöÏÖÒÔÏ´íÎó: 80070005¡£
¡¡¡¡¡¡¡¡ËµÃ÷: Ö´Ðе±Ç° Web ÇëÇóÆڼ䣬³öÏÖδ´¦ÀíµÄÒì³£¡£Çë¼ì²é¶ÑÕ»¸ú×ÙÐÅÏ¢£¬ÒÔÁ˽âÓйظôíÎóÒÔ¼°´úÂëÖе¼Ö´íÎóµÄ³ö´¦µÄÏêϸÐÅÏ¢¡£ Òì³£ÏêϸÐÅÏ¢: system.UnauthorizedAccessException: ¼ìË÷ COM À๤³§ÖÐ CLSID Ϊ {00024500-0000-0000-C000-000000000046} µÄ×é¼þʱʧ°Ü£¬ÔÒòÊdzöÏÖÒÔÏ´íÎó: 80070005¡£ ASP.NET δ±»ÊÚȨ·ÃÎÊËùÇëÇóµÄ×ÊÔ´¡£Ç뿼ÂÇÊÚÓè ASP.NET ÇëÇó±êʶ·ÃÎÊ´Ë×ÊÔ´µÄȨÏÞ¡£ASP.NET ÓÐÒ»¸öÔÚÓ¦ÓóÌÐòûÓÐÄ£ÄâʱʹÓõĻù½ø³Ì±êʶ(ͨ³££¬ÔÚ IIS 5 ÉÏΪ {MACHINE}ASPNET£¬ÔÚ IIS 6 ÉÏΪÍøÂç·þÎñ)¡£Èç¹ûÓ¦ÓóÌÐòÕýÔÚͨ¹ý <identity impersonate="true"/> Ä£Ä⣬Ôò±êʶ½«ÎªÄäÃûÓû§(ͨ³£Îª IUSR_MACHINENAME)»ò¾¹ýÉí·ÝÑéÖ¤µÄÇëÇóÓû§¡£ Òª½« ASP.NET ·ÃÎÊȨÏÞÊÚÓèij¸öÎļþ£¬ÇëÔÚ×ÊÔ´¹ÜÀíÆ÷ÖÐÓÒ»÷¸ÃÎļþ£¬Ñ¡Ôñ“ÊôÐÔ”£¬È»ºóÑ¡Ôñ“°²È«”Ñ¡Ï¡£µ¥»÷“Ìí¼Ó”Ìí¼ÓÊʵ±µÄÓû§»ò×顣ͻ³öÏÔʾ ASP.NET ÕÊ»§£¬Ñ¡ÖÐËùÐè·ÃÎÊȨÏÞ¶ÔÓ¦µÄ¿ò¡£ Ô´´íÎó: ¡¡¡¡¡¡¡¡ ÐÐ 533:¡¡¡¡¡¡¡¡//´´½¨ExcelÐÅÏ¢¡¡¡¡¡¡¡¡
ÐÐ 534:¡¡¡¡¡¡¡¡object missing = system.Reflection.Missing.Value;¡¡¡¡¡¡¡¡
ÐÐ 535:¡¡¡¡¡¡¡¡Application curExcelApp = new ApplicationClass();¡¡¡¡¡¡¡¡
ÐÐ 536:¡¡¡¡¡¡¡¡curExcelApp.Application.DisplayAlerts = false;¡¡¡¡¡¡¡¡
ÐÐ 537:¡¡¡¡¡¡¡¡Workbook curWorkBook = curExcelApp.Workbooks.Add(XlWBATemplate.xlWBATWorksheet);
¡¡¡¡ÔÀ´Åöµ½¹ýÕâÖÖÇé¿ö£¬ÖªµÀÊÇÓÉÓÚExcelµÄDCom×é¼þȨÏÞ²»×ãËùÒýÆðµÄ£¬ËùÒÔ°´ÕÕÔÀ´µÄ²½Öè½øÐÐÉèÖã¬ÈçÏÂËùʾ£º
¡¡¡¡1:ÔÚ·þÎñÆ÷ÉÏ°²×°officeµÄExcelÈí¼þ;
¡¡¡¡2:ÔÚ"¿ªÊ¼"->"ÔËÐÐ"ÖÐÊäÈëdcomcnfg.exeÆô¶¯"×é¼þ·þÎñ";
¡¡¡¡3:ÒÀ´ÎË«»÷"×é¼þ·þÎñ"->"¼ÆËã»ú"->"ÎҵĵçÄÔ"->"DCOMÅäÖÃ";
¡¡¡¡4:ÔÚ"DCOMÅäÖÃ"ÖÐÕÒµ½"Microsoft Excel Ó¦ÓóÌÐò",ÔÚËüÉÏÃæµã»÷ÓÒ¼ü,È»ºóµã»÷"ÊôÐÔ",µ¯³ö"Microsoft Excel Ó¦ÓóÌÐòÊôÐÔ"¶Ô»°¿ò;
¡¡¡¡5:µã»÷"±êʶ"±êÇ©,Ñ¡Ôñ"½»»¥Ê½Óû§";
¡¡¡¡6:µ
Ïà¹ØÎĵµ£º
1.ÖØÔØprotected override bool OnBubbleEvent(object source, EventArgs args)
OnBubbleEventÊǿؼþÄÚ°üº¬µÄ¿Ø¼þÏòÍâ²ã¿Ø¼þ×÷ʼþðÅÝ
-------------------------------------------------------------------------------------------------------------------------------------------
using System;
using System.Co ......
Ò»¡¢ÈÏʶWeb.configÎļþ
Web.config ÎļþÊÇÒ»¸öXMLÎı¾Îļþ£¬ËüÓÃÀ´´¢´æ ASP.NET Web Ó¦ÓóÌÐòµÄÅäÖÃÐÅÏ¢£¨Èç×î³£ÓõÄÉèÖÃASP.NET Web Ó¦ÓóÌÐòµÄÉí·ÝÑéÖ¤·½Ê½£©£¬Ëü¿ÉÒÔ³öÏÖÔÚÓ¦ÓóÌÐòµÄÿһ¸öĿ¼ÖС£µ±Äãͨ¹ý.NETн¨Ò»¸öWebÓ¦ÓóÌÐòºó£¬Ä¬ÈÏÇé¿öÏ»áÔÚ¸ùĿ¼×Ô¶¯´´½¨Ò»¸öĬÈ쵀 Web.configÎļþ£¬°üÀ¨Ä¬ÈϵÄÅäÖÃÉèÖ㬠......
ÍøÂç´òÓ¡¸ÅÊö
¡¡¡¡• B/S½á¹¹µ¼ÖÂÁËWebÓ¦ÓóÌÐòÖдòÓ¡µÄÌØÊâÐÔ¡£
¡¡¡¡• ³ÌÐòÔËÐÐÔÚä¯ÀÀÆ÷ÖУ¬´òÓ¡»úÔÚ±¾µØ£¬¶øÎļþÈ·¿ÉÄÜÔÚ·þÎñÆ÷ÉÏ£¬µ¼ÖÂÁË´òÓ¡¿ØÖƲ»ÊǺÜÁé»î¡£
¡¡¡¡• ¸ñʽÈçºÎ¿ØÖƺͶ¨ÖƵȣ¬ÊÇÎÒÃÇ¿ª·¢ÖпÉÄÜ»áÃæ¶ÔµÄÎÊÌâ¡£
¡¡¡¡´òÓ¡ÎĵµµÄÉú³É
¡¡¡¡• 1¡¢¿Í»§¶Ë½Å±¾·½Ê½
¡¡¡¡Ò»°ãÇé¿öÏ£¬Ö÷ÒªÊ ......
@import url(¡°layout.css¡±)
CSS Selectors: *, p, div span, div > span, *[href], li+li, .title, #container, #title p:first-child, a:link, a:hover, a:visited, p:before, p:after
p:after{content:¡¯url(images/quote.gif)¡¯}
!important State Mode: Off, InProc, StateServer, SQLServer, C ......
Èç¹û²âÊÔµÄurlµØÖ·ÊÇhttp : //www.test.com/testweb/default.aspx, ½á¹ûÈçÏ£º
Request.ApplicationPath: /testweb
Request.CurrentExecutionFilePath: /testweb/default.aspx
Request.FilePath: /testweb/default.aspx
Request.Path: /testweb/default.aspx
Request.PhysicalApplicationPath: E:\WWW\testwebReq ......