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();
Ïà¹ØÎĵµ£º
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Ä¿Â¼Ï ......
ÎÒÃÇÔÚ.NET³ÌÐòµÄ¿ª·¢¹ý³ÌÖУ¬³£³£ÐèÒªºÍÓû§½øÐÐÐÅÏ¢½»»¥£¬±ÈÈçÖ´ÐÐijÏî²Ù×÷ÊÇ·ñ³É¹¦£¬“È·¶¨”»¹ÊǓȡÏû”£¬ÒÔ¼°Ñ¡Ôñ“È·¶¨”»ò“È¡Ïû”ºóÊÇ·ñÐèÒªÌø×ªµ½Ä³¸öÒ³ÃæµÈ£¬ÏÂÃæÊDZ¾È˶Գ£ÓöԻ°¿òʹÓõÄС½á£¬Ï£Íû¶Ô´ó¼ÒÓÐËù°ïÖú£¬Í¬Ê±Ò²»¶Ó´ó¼Ò²¹³ä¡£
  ......
<?xml version="1.0"?>
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<system.web>
<authorization>
< ......
Ò»£¬JS¶¯Ì¬´´½¨±íµ¥
var result = " <form method='post' action='../xiazai.aspx'><table width='100%' border='0' cellpadding='0' cellspacing='1' bgcolor='#BDB4A2'>"+
"&l ......
using System.Web;
/// <summary>
/// Javascript³£Ó÷½·¨
/// </summary>
public class JS
{
private static string ScriptStart = "<script type=\"text/javascript\">";
private static string ScriptEnd = "</script>";
&n ......