ASP.NETÖн«Êý¾ÝÊä³öµ½Excel
ÔÚ¿ª·¢ISOÎļþ¹ÜÀíϵͳµÄʱºò£¬Ôø¾Óöµ½¹ýÒª½«ASPXÖ±½ÓÊä³öµ½EXCELµÄÐèÇó£¬ÏÖ½«¾ÑéËùµÃÓë´ó¼Ò·ÖÏí¡£ Æäʵ£¬ÀûÓÃASP.NETÊä³öÖ¸¶¨ÄÚÈݵÄWORD¡¢EXCEL¡¢TXT¡¢HTMµÈÀàÐ͵ÄÎĵµºÜÈÝÒ׵ġ£Ö÷Òª·ÖΪÈý²½À´Íê³É¡£
¡¡¡¡Ò»¡¢¶¨ÒåÎĵµÀàÐÍ¡¢×Ö·û±àÂë
Response.Clear();
Response.Buffer= true;
Response.Charset="utf-8";
//ÏÂÃæÕâÐкÜÖØÒª£¬ attachment ²ÎÊý±íʾ×÷Ϊ¸½¼þÏÂÔØ£¬Äú¿ÉÒÔ¸Ä³É onlineÔÚÏß´ò¿ª
//filename=FileFlow.xls Ö¸¶¨Êä³öÎļþµÄÃû³Æ£¬×¢ÒâÆäÀ©Õ¹ÃûºÍÖ¸¶¨ÎļþÀàÐÍÏà·û£¬¿ÉÒÔΪ£º.doc || .xls || .txt ||.htm
Response.AppendHeader("Content-Disposition","attachment;filename=FileFlow.xls");
Response.ContentEncoding=System.Text.Encoding.GetEncoding("utf-8");
//Response.ContentTypeÖ¸¶¨ÎļþÀàÐÍ ¿ÉÒÔΪapplication/ms-excel || application/ms-word || application/ms-txt || application/ms-html || »òÆäËûä¯ÀÀÆ÷¿ÉÖ±½ÓÖ§³ÖÎĵµ
Response.ContentType = "application/ms-excel";
this.EnableViewState = false;
¡¡¡¡¶þ¡¢¶¨ÒåÒ»¸öÊäÈëÁ÷
System.IO.StringWriter oStringWriter = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter oHtmlTextWriter = new System.Web.UI.HtmlTextWriter(oStringWriter);
¡¡¡¡Èý¡¢½«Ä¿±êÊý¾Ý°ó¶¨µ½ÊäÈëÁ÷Êä³ö
this.RenderControl(oHtmlTextWriter);
//this ±íʾÊä³ö±¾Ò³£¬ÄãÒ²¿ÉÒÔ°ó¶¨datagrid,»òÆäËûÖ§³Öobj.RenderControl()ÊôÐԵĿؼþ
Response.Write(oStringWriter.ToString());
Response.End();
¡¡¡¡×ܽ᣺±¾Àý³ÌÔÚMicrosoft Visual Studio .NET 2003ƽ̨ϲâÊÔͨ¹ý£¬ÊÊÓÃÓÚC#ºÍVB£¬µ±²ÉÓÃVBµÄʱºò½« this ¹Ø¼ü×Ö¸Ä³É me ¡£
Ïà¹ØÎĵµ£º
ÿ¸öWebÓ¦ÓóÌÐò¶¼Òª¹æ»®×Ô¼ºµÄĿ¼½á¹¹£¬³ýÁË×Ô¼ºÉè¼ÆµÄĿ¼½á¹¹ÒâÍ⣬ASP.NetÒ²¶¨ÒåһЩÓÐÌØÊâÒâÒåµÄĿ¼¡£
1.Bin£ºÕâ¸öĿ¼°üº¬ÁËËùÓеÄÔ¤±àÒëµÄASP.NETµÄWebÓ¦ÓóÌÐòʹÓõÄ.Net³ÌÐò¼¯£¨Í¨³£ÊÇDLLs£©£¬ÕâЩ³ÌÐò¼¯Ò²°üÀ¨Ô¤±àÒëµÄÍøÒ³À࣬ÒÔ¼°±»ÕâЩÀàËùÒýÓÃµÄÆäËûµÄ³ÌÐò¼¯¡£
&nb ......
²âÊÔ»·¾³£ºwindows server 2003+visual studio 2008
''' <summary>
''' »ñÈ¡ExcelÎļþËùÓй¤×÷±íµÄÃû³Æ
''' </summary>
''' <param name="iSubPath">ExcelÎļþ·¾¶£¬È磺D:\test.xls</param>
  ......
1.ʲôÊǸöÐÔ»¯·þÎñ ¸öÐÔ»¯·þÎñÊÇÒ»ÖÖ¼¼Êõ¿ò¼Ü£¬ÎªÓû§ÌṩÁË×Ô¶¨ÒåÕ¾µãÍâ¹Û¡¢ÄÚÈÝ¡¢²¼¾Ö¡¢½ÇÉ«¹ÜÀíµÈ¹¦ÄÜ£¬ÈçͬQQ¿Õ¼äµÈ¡£ 2.¸öÐÔ»¯·þÎñÐèÒª³ÌÐòԱѧϰÄÄЩ·½Ã棬²ÅÄÜʵÏÖÕâЩ¹¦ÄÜ ¸öÐÔ»¯·þÎñÊÇÒ»¸ö¿ò¼Ü£¬Õâ¸ö¿ò¼Ü°üº¬3¸öºËÐŦÄÜ£º¸öÐÔ»¯Óû§ÅäÖá¢web²¿¼þ¡¢³ÉÔ±×ʸñÓë½ÇÉ«¹ÜÀí¡£ÎÒÃǾÍÊÇÒª×ÅÖØÑ§Ï°Õâ3¸ö¹¦ÄÜ¡ ......
ÎÊÌâÃèÊö:
Êý¾Ý¿âA±íÖУº
ID Name
1 СÃ÷
2 Сǿ
3 СÕÅ
4 СÀî
5 С¹Ø
...
·Ö±ðÓÐLabel1,Label2... Label5 Îå¸ö±êÇ©£¬ÔõôÈÃÕâÎå¸ö±êÇ©Text°ó¶¨ÏÔʾA±íNameÁеÄǰ5¸ö£¬¾ÍÊÇ˵Label1ÏÔʾСÃ÷£¬Label2ÏÔʾСǿ...
......
ÓÉÓÚ¾³£ÒªÐ´Ò»Ð©²É¼¯µÄ³ÌÐò£¬ÏÂÃæµÄÈý¸öº¯ÊýÊDzɼ¯Öеĺܳ£Óõĺ¯Êý¡£¹ÃÇҽвɼ¯ÏµÍ³ÍòÄÜÕýÔò±í´ïʽ°É¡£
µÚÒ»¸ö£º//»ñÈ¡Ò³ÃæµÄhtmlÔ´Âë
public string GetHtmlSource(string Url, string charset)
{
& ......