ASP.NETÖÐÊý¾Ý¿âÊý¾Ýµ¼ÈëExcel²¢´òÓ¡
ÖÚËùÖÜÖª£¬WEBÉϵĴòÓ¡ÊDZȽÏÀ§Äѵ쬳£¼ûµÄWEBÉÏ´òÓ¡µÄ·½·¨´ó¸ÅÓÐÈýÖÖ£º
¡¡¡¡1¡¢Ö±½ÓÀûÓÃIEµÄ´òÓ¡¹¦ÄÜ¡£Ò»°ãÀ´Ëµ£¬ÕâÖÖ·½·¨¿ÉÒÔ×öЩÀ©Õ¹£¬¶ø²»Êǵ¥µ¥µÄµ÷ÓÃjavascript:print()ÕâÑù¼òµ¥£¬±ÈÈ磬¿ÉÒÔʹÓÃÈçÏ´úÂ룺
£¼OBJECT
id=WebBrowser classid=CLSID:8856F961-340A-11D0-A96B-00C04FD705A2 height=0 width=0£¾
£¼/OBJECT£¾
£¼input
type=button value=´òÓ¡ onclick=document.all.WebBrowser.ExecWB(6,1)£¾
£¼input
type=button value=Ö±½Ó´òÓ¡ onclick=document.all.WebBrowser.ExecWB(6,6)£¾
£¼input
type=button value=Ò³ÃæÉèÖà onclick=document.all.WebBrowser.ExecWB(8,1)£¾
£¼input
type=button value=´òÓ¡Ô¤ÀÀ onclick=document.all.WebBrowser.ExecWB(7,1)£¾
¡¡¡¡ÕâÖÖ·½·¨¿ÉÒÔÊÊÓÃÓÚ¼òµ¥µÄÊý¾Ý´òÓ¡£¬¶ÔϵͳҪÇ󲻸ߣ¬µ«²»×ãÖ®´¦ÔÚÓÚ¿ÉÒÔ¿ØÖƵÄÄÜÁ¦±È½Ï²î£¬±ÈÈç´¦Àí·ÖÒ³µÈÎÊÌâ¡£
¡¡¡¡2¡¢ÀûÓÃË®¾§±¨±í»òÆäËûµÚÈý·½¹¤¾ß£¬Èç΢ÈíµÄReporting service¡£Ë®¾§±¨±í»òÆäËûµÚÈý·½¿Ø¼þµÄ´òÓ¡£¬Ò»°ãÊǵ¼³öµ½Excel£¬WORD£¬PDFµÈÔÙ½øÐдòÓ¡µÄ£¬Ð§¹û±È½ÏºÃ£¬µ«±à³Ì±È½Ï¸´ÔÓ£¬¿ØÖÆÆðÀ´Ò²²»´ó·½±ã£¬¶øÇÒÕâЩ¹¤¾ß¶¼ÊÇÒªÊշѵġ£
¡¡¡¡3¡¢½«Êý¾Ý¿âµÄÊý¾Ý»òÒª´òÓ¡µÄÄÚÈݵ¼³öµ½Excel£¬WordÖÐÈ¥´òÓ¡¡£Ê¹ÓÃÕâÖÖ·½·¨£¬¿ÉÒÔÔÚ·þÎñ¶Ë»òÕ߿ͻ§¶Ë½øÐС£ÔÚ·þÎñ¶ËʹÓõϰ£¬ÒªÇó·þÎñ¶ËÒª°²×°Word£¬Excel£¬ÔÚ¿Í»§¶ËʹÓõϰ£¬ÒªÇó¿Í»§¶ËÔÚIEµÄ°²È«ÉèÖÃÉÏÓÐÒ»¶¨ÒªÇó¡£Ê¹ÓÃÕâÖÖ·½·¨£¬¿ÉÊÊÓ¦ÐԱȽÏÇ¿£¬¿ØÖƽϺᣱ¾ÎĽ«ÒÔÔÚASP.NETÖÐʹÓÃExcelΪÀý×Ó£¬½éÉÜÈçºÎ½«Êý¾Ýµ¼³öµ½ExcelµÄ¼¸ÖÖ·½·¨¡£
¡¡¡¡Ê×ÏÈ£¬ÏȽéÉÜÔÚ·þÎñ¶ËʹÓÃExcelµÄ·½·¨¡£ÒªÔÚ·þÎñÆ÷¶ËʹÓÃExcel£¬±ØÐëÒªÇó·þÎñÆ÷¶Ë°²×°Excel,²¢ÇÒÒªÇóÒ»¶¨µÄ·ÃÎÊȨÏÞ¡£±ÈÈ磬ÐèÒªÌí¼Ó£¼identity impersonate="true"/£¾µ½web.configÖС£ÔÚ±¾ÎÄÖУ¬Òª¸øÓèWEBĿ¼¿ÉдµÄȨÏÞ¡£
¡¡¡¡½ÓÏÂÀ´£¬Ê¹ÓÃVS.NET 2003н¨Ò»¸öVB.NETµÄ¹¤³Ì£¬²¢Ìí¼ÓÒýÓá£ÓÉÓÚÎÒÃÇҪʹÓõÄÊÇExcel£¬ËùÒÔÌí¼ÓÒ»¸ö¹ØÓÚCOMµÄÓ¦Óã¬ÕâÀïÌí¼ÓµÄÊÇMicrosoft Excel Object Library£¬Ö®ºó£¬Ìí¼ÓµÄ´úÂëÈçÏ£º
Imports System.Runtime.InteropServices.Marshal
Imports Office
Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
¡¡'ÒÔCOM·½Ê½´¦ÀíExcel
¡¡Dim oExcel As New Excel.Application
¡¡Dim oBooks As Excel.Workbooks, oBook As Excel.Workbook
¡¡Dim oSheets As Excel.Sheet
Ïà¹ØÎĵµ£º
public static string TheColor(string color,string enumName)
{
return string.Format("<span style=\"color={0}\">{1}</span>",color,enumName);
  ......
Cascading drop down lists is a really nice feature for web developers. I thought it was time to write an article on how to do this using ASP.NET and jQuery. Well here’s one way of doing it. Before we get started, this example uses the latest version of jQuery which is 1.3.2.&n ......
¶ÔÓÚ´óÁ¿µÄÊý¾Ý£¬ÓÐʱºòµ¼³öµ½ExcelÖн«¸ü¼Ó·½±ã½øÐÐÊý¾Ýͳ¼Æ·ÖÎö£¬¶ø¶ÔÓÚÅŰæ´òÓ¡Ôòµ¼³öµ½WorldÎĵµÖиü¼Ó·½±ã¡£ÔÚASP.NET¿ÉÒÔͨ¹ýÉÙÁ¿´úÂëʵÏÖÕâÁ½ÖÖµ¼³ö¡£
н¨Ò»Ò³Ã棬¸ÃÒ³Ãæ²¼¾ÖHtmlÔ´ÂëÈçÏ£º
<form id="form1" runat="server"><div> ......
ǰÑÔ
FCKeditorÊÇʹÓ÷dz£¹ã·ºµÄHTML±à¼Æ÷£¬±¾ÎÄ´Ó ASP.NET µÄʹÓó¡¾°¶Ô FCKeditor Óë FCKeditor.NET µÄÅäÖᢹ¦ÄÜÀ©Õ¹£¨Èç×Ô¶¨ÒåÎļþÉÏ´«×ÓĿ¼¡¢×Ô¶¨ÒåÎļþÃû¡¢ÉÏ´«Í¼Æ¬µÄºóÆÚ´¦ÀíµÈ£©¡¢ÒÔ¼°°²È«ÐÔ½øÐгõ²½µÄ²ûÊö¡£
Ï£ÍûÄܰïÖúÓÐͬÑùÐèÇóµÄͬÈʽÚʡһµãʱ¼ä£»Ò²Ï£Íû¸÷λÄÜÖ¸ÕýÆäÖеIJ»×㡣лл¡£
Ò»¡¢×Ô¶¨Òå FCKedit ......
ÏÞÉèÖÃÒÔWindows Server 2003ΪÀý£¬ÐéÄâÖ÷»úÓû§²»±Ø½øÐдËÏîÉèÖá£Ê×ÏÈ£¬ÎÒÃÇÐèÒªÓõ½ÒÔϵÄ×é:
IIS_WPG ×飨Ҳ³ÆÎª IIS ¹¤×÷½ø³Ì×飬IIS Worker Process Group£©
Guests×é £¨À´±ö×飬ÔÚϵͳÖÐÓµÓÐ×îÉÙµÄȨÏÞ£©
ÒÔ¼°ÒÔϵÄÕʺÅ:
Internet À´±öÕÊ»§ £¨ÄäÃû·ÃÎÊ Internet ÐÅÏ¢·þÎñµÄÄÚÖÃÕÊ»§£©
Æô¶¯ IIS ½ø³ÌÕÊ»§ £¨ÓÃÓ ......