C#调试时正常一运行就报错

lijianqiang2666 2010-05-14 08:36:00

写了一段倒出 Excel的代码同时把文件名修改成系统时间断点调试是调了n遍都正常一段一段的代码看也没问题可运行就顶多导出一次就报错了
错误《--------------------------------------------------》
************** 异常文本 **************
System.IO.IOException: 另一个进程正在使用此文件，因此该进程无法访问此文件。
在股份管理系统.Form5.button2_Click(Object sender, EventArgs e) 位置 H:\股份管理系统\股份管理系统\Form5.cs:行号 298
在 System.Windows.Forms.Control.OnClick(EventArgs e)
在 System.Windows.Forms.Button.OnClick(EventArgs e)
在 System.Windows.Forms.Button.OnMouseUp(MouseEventArgs mevent)
在 System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
在 System.Windows.Forms.Control.WndProc(Message& m)
在 System.Windows.Forms.ButtonBase.WndProc(Message& m)
在 System.Windows.Forms.Button.WndProc(Message& m)
在 System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
在 System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
在 System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
《-----------------------------------------------------------------------》
下面是代码

这是这是倒出Excel 没错改名的地方就错了

try
{
Class cl = new Class();
OfficeExcel oe = new OfficeExcel();
string path;
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
path = saveFileDialog1.FileName;
oe.AddExcel(path);
oe.OpenExcel(path);
oe.SetCells("1", "A", "卡号");
oe.SetCells("1", "B", "户号");
oe.SetCells("1", "C", "姓名");
oe.SetCells("1", "D", "性别");
oe.SetCells("1", "E", "生日");
oe.SetCells("1", "F", "政治面貌");
oe.SetCells("1", "G", "身份证号");
oe.SetCells("1", "H", "组别");
oe.SetCells("1", "I", "组别");
oe.SetCells("1", "J", "地址");
oe.SetCells("1", "K", "籍贯");
oe.SetCells("1", "L", "工作地址");
oe.SetCells("1", "M", "民族");
oe.SetCells("1", "N", "文化程度");
oe.SetCells("1", "O", "婚姻状态");
oe.SetCells("1", "P", "与户主关系");
oe.SetCells("1", "Q", "职业");
oe.SetCells("1", "R", "何时迁入");
oe.SetCells("1", "S", "人口股份");
oe.SetCells("1", "T", "工龄");
oe.SetCells("1", "U", "工龄股份");
oe.SetCells("1", "V", "总股份");
oe.SetCells("1", "W", "状态");
oe.SetCells("1", "X", "分红系数");
oe.SetCells("1", "Y", "分红金");

try
{
for (int i = 0; i <= ds.Tables["Allpeople"].Rows.Count - 1; i++)
{
int k = i + 2;

oe.SetCells(k.ToString(), "A", ds.Tables[0].Rows[i]["CradID"].ToString());
oe.SetCells(k.ToString(), "B", ds.Tables[0].Rows[i]["hukouid"].ToString());
oe.SetCells(k.ToString(), "C", ds.Tables[0].Rows[i]["Name"].ToString());
oe.SetCells(k.ToString(), "D", ds.Tables[0].Rows[i]["sex"].ToString());
oe.SetCells(k.ToString(), "E", ds.Tables[0].Rows[i]["Birthday"].ToString());
oe.SetCells(k.ToString(), "F", ds.Tables[0].Rows[i]["zzmm"].ToString());
oe.SetCells(k.ToString(), "G", ds.Tables[0].Rows[i]["papersID"].ToString());
oe.SetCells(k.ToString(), "H", ds.Tables[0].Rows[i]["sort"].ToString());
oe.SetCells(k.ToString(), "I", ds.Tables[0].Rows[i]["sortA"].ToString());
oe.SetCells(k.ToString(), "J", ds.Tables[0].Rows[i]["Address"].ToString());
oe.SetCells(k.ToString(), "K", ds.Tables[0].Rows[i]["jg"].ToString());
oe.SetCells(k.ToString(), "L", ds.Tables[0].Rows[i]["WorkAddress"].ToString());
oe.SetCells(k.ToString(), "M", ds.Tables[0].Rows[i]["Nation"].ToString());
oe.SetCells(k.ToString(), "N", ds.Tables[0].Rows[i]["whcd"].ToString());
oe.SetCells(k.ToString(), "O", ds.Tables[0].Rows[i]["hyzk"].ToString());
oe.SetCells(k.ToString(), "P", ds.Tables[0].Rows[i]["Relation"].ToString());
oe.SetCells(k.ToString(), "Q", ds.Tables[0].Rows[i]["Vocation"].ToString());
oe.SetCells(k.ToString(), "R", ds.Tables[0].Rows[i]["qianru"].ToString());
oe.SetCells(k.ToString(), "S", ds.Tables[0].Rows[i]["rsgf"].ToString());
oe.SetCells(k.ToString(), "T", ds.Tables[0].Rows[i]["gl"].ToString());
oe.SetCells(k.ToString(), "U", ds.Tables[0].Rows[i]["glgf"].ToString());
oe.SetCells(k.ToString(), "V", ds.Tables[0].Rows[i]["zgf"].ToString());
oe.SetCells(k.ToString(), "W", ds.Tables[0].Rows[i]["zhuangtai"].ToString());
oe.SetCells(k.ToString(), "X", ds.Tables[0].Rows[i]["xs"].ToString());
oe.SetCells(k.ToString(), "Y", ds.Tables[0].Rows[i]["fhj"].ToString());

}

}
catch (Exception ee)
{
throw ee;
}
finally
{
oe.SaveAs();
oe.CloseExcel();
OfficeExcel.CloseRun("EXCEL.EXE");
this.ReName(path);
// oe.outExcel();

}

}
}
catch (Exception ee)
{
//MessageBox.Show("倒出完成");
throw ee;
}
}

这是改名的代码

private void ReName(string path)
{
string filename = Directory.GetParent(path).ToString();
string extName = path.Substring(path.LastIndexOf("."));
FileInfo info = new FileInfo(path);
string time = DateTime.Now.ToString("yyyy/MM/dd/hh/mm/ss");
info.MoveTo(filename + "/" + time + extName);
File.Delete(path);
}

这是在别的类里杀掉进程的方法

[DllImport("User32.dll", CharSet = CharSet.Auto)]
public static extern int GetWindowThreadProcessId(IntPtr hwnd, out int ID);
public static void CloseRun(string CloseRunName)
{
//关闭某个指定的进程：
System.Diagnostics.Process[] process = System.Diagnostics.Process.GetProcessesByName(CloseRunName);
foreach (System.Diagnostics.Process p in process)
{
p.Kill();
}

}

public void CloseExcel()
{
IntPtr ptr = new IntPtr(excel.Hwnd);
int k = 0;
GetWindowThreadProcessId(ptr, out k);
System.Diagnostics.Process p = System.Diagnostics.Process.GetProcessById(k);
p.Kill();
}

...全文