为什么我用C#操作Excel第一次打开的Excel老是释放不了。以后的都可以释放掉.帮忙看一下这段程序有什么问题!
private bool SaveDisposeExcel(Excel.ApplicationClass ExcelTempObject)
{
bool ReturnValue=false;
try
{
ExcelTempObject.ActiveWorkbook.Save();
}
catch(System.Exception ex)
{
ExcelTempObject.ActiveWorkbook.Saved=false;
ReturnValue=false;
_ErrorMessageString=ex.Message;
}
ExcelTempObject.ActiveWorkbook.Saved=true;
ExcelTempObject.ActiveWorkbook.Close(false,null,null);
ExcelTempObject.UserControl=false;
ExcelTempObject.Quit();
ExcelTempObject=null;
System.GC.Collect();
ReturnValue=true;
return ReturnValue;
}
private bool SaveDisposeExcel(Excel.ApplicationClass ExcelTempObject)
{
bool ReturnValue=false;
try
{
ExcelTempObject.ActiveWorkbook.Save();
}
catch(System.Exception ex)
{
ExcelTempObject.ActiveWorkbook.Saved=false;
ReturnValue=false;
_ErrorMessageString=ex.Message;
}
ExcelTempObject.ActiveWorkbook.Saved=true;
ExcelTempObject.ActiveWorkbook.Close(false,null,null);
ExcelTempObject.UserControl=false;
ExcelTempObject.Quit();
ExcelTempObject=null;
System.GC.Collect();
ReturnValue=true;
return ReturnValue;
}
private bool SaveDisposeExcel(Excel.ApplicationClass ExcelTempObject)
{
bool ReturnValue=false;
try
{
ExcelTempObject.ActiveWorkbook.Save();
ExcelTempObject.ActiveWorkbook.Saved=true;
ExcelTempObject.ActiveWorkbook.Close(false,null,null);
ExcelTempObject.UserControl=false;
ExcelTempObject.Quit();
ExcelTempObject=null;
System.GC.Collect();
ReturnValue=true; }
catch(System.Exception ex)
{
ExcelTempObject.ActiveWorkbook.Saved=false;
ReturnValue=false;
_ErrorMessageString=ex.Message;
}
finally
{
return ReturnValue;
}
}