Excel进程无法在Windows Server Standard Service Pack 1中终止 [英] Excel process not able to kill in Windows Server Standard Service Pack 1
问题描述
下面是我用来打开Excel工作表并将其另存为CSV文件的方法.在Windows 7,Windows Server 2008 R2中,excel进程在处理完excel文件后会自动终止自身.在Windows Server 2008 Standard Service Pack1中,它继续创建大量Excel进程并显示消息"Microsoft Excel错误-没有足够的系统资源无法完全显示."
在任务管理器中几乎有200个Excel进程在那一刻没有被杀死,并且服务器被挂起./
下面是用于处理许多Excel文件的代码.
Hi ,
Below is the method I used to open Excel sheet and save it as CSV file. In Windows 7, Windows Server 2008 R2, the excel process/es is automatically killing itself after processing the excel file/s. In windows Server 2008 Standard Service Pack1, Its going on creating a lot of Excel processes and showing the message ''Microsoft Excel Error - Not enough system resources to display completely.''
Almost near to 200 Excel processes are at Task Manager without killing at that instant and server is hanged./
Below is the code is used to process lot of Excel files.
private static bool SaveExcelCVS(string fileName, string outFile)
{
bool success = false;
try
{
Excel.Application xApp = new Excel.Application();
Excel.Workbook xF1 = xApp.Workbooks.Open(fileName,
0, false, 5, "", "", false, Excel.XlPlatform.xlWindows, "",
true, false, 0, true, false, false);
xF1.SaveAs(outFile, Excel.XlFileFormat.xlCSV, "", "", false, false,
Excel.XlSaveAsAccessMode.xlNoChange, Excel.XlSaveConflictResolution.xlLocalSessionChanges,
false, false, false, false);
xF1.Close(false);
xF1 = null;
xApp.Quit();
xApp = null;
success = true;
}
catch
{
}
return success;
}
推荐答案
为什么不杀死该进程?
http://july-code.blogspot.com/2008/11/kill-excelexe-process-in-c-net.html [ http://social.msdn.microsoft.com /Forums/zh-CN/csharpgeneral/thread/8c89fd55-0571-444f-a3df-ce47839ed5aa/ [
Why don''t you kill the process?
http://july-code.blogspot.com/2008/11/kill-excelexe-process-in-c-net.html[^]
http://social.msdn.microsoft.com/Forums/en-US/csharpgeneral/thread/8c89fd55-0571-444f-a3df-ce47839ed5aa/[^]
尝试以下代码:
Try the following code :
private static bool SaveExcelCVS(string fileName, string outFile)
{
bool success = false;
Excel.Application xApp = new Excel.Application();
try
{
Excel.Workbook xF1 = xApp.Workbooks.Open(fileName,
0, false, 5, "", "", false, Excel.XlPlatform.xlWindows, "",
true, false, 0, true, false, false);
xF1.SaveAs(outFile, Excel.XlFileFormat.xlCSV, "", "", false, false,
Excel.XlSaveAsAccessMode.xlNoChange, Excel.XlSaveConflictResolution.xlLocalSessionChanges,
false, false, false, false);
xF1.Close(false);
xF1 = null;
success = true;
}
catch (Exception ex)
{
MessageBox.Show("" + ex);
}
finally
{
xApp.Quit();
xApp = null;
}
return success;
}
这篇关于Excel进程无法在Windows Server Standard Service Pack 1中终止的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!