Asp.net Öе¼³öexcelºóÖÕÖ¹½ø³ÌµÄ½â¾ö°ì·¨
ÔÚasp.netÀïʹÓÃcom×é¼þµ¼³öexcelºó×ÜÊÇ»áÓÐÒ»¸öEXCEL.EXE½ø³Ì´æÔÚ£¬Õ¼¾Ý×Å30¶àMµÄÄڴ棬Ñо¿Á˺þÃÊÔÁËÍøÉϵĺܶà°ì·¨¶¼Ã»Óнâ¾ö¡£½ñÌìÐÄÇé±È½Ï·ÅËÉ£¬½Ó×Å´ÓÍøÉÏËÑÁËһϣ¬¿´µ½Ò»ÆªÌû×ÓÈçÏ£º
ÔÚDOT NETÖе÷ÓÃExcelºó£¬Excel½ø³ÌµÄ²¢Î´ÖÕÖ¹ÎÊÌâµÄ½â¾ö°ì·¨ ÊÕ²Ø
ÔÚDOT NETÖе÷ÓÃExcelºó£¬Excel½ø³ÌµÄ²¢Î´ÖÕÖ¹ÎÊÌâ
Excel.Application myExcel = new Excel.Application() ;
...
myExcel.Quit();
ÍøÉϵĽâ¾ö°ì·¨´ó¶àÊÇ˵ÔÚmyExcel.Quit()ºóÇ¿ÖÆ½øÐÐÀ¬»ø»ØÊÕ
GC.Collect();
µ«ÊǶ¼²»ÐУ¬»¹ÓÐÈË˵ҪÊͷŶԸÃCom¶ÔÏó£¨myExcel£©µÄÒýÓÃ
for(int i =1;i>0;i= System.Runtime.InteropServices.Marshal.ReleaseComObject(myExcel))
{
}
»¹ÓÐÈË˵°ÑmyExcel ´´½¨Îª¾Ö²¿±äÁ¿£¬·½·¨½áÊøºóÀ¬»ø»ØÊÕÆ÷»áÇåÀíËü£¬ºÃÏñÒ²²»ÐУ¨¼´Ê¹ÔÚÕâ¸ö·½·¨×îºóÇ¿ÖÆÀ¬»ø»ØÊÕÆ÷ÊÕ¼¯À¬»øÒ²²»ÐУ©¡£
À¬»ø»ØÊÕÆ÷ËÆºõûÓй¤×÷£¬ËƺõºÍÀ¬»ø»ØÊյIJßÂÔÓйأ¬Î¢ÈíµÄÕâ¸öDot NetÇå½à¹¤²»ÇåÀí×Ô¼ºËùÔڵصÄÀ¬»ø! GC.Collect()²»ÇåÀí×Ô¼ºËùÔÚ×÷ÓÃÓòµÄÀ¬»ø£¬ÔÚµ÷ÓÃExcelµÄ·½·¨Ö®Íâµ÷ÓÃGC.Collect() ¾ÍºÃÁË£¬½ø³ÌÁбíÖÐExcelµÄ½ø³ÌÔÚGC.Collect() ºó¾ÍÏûʧÁË¡£
void DoSomething()
{
...
HandleExcel();
GC.Collect() ;
}
void HandleExcel()
{
Excel.Application myExcel = new Excel.Application() ;
...
myExcel.Quit();
}
Õâ¸ö·½·¨ÔÚwinform³ÌÐòÖÐÓÐЧ£¬µ«ÊǶÔÓÚÔÚasp.netÖл¹ÊDz»ÐУ¨ºÃÏñÊÇ΢ÈíµÄÎÊÌ⣩¡£
±¾ÎÄÀ´×ÔCSDN²©¿Í£¬×ªÔØÇë±êÃ÷³ö´¦£ºhttp://blog.csdn.net/sunyou/archive/2005/08/22/461133.aspx
°´ÕÕËù˵µÄ·½·¨ÊÔÊÔ£º
Ê×ÏÈʵÑ飺
protected void Export_Click(object sender, EventArgs e)
{
Excel.Application myExcel = new Excel.Application() ;
...
myExcel.Quit();
GCCollect();
}
public void GCCollect()
{
GC.Collect();
}
ÕâÑù×öµ¼³öexcelºó½ø³Ì»¹´æÔÚ¡£
½Ó×ÅÊÔ
protected void Export_Click(object sender, EventArgs e)
{
ExportExcel();
Ïà¹ØÎĵµ£º
//postÇëÇó
string name = Request["name"].toString();
string name =Request.Form.Get("name").toString();
//getÇëÇó
string name = Request.QueryString["name"].toString();
µ«ÎÒ·¢ÏÖ ÎÞÂÛÊÇ·ñÊÇpostÓëget´«Öµ
¶¼¿ÉÓÃstring name = Request["name"].toString();
±íµ¥Ìá½»ÖÐgetºÍpost·½Ê½µ ......
1>>δÄܼÓÔØÎļþ»ò³ÌÐò¼¯“System.Web.Mvc, Version=1.0.0.0, Culture=neutral, PublicKeyToken=31BF3856AD364E35”»òËüµÄijһ¸öÒÀÀµÏϵͳÕÒ²»µ½Ö¸¶¨µÄÎļþ¡£
½â¾ö£ºµ½C:\Program Files\Microsoft ASP.NET\ASP.NET MVC 1.0\Assemblies ÏÂÕÒµ½ System.Web.Mvc.dll Îļþ ¸´ÖƵ½ÏîÄ¿µÄbinÄ¿Â¼Ï ......
Ò».ºǫ́µ÷ÓÃǰ̨
1.Page.ClientScript.RegisterStartupScript(type,"",script);
Àý:
string script = string.Format("<script>alert('Wrong');</script>");
Page.ClientScript.RegisterStartupScript(GetType(), "Load", script);
2.¶ÔÏó.Attributes.Add("ʼþ","script")
Àý:
e.Row.Attributes.Add("on ......
ÔÚ×î½ü¿ªÊ¼½«AJAX¼¼Êõ¼ÓÈëµ½ÈÕ³£µÄ¿ª·¢¹¤×÷ÖС£ÎÒÔÚ×î½üдÁ˸öAJAXµÄÎÞˢеǽÇÒ¶¯Ì¬Ìí¼Ó·þÎñÆ÷¿Ø¼þµÄ¹¤×÷£¬ÎÒ½«´Ë¹¦ÄܸæËß´ó¼ÒÏ£Íû¶Ô´ó¼ÒµÄ¹¤×÷ÓÐËù°ïÖú¡£Èç¹û´ó¼ÒÓиüºÃµÄ·½·¨ÇÒÔ¸ÒâÔÚ´ËÁôÑÔÈÃÎÒÒ²¿ÉÒÔ·ÖÏíµ½ÄãµÄ³É¹û¡£
Ê×ÏÈÔÚÒ³ÃæÖеÄHTML±ê¼ÇÖмÓÈë¿Ø¼þUpdatePanelºÍÁ½¸öTextboxÒ»¸öButton£º
<asp:UpdatePanel ID ......