asp.netÖе¼³öExeclµÄ·½·¨
Ò»¡¢asp.netÖе¼³öExeclµÄ·½·¨£º ÔÚ asp.netÖе¼³öExeclÓÐÁ½ÖÖ·½·¨£¬Ò»ÖÖÊǽ«µ¼³öµÄÎļþ´æ·ÅÔÚ·þÎñÆ÷ij¸öÎļþ¼ÐÏÂÃæ£¬È»ºó½«ÎļþµØÖ· Êä³öÔÚä¯ÀÀÆ÷ÉÏ£»Ò»ÖÖÊǽ«ÎļþÖ±½Ó½«ÎļþÊä³öÁ÷д¸øä¯ÀÀÆ÷¡£ÔÚResponseÊä³öʱ£¬\t·Ö¸ôµÄÊý¾Ý£¬µ¼³ö execlʱ£¬µÈ¼ÛÓÚ·ÖÁУ¬\nµÈ¼ÛÓÚ»»
Ò»¡¢asp.netÖе¼³öExeclµÄ·½·¨£º
ÔÚ asp.netÖе¼³öExeclÓÐÁ½ÖÖ·½·¨£¬Ò»ÖÖÊǽ«µ¼³öµÄÎļþ´æ·ÅÔÚ·þÎñÆ÷ij¸öÎļþ¼ÐÏÂÃæ£¬È»ºó½«ÎļþµØÖ·
Êä³öÔÚä¯ÀÀÆ÷ÉÏ£»Ò»ÖÖÊǽ«ÎļþÖ±½Ó½«ÎļþÊä³öÁ÷д¸øä¯ÀÀÆ÷¡£ÔÚResponseÊä³öʱ£¬\t·Ö¸ôµÄÊý¾Ý£¬µ¼³ö
execlʱ£¬µÈ¼ÛÓÚ·ÖÁУ¬\nµÈ¼ÛÓÚ»»ÐС£
1¡¢½«Õû¸öhtmlÈ«²¿Êä³öexecl
´Ë·¨½«htmlÖÐËùÓеÄÄÚÈÝ£¬Èç°´Å¥£¬±í¸ñ£¬Í¼Æ¬µÈÈ«²¿Êä³öµ½ExeclÖС£
Response.Clear();
Response.Buffer= true;
Response.AppendHeader("Content-Disposition","attachment;filename="+DateTime.Now.ToString
("yyyyMMdd")+".xls");
Response.ContentEncoding=System.Text.Encoding.UTF8;
Response.ContentType = "application/vnd.ms-excel";
this.EnableViewState = false;
ÕâÀïÎÒÃÇÀûÓÃÁËContentTypeÊôÐÔ£¬ËüĬÈϵÄÊôÐÔΪtext/html£¬Õâʱ½«Êä³öΪ³¬Îı¾£¬¼´ÎÒÃdz£¼ûµÄÍøÒ³
¸ñʽµ½¿Í»§¶Ë£¬Èç¹û¸ÄΪ ms-excel½«½«Êä³öexcel¸ñʽ£¬Ò²¾ÍÊÇ˵ÒÔµç×Ó±í¸ñµÄ¸ñʽÊä³öµ½¿Í»§¶Ë£¬Õâʱä¯
ÀÀÆ÷½«ÌáʾÄãÏÂÔØ±£´æ¡£ContentTypeµÄÊôÐÔ»¹°üÀ¨£ºimage/JPEG;text/HTML;image/GIF;vnd.ms-
excel/msword ¡£Í¬Àí£¬ÎÒÃÇÒ²¿ÉÒÔÊä³ö(µ¼³ö)ͼƬ¡¢wordÎĵµµÈ¡£ÏÂÃæµÄ·½·¨£¬Ò²¾ùÓÃÁËÕâ¸öÊôÐÔ¡£
2¡¢½«DataGrid¿Ø¼þÖеÄÊý¾Ýµ¼³öExecl
ÉÏÊö·½·¨ËäȻʵÏÖÁ˵¼³öµÄ¹¦ÄÜ£¬µ«Í¬Ê±°Ñ°´Å¥¡¢·ÖÒ³¿òµÈhtmlÖеÄËùÓÐÊä³öÐÅÏ¢µ¼Á˽øÈ¥¡£¶øÎÒÃÇÒ»°ã
Òªµ¼³öµÄÊÇÊý¾Ý£¬DataGrid¿Ø¼þÉϵÄÊý¾Ý¡£
System.Web.UI.Control ctl=this.DataGrid1;
//DataGrid1 ÊÇÄãÔÚ´°ÌåÖÐÍϷŵĿؼþ
HttpContext.Current.Response.AppendHeader("Content-
Disposition","attachment;filename=Excel.xls");
HttpContext.Current.Response.Charset ="UTF-8";
HttpContext.Current.Response.ContentEncoding =System.Text.Encoding.De
Ïà¹ØÎĵµ£º
public static void SetEnterControl(System.Web.UI.Control Ctrl)
{
Page mPage = Ctrl.Page;
string mScript;
mScript = @"<script language=""jav ......
ÔÚasp.netÀïÔõô¸ú¾ÝÓû§È¨ÏÞÀ´Éú³ÉÊ÷Ðβ˵¥
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
......
Ò»¡¢Ð§¹û¼ò½é
¡¡¡¡µ±µã»÷Ò»¼¶À¸Ä¿Ê±£¨ÈçÊ×Ò³£©£¬±»µã»÷µÄÒ»¼¶À¸Ä¿µÄµ¥Ôª¸ñ±³¾°É«·¢Éú±äÉ«£¬Èç¹û¸ÃÒ»¼¶À¸Ä¿ÏÂÓжþ¼¶À¸Ä¿£¬Ôò»áÔÚÏÂÒ»ÐÐÏÔʾ³öÀ´£¬·ñÔò¶þ¼¶À¸Ä¿ÕâÒ»Ðв»»áÏÔʾÈκζ«Î÷£¬µ«»áÕ¼Ò»¶¨µÄ¸ß¶È¡£µ±µã»÷¶þ¼¶À¸Ä¿Ê±£¬ÆäËùÊôµÄÒ»¼¶À¸Ä¿µ¥Ôª¸ñ±³¾°É«·¢Éú±ä»¯£¬Í¬Ê±±»µã»÷µÄ¶þ¼¶À¸Ä¿Ãû³Æ»á¼Ó´Ö£¬²¢ÔÚǰ·½¼ÓÒ»¸ö“¡ ......
¸üУº2007 Äê 11 Ô ¿ÉÒÔÏñ¶Ô HTML ÔªËØÄÇÑù£¬ÒÔÉùÃ÷·½Ê½Ïò ASP.NET ÍøÒ³ÉϵĿؼþÌí¼Ó¿Í»§¶Ë½Å±¾¡£»òÕߣ¬Èç¹ûʼþ»ò´úÂëÒÀÀµ½öÔÚÔËÐÐʱ¿ÉÓõÄÐÅÏ¢£¬¿ÉÒÔͨ¹ý±à³Ì·½Ê½Ïò ASP.NET Web ·þÎñÆ÷¿Ø¼þÌí¼Ó¿Í»§¶Ë½Å±¾Ê¼þ¡£ ˵Ã÷£º ¿ÉÒÔÔÚ¿Í»§¶Ë½Å±¾ÖÐͨ¹ý ID ÒýÓÿؼþ¡£Óйظü¶àÐÅÏ¢£¬Çë²Î¼û ASP.NET ÍøÒ³ÖеĿͻ§¶Ë½Å±¾¡£ Ïò ......
ASP.NETĸ°åµÄÓ¦Óã¨×ª£©
2009Äê11ÔÂ30ÈÕ ÐÇÆÚÒ» ÏÂÎç 01:11
ĸ°æÒ³ÊÇVS2005ÖÐÐÂÒýÈëµÄÒ»¸ö¸ÅÄËüºÜºÃµØÊµÏÖ½çÃæÉè¼ÆµÄÄ£¿é»¯£¬²¢ÇÒʵÏÖʵÏÖÁË´úÂëµÄÖØÓá£Ëü¾ÍÏñ»éÉ´Ó°Â¥ÖеĻéÉ´Ä£°å£¬Í¬Ò»¸ö»éÉ´Ä£°å¿ÉÒÔ¸ø²»Í¬µÄÐÂÈËÓã¬Ö»Òª°ÑËûÃǵÄÕÕÆ¬ÌùÔÚÒÑÓеĻéÉ´Ä£°å¾Í¿ÉÒÔÐγÉÒ»ÕÅÆ¯ÁÁµÄ»éÉ´ÕÕÆ¬£¬ÕâÑù¿ÉÒÔ´ó´ó¼ò»¯»éÉ´ÒÕÊõÕ ......