asp.netµ¼³öexcelµÄÎÊÌâ
VB.NET code:
private void ToExcel(Control ctl, string FileName)
{
HttpContext.Current.Response.Charset = "UTF-8";
HttpContext.Current.Response.ContentEncoding = System.Text.Encoding.UTF8;
HttpContext.Current.Response.ContentType = "application/ms-excel";
HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + "" + FileName);
ctl.Page.EnableViewState = false;
System.IO.StringWriter tw = new System.IO.StringWriter();
HtmlTextWriter hw = new HtmlTextWriter(tw);
ctl.RenderControl(hw);
HttpContext.Current.Response.Write(tw.ToString());
HttpContext.Current.Response.End();
}
µ¼³öΪÒÔÉÏ´úÂ룬һ°ãʹÓÃÒ²Õý³££¬µ«·¢ÏÖÓÐʱ»á³öÏÖÂÒÂ룬×òÌìÒ»¸ö¸ö²âÊÔ·¢ÏÖµ¼³öÕâ¸öÈËʱ£¬ÓÐÂÒÂ룬²é¿´.xls´úÂëÈçÏÂÈ¥µô¡°¸¦¡±×ÖÒ»ÇÐÏÔʾÕý³£
Çó½â¾ö°ì·¨£¬»òÓÐÆäËûÄܽâ¾öÂÒÂëµÄµ¼³ö·½·¨¡£
HTML code:
<table cellspacing="0" rules="all" bordercolor="Gainsboro" border="1" id="DataGrid1" style="border-color:Gainsboro;border-width:1px;border-style:solid;font-siz
Ïà¹ØÎÊ´ð£º
dsQuyMst.Tables["QuyMst"].Rows[0]["SHDOCO"] = "1111";//Õâ¾ä±¨´í£¨Î´½«¶ÔÏóÒýÓÃÉèÖõ½¶ÔÏóµÄʵÀý¡££©
ÕâÖªµÀÊÇʲôÔÒò£¿
¸ßÈËÖ¸µã~~~
using System;
using System.Data;
us ......
Êý¾Ý¿â±íÖÐÓÐÒ»ÁУ¨TranXml£©ÀàÐÍÊÇxml£¬´æ´¢µÄÊÇÀàËÆ
<fathernode>
<a>aaa
</a>
<b>bbb
</b>
</fathernode>
µÄÐÅÏ¢£¬²¢ÇÒͨ¹ý²éѯ·½· ......
±¾ÈËÒ»Ö±´ÓÊÂjavaµÄ¿ª·¢£¬ spring , strutsµÈµÈ£¬ ÏÖÔÚÂíÉÏÒª½ÓÒ»¸öasp.netµÄÏîÄ¿£¬ ²»ÖªµÀasp.netÖÐÓÐûÓкÍjavaÖеÄstrutsÀàËÆµÄ¶«Î÷£¬ ¿ÉÒÔÔÚËûµÄ»ù´¡ÉÏ£¬Ö±½Ó¿ª·¢£¬ ЧÂʸߣ¬ ¶øÇÒºÃά»¤ ¡£¡£ лл£¬Ï£Íû´ó¼Ò£¬¶ ......
СµÜÊǽñÄê¸Õ±ÏҵѧÉúÕÒÁ˺ܳ¤Ê±¼ä¹¤×÷ÁË,×ÜÊÇʧ°Ü£¬Ò»Ð©¹«Ë¾¶¼ÒªÓй¤×÷¾ÑéµÄ£¬¶¼±ÀÀ£ÁË£¬ËùÒÔÏëÇë¸÷λ´ó¸ç°ï¸öæ
½ñÌìÎÒÈ¥ÃæÊÔÁËÒ»¼Ò¹«Ë¾£¬ËûÊÇÏë×öÒ»¸ö¡°Ò½ÁƵÄÍøÕ¾¡±Ï൱ÓÚÊÇÍÆ¹ã×Ô¼ºµÄÒ½ÁÆ·½·¨°É£¬Ëû½ÐÎ ......
ÓÐÒ»¸ö±í channel
ID fatherID Name
1 0 a
2 0 b
3 2 bb
4 3 bbb
.
.
.
ʵÏÖÑ¡Ôñ¸ùĿ¼ Èç2 ÅжÏÊÇ·ñÓÐ×ÓĿ¼ ÈôÓÐÔòÉú³Édrop ......