C#我打开excel表，然后用微软自带库读取excel表格到datagridview后，此时excel表无法编辑，好像处于锁定状态，无法关闭，只有关了程序才能进行编辑，如何用代码解决

Question

我读取表格用的是微软自带库，如何解决
读取完excel表格内容后，用的是
private Excel.Application excel1;
private Excel.Workbooks wbs = null;
private Excel.Workbook wb = null;
private Excel.Sheets wss;
private Excel.Worksheet ws = null;
private Excel.Range range1 = null;
excel1.Quit();

Answer 1

[DllImport("User32.dll")] 
public static extern int GetWindowThreadProcessId(IntPtr hWnd, out int ProcessId);   
public static void KillExcelApp(this excel.Application app) {
    app.Quit();
    IntPtr intptr = new IntPtr(app.Hwnd);
    int id;
    GetWindowThreadProcessId(intptr, out id);
    var p = Process.GetProcessById(id);
    if (p != null)
    p.Kill();
}