Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

ASP.NETÖн«Êý¾ÝÊä³öµ½Excel

ÔÚ¿ª·¢ISOÎļþ¹ÜÀíϵͳµÄʱºò£¬Ôø¾­Óöµ½¹ýÒª½«ASPXÖ±½ÓÊä³öµ½EXCELµÄÐèÇó£¬ÏÖ½«¾­ÑéËùµÃÓë´ó¼Ò·ÖÏí¡£ Æäʵ£¬ÀûÓÃASP.NETÊä³öÖ¸¶¨ÄÚÈݵÄWORD¡¢EXCEL¡¢TXT¡¢HTMµÈÀàÐ͵ÄÎĵµºÜÈÝÒ׵ġ£Ö÷Òª·ÖΪÈý²½À´Íê³É¡£
¡¡¡¡Ò»¡¢¶¨ÒåÎĵµÀàÐÍ¡¢×Ö·û±àÂë
Response.Clear(); 
Response.Buffer= true; 
Response.Charset="utf-8";
//ÏÂÃæÕâÐкÜÖØÒª£¬ attachment ²ÎÊý±íʾ×÷Ϊ¸½¼þÏÂÔØ£¬Äú¿ÉÒԸijɠ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 ¹Ø¼ü×ָijɠme ¡£


Ïà¹ØÎĵµ£º

ASP.NetÓ¦ÓóÌÐòµÄĿ¼½á¹¹

   ÿ¸öWebÓ¦ÓóÌÐò¶¼Òª¹æ»®×Ô¼ºµÄĿ¼½á¹¹£¬³ýÁË×Ô¼ºÉè¼ÆµÄĿ¼½á¹¹ÒâÍ⣬ASP.NetÒ²¶¨ÒåһЩÓÐÌØÊâÒâÒåµÄĿ¼¡£
   1.Bin£ºÕâ¸öĿ¼°üº¬ÁËËùÓеÄÔ¤±àÒëµÄASP.NETµÄWebÓ¦ÓóÌÐòʹÓõÄ.Net³ÌÐò¼¯£¨Í¨³£ÊÇDLLs£©£¬ÕâЩ³ÌÐò¼¯Ò²°üÀ¨Ô¤±àÒëµÄÍøÒ³À࣬ÒÔ¼°±»ÕâЩÀàËùÒýÓÃµÄÆäËûµÄ³ÌÐò¼¯¡£
  &nb ......

ASP.NETÈçºÎ¶ÁÈ¡ExcelÎļþµÄ¶àÕŹ¤×÷±í

²âÊÔ»·¾³£ºwindows server 2003+visual studio 2008
    ''' <summary>
    ''' »ñÈ¡ExcelÎļþËùÓй¤×÷±íµÄÃû³Æ
    ''' </summary>
    ''' <param name="iSubPath">ExcelÎļþ·¾¶£¬È磺D:\test.xls</param>
    ......

Asp.net¸öÐÔ»¯·þÎñ¡¶ÏµÁÐ01¡·

  1.ʲôÊǸöÐÔ»¯·þÎñ ¸öÐÔ»¯·þÎñÊÇÒ»ÖÖ¼¼Êõ¿ò¼Ü£¬ÎªÓû§ÌṩÁË×Ô¶¨ÒåÕ¾µãÍâ¹Û¡¢ÄÚÈÝ¡¢²¼¾Ö¡¢½ÇÉ«¹ÜÀíµÈ¹¦ÄÜ£¬ÈçͬQQ¿Õ¼äµÈ¡£ 2.¸öÐÔ»¯·þÎñÐèÒª³ÌÐòԱѧϰÄÄЩ·½Ã棬²ÅÄÜʵÏÖÕâЩ¹¦ÄÜ ¸öÐÔ»¯·þÎñÊÇÒ»¸ö¿ò¼Ü£¬Õâ¸ö¿ò¼Ü°üº¬3¸öºËÐŦÄÜ£º¸öÐÔ»¯Óû§ÅäÖá¢web²¿¼þ¡¢³ÉÔ±×ʸñÓë½ÇÉ«¹ÜÀí¡£ÎÒÃǾÍÊÇÒª×ÅÖØÑ§Ï°Õâ3¸ö¹¦ÄÜ¡ ......

asp.net 2.0 ÔõÑù¶Ôlabel½øÐаó¶¨

ÎÊÌâÃèÊö:
Êý¾Ý¿âA±íÖУº
ID    Name
1    СÃ÷
2    Сǿ
3    СÕÅ
4    СÀî
5    С¹Ø
...
·Ö±ðÓÐLabel1,Label2... Label5 Îå¸ö±êÇ©£¬ÔõôÈÃÕâÎå¸ö±êÇ©Text°ó¶¨ÏÔʾA±íNameÁеÄǰ5¸ö£¬¾ÍÊÇ˵Label1ÏÔʾСÃ÷£¬Label2ÏÔʾСǿ... 
......

ASP.NET²É¼¯ÏµÍ³ÍòÄÜÕýÔò±í´ïʽ

ÓÉÓÚ¾­³£ÒªÐ´Ò»Ð©²É¼¯µÄ³ÌÐò£¬ÏÂÃæµÄÈý¸öº¯ÊýÊDzɼ¯Öеĺܳ£Óõĺ¯Êý¡£¹ÃÇҽвɼ¯ÏµÍ³ÍòÄÜÕýÔò±í´ïʽ°É¡£
µÚÒ»¸ö£º//»ñÈ¡Ò³ÃæµÄhtmlÔ´Âë
 public  string GetHtmlSource(string Url, string charset)
        {
    & ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ