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:µ
Ïà¹ØÎĵµ£º
·µ»Ø°´Å¥µÄʵÏÖ·½·¨£¨asp.net ÖУ©
Òý×Ô:http://blog.sina.com.cn/s/blog_49df2d0b0100aqoy.html
·µ»ØÉÏÒ»Ò³µÄÕâ¸ö¶«¶«ÔÚÎÒÃÇ×öÏîÄ¿µÄʱºòÒ»°ãÊÇÓÃÓÚÌîдÍê±íµ¥ºóÈ·ÈϵÄʱºò£¬ÓжÔÔÀ´ÊäÈëµÄÊý¾Ý½øÐÐÐÞ¸ÄʱÓõ쬻òÕßÊÇÒòÎªÍøÕ¾ÎªÁË·½±ãä¯ÀÀÕß¶øÓÐÐÄÌí¼Ó µÄÒ»¸ö¶«¶«£¬Ò»°ãÕâÖÖ¹¦ÄܵÄʵÏÖÔÚASP.netÖж¼ÊÇÓÃÒ»¸öbuttonµÄ¿ ......
Ê×ÏÈÃèÊöÒ»ÏÂÎÊÌâ:ÒòΪ¿Í»§µÄÐèÒª,°ÑËùÓжÔÓÚÊý¾Ý¿âµÄ²Ù×÷×ö³ÉÁË´æ´¢¹ý³Ì,ͬʱҲ´æÔÚ´øÓÐÊäÈë²ÎÊýµÄ´æ´¢¹ý³Ì.¿Í»§ÒªÇó½«ËùÓеÄÐÅÏ¢¶¼¿ÉÒÔÓÃË®¾§±¨±íÏÔʾ.ÎÒÃǶ¼ÖªµÀ,ҪʹÓÃË®¾§±¨±íÎÒÃǾÍҪʹÓÃÊý¾ÝÔ´µÄ.ÔÚÕâÀï,ÎÒÃÇʹÓõÄÊý¾ÝÔ´×ÔÈ»¶øÈ»Ò²¾ÍÊÇ´æ´¢¹ý³ÌÁË.µ±È»,ÎÒÃÇÒ²ÊÇÖªµÀµÄ,ÔÚADO.NETµÄÁ ......
Ò»¡¢ÈÏʶWeb.configÎļþ
Web.config ÎļþÊÇÒ»¸öXMLÎı¾Îļþ£¬ËüÓÃÀ´´¢´æ ASP.NET Web Ó¦ÓóÌÐòµÄÅäÖÃÐÅÏ¢£¨Èç×î³£ÓõÄÉèÖÃASP.NET Web Ó¦ÓóÌÐòµÄÉí·ÝÑéÖ¤·½Ê½£©£¬Ëü¿ÉÒÔ³öÏÖÔÚÓ¦ÓóÌÐòµÄÿһ¸öĿ¼ÖС£µ±Äãͨ¹ý.NETн¨Ò»¸öWebÓ¦ÓóÌÐòºó£¬Ä¬ÈÏÇé¿öÏ»áÔÚ¸ùĿ¼×Ô¶¯´´½¨Ò»¸öĬÈ쵀 Web.configÎļþ£¬°üÀ¨Ä¬ÈϵÄÅäÖÃÉèÖ㬠......
1. ×¢²ájsº¯Êý
String scriptString = "<script language=JavaScript>function doClick(){";
scriptString += "for(var index=0;index<myArray.length;index++)";
scriptString += "alert(myArray[index]);}<";
scriptString += "/" + "script>";
ClientScript.RegisterStartupScript(typeof(WebForm2) ......
ASP.NET 4µÄWeb Formsµ±ÖУ¬×îÁîÈ˼¤É͵ģ¬ÔòιýÓÚÊÇURL Routing»úÖÆµÄÈ«ÃæÖ§³Ö¡£¹ýÈ¥ÔÚASP.NET 3.5 SP1µ±ÖУ¬Web Forms»ò¶à»òÉپͿªÊ¼Ö§³ÖURL Routing»úÖÆ£¬ËüÈÃÎÒÃÇÔÚÍøÖ·µÄ³ÊÏÖÒÔ¼°Ê¹ÓÃÉϸü¼ÓµÄÓе¯ÐÔ¡£
¹ýÈ¥ÎÒÃÇÔÚASP.NETµ±ÖУ¬Ï°¹ßÓÚµ×ÏÂÕâÑùµÄÍøÖ·³ÊÏÖ·½Ê½£º
http://myWebSite/EditProduct.aspx?Id=1
µ«×î½ü¼¸ÄêR ......