html table C#·½·¨µ¼Èëµ½excelÖÐ
ÏÖÔÚÎÒÓÃhtmlÖÐµÄ <table>µÄrowspan·½·¨£¬Æ´³öÁËÒ»¸ö¶à²ã±íÍ·µÄtable£¬Êý¾Ý´ÓÊý¾Ý¿âÈ¡³öºóÏÔʾµ½Ò³ÃæÉÏ¡£
ÏÖÔÚÒª°ÑÕâ¸ötableµ¼³öµ½excelÖС££¬
Çó½â¾ö·½·¨¡£
PS£º¸Õ²ÅÉÏÍøÕÒÁËÏ£¬Ã»ÓÐÌ«ºÃµÄ½â´ð¡£Ï£Íû¸ßÊÖ¹âÁÙ£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡
È¡tableÖеÄÊý¾ÝÀ§ÄÑ£¿
C# code:
/// <summary>
/// µ¼³öEXCEL·½·¨
/// </summary>
/// <param name="page"></param>
/// <param name="fileName"></param>
/// <param name="html"></param>
protected void ExportDsToXls(Page page, string fileName, string html)
{
System.IO.StringWriter tw = new System.IO.StringWriter();
System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(tw);
Response.Clear();
Response.Charset = "gb2312";
Response.ContentType = "application/vnd.ms-excel";
Response.ContentEncoding = System.Text.Encoding.GetEncoding("gb2312");
Response.AppendHeader("Content-Disposition", "attachment;filename=" + System.Web.HttpUtility.UrlEncode(fileName) + ".xls");
Response.Write("<html><head><META http-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\"></head><body>");
Response.Write(ht
Ïà¹ØÎÊ´ð£º
ÔÚʹÓÃCSSÖеÄpadding-leftʱÓöµ½Ò»¸öÎÊÌâ¡£¾ÍÊDZ¾À´ÒѾÉèÖúõĿí¶È£¬padding-leftÒ»ÉèÖà ¶àÉÙºÃÏñ¾Í°ÑÕâ¸ö¼Ó¿íÁ˶àÉÙ¡£ºóÃæµÄDIV¾Í±äλÖÃÁË¡£ÓÐû½â¾ö°ì·¨Ñ½
ÇëÎÊÄãIE¼¸°¡£¿=£¬= ²»»áÓÐÕâÖÖÇé¿öÒ®
Èç¹ûÊÇIE6£¬Ä ......
form±íµ¥ÏÂÀ¿òµÄÀ¶É«ÔõôȥµôÄØ£¬ÎÒÏë°ÑÏÂÀ¿òµÄÑÕÉ«ÉèΪ͸Ã÷µÄ
may be no way.
ÏñQQ¿Õ¼äÀïµÄÄÇЩ͸Ã÷µÄÏÂÀ¿òÊÇÔõôŪµÃÄØ£¿
ÒýÓÃ
ÏñQQ¿Õ¼äÀïµÄÄÇЩ͸Ã÷µÄÏÂÀ¿òÊÇÔõôŪµÃÄØ£¿
ÓòãÄ£ÄâµÄ°É
»ù±¾¶¼ ......
21cnµÄÓÊÏ䣬ÔÚoutlookÅäÖúó¿ÉÒÔÕý³£ÊÕ·¢Óʼþ£¬¿ÉÊÇÎÒдÔÚC#ÖоͲ»ÐУ¬»»³ÉÆäËüÓÊÏ䣬163ºÜÔç×¢²áµÄ¡£¿ÉÒÔ·¢ËÍ¡£²éÁ˺ܾã¬Ã»ÓÐÕÒµ½ÔÒò£¬Çë¸ßÊÖ°ïæ½â´ð¡£¡£¡£Ð¡µÜ£¬Ð»ÁË¡£¡£´úÂëÈçÏ£º
private void SendMail ......
ÎÒÃÇC#×öÒ»¸ö´°Ìå ÍùÊý¾Ý¿âÀï²åÈëÊý¾Ý
SqlConnection cn = new SqlConnection("Data Source=20090713-1752\\SQLEXPRESS;Initial Catalog=goods;Integrated Security=True");
......
ÄÄλ¸ßÊÖÄܰïÎÒ½â¾öÕâ¸öÎÊÌ⣺
ÓÐûÓÐcssʵÏÖ±íµ¥µÄÏÂÀ¿ò¼ýÍ·ÓÃͼƬ´úÌæ£¿²»ÓÃjs
ÎÒʹÓÃÁËjsºó£¬ÔÊÐí¿Ø¼þÔËÐÐǰģ¿é±äÐΣ¬ÔÊÐíºó²ÅÕý³£ÏÔʾ£¬ËùÒÔÎÒÏëÔËÓÃcssÀ´ÊµÏÖ¡£
лл£¬ÔÚÏߵȡ£
ºÃÏñ¶¼ÊÇÓÃJS¡£¡£À´ÊµÏÖ± ......