本文介绍了关闭excel interop proecss的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
我有这个代码插入和退出表格：
I have this code to insert into and excel sheet :
try
{
Excel.Application xlApp;
Excel.Workbook xlWorkBook;
Excel.Worksheet xlWorkSheet;
object misValue = System.Reflection.Missing.Value;
TextReader readClientNumber = new System.IO.StringReader(txtRandClientNumbers.Text);
TextReader readCardNumber = new System.IO.StringReader(txtRandCardNumbers.Text);
TextReader readClientCurrency = new System.IO.StringReader(txtClientCurrency.Text);
Random rand = new Random();
int num = rand.Next(0, 99999);
int rows = 0;
if (this.TestCases > 0)
{
rows = this.TestCases;
}
else if (this.TestCases <= 0)
{
rows = txtRandCardNumbers.Lines.Count() - 1;
}
string[] textClientNumber = new string[0];
string[] textCardNumber = new string[0];
string[] textClientCurrency = new string[0];
if (this.TestCases > 0)
{
textCardNumber = new string[rows];
textClientCurrency = new string[rows];
textClientNumber = new string[rows];
}
else
{
int rowsofCards = txtRandCardNumbers.Lines.Count();
textCardNumber = new string[rows];
int rowsOfClient = txtRandClientNumbers.Lines.Count();
textClientNumber = new string[rowsOfClient];
textClientCurrency = new string[rowsOfClient];
}
string[] textRetreivalRef = new string[rows];
string[] textOrigPayment = new string[rows];
xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Open("C:\\temp\\" + this.Excelfilename + ".xls", 0, false, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
Excel.Range last = xlWorkSheet.Cells.SpecialCells(Excel.XlCellType.xlCellTypeLastCell, Type.Missing);
Excel.Range range = xlWorkSheet.get_Range("A1", last);
int lastUsedRow = last.Row;
int lastUsedColumn = last.Column;
var firstLetterCharacters = this.Excelfilename.TakeWhile(Char.IsLetter);
string filename = new string(firstLetterCharacters.ToArray());
xlWorkSheet.Cells.NumberFormat = "@";
if (this.Institution_number == "00000002" && (this.Service_id == 102 || this.Service_id == 201 || this.Service_id == 406 || this.Service_id == 408))
{
try
{
for (int row = 1; row == 1; row++)
{
cardTypeInsert = row + 1;
origpaymentrefInsert = row + 2;
retreivalrefInsert = row + 3;
cdIndicatorInsert = row + 4;
institutionNumberInsert = row + 5;
refundInsert = row + 6;
cardNumberInsert = row + 7;
captureMethodInsert = row + 8;
eciIndicatorInsert = row + 9;
clientNumberInsert = row + 10;
processoridInsert = row + 11;
currencyInsert = row + 12;
amountInsert = row + 13;
for (int col = 0; col < rows; col++)
{
lastUsedRow = lastUsedRow + 1;
textClientNumber[col] = readClientNumber.ReadLine();
textCardNumber[col] = readCardNumber.ReadLine();
textClientCurrency[col] = readClientCurrency.ReadLine();
if (this.Service_id == 406 && this.Service_contract == "Acq Balance Based")
{
xlWorkSheet.Cells[lastUsedRow, processoridInsert] = "350";
}
else if (this.Service_id == 408 && this.Service_contract == "Acq Matching Based")
{
xlWorkSheet.Cells[lastUsedRow, processoridInsert] = "360";
}
else if ((this.Service_id == 201 || this.Service_id == 102) && this.Service_contract == "Acq Matching Based")
{
xlWorkSheet.Cells[lastUsedRow, processoridInsert] = "317";
}
else
{
xlWorkSheet.Cells[lastUsedRow, processoridInsert] = this.processor_ref;
}
xlWorkSheet.Cells[lastUsedRow, row] = DateTime.Now.ToString("yyyyMMdd");
xlWorkSheet.Cells[lastUsedRow, cardTypeInsert] = this.Card_type;
xlWorkSheet.Cells[lastUsedRow, origpaymentrefInsert] = " ";
xlWorkSheet.Cells[lastUsedRow, retreivalrefInsert] = " ";
xlWorkSheet.Cells[lastUsedRow, cdIndicatorInsert] = this.Cdindicator;
xlWorkSheet.Cells[lastUsedRow, institutionNumberInsert] = "";
xlWorkSheet.Cells[lastUsedRow, refundInsert] = " ";
string cardnumberstring = opClass.CardNumberToExport(textCardNumber[col].ToString());
xlWorkSheet.Cells[lastUsedRow, cardNumberInsert] = cardnumberstring;
xlWorkSheet.Cells[lastUsedRow, captureMethodInsert] = cmbCaptureMethod.SelectedValue.ToString();
xlWorkSheet.Cells[lastUsedRow, eciIndicatorInsert] = " ";
xlWorkSheet.Cells[lastUsedRow, clientNumberInsert] = "\'" + textClientNumber[col].ToString();
int randnum1 = rand.Next(1, 999999);
string randnumstring = opClass.AmountToExport(randnum1);
xlWorkSheet.Cells[lastUsedRow, amountInsert] = randnumstring;
if ( this.Service_id == 406 || this.Service_contract == "Acq Matching Based")
{
xlWorkSheet.Cells[lastUsedRow, currencyInsert] = cmbCurrency.SelectedValue.ToString();
}
else
{
xlWorkSheet.Cells[lastUsedRow, currencyInsert] = textClientCurrency[col].ToString();
}
}
}
xlApp.DisplayAlerts = false;
if (File.Exists("C:\\temp\\" + this.Excelfilename + ".xls"))
{
File.Delete(this.Excelfilename);
xlWorkBook.SaveAs("C:\\temp\\" + this.Excelfilename + ".xls", Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
}
xlWorkBook.Close();
xlApp.Quit();
Marshal.ReleaseComObject(xlWorkSheet);
Marshal.ReleaseComObject(xlWorkBook);
Marshal.ReleaseComObject(xlApp);
MessageBox.Show("Excel file updated , you can find the file in C:\\temp\\" + this.Excelfilename + ".xls");
}
catch (Exception ex)
{
MessageBox.Show(ex.ToString());
}
}
我的尝试：
i不知道为什么marshal.release ....无法正常工作，我使用的解决方法是使用以下代码终止进程：
What I have tried:
i do not know why marshal.release.... is not working, the workaround i am using is to kill processes with the following code:
foreach (Process clsProcess in Process.GetProcesses())
{
if (clsProcess.ProcessName.Equals("EXCEL"))
{
clsProcess.Kill();
break;
}
}
但如果你有一个excel打开，你不想关闭它将被关闭，因为我杀死所有名为excel的进程。
可以告诉我我怎么能从它完成后杀死一个进程。
but if you have an excel open that you do not want to close it will be closed , because i am killink all the processes with the name of excel.
Can somone tell me how i can kill a process when it is finished from it.
推荐答案
这篇关于关闭excel interop proecss的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！