C# WinForms自动化程序保存Excel时抛出0x800AC472错误求助

开发WinForms程序，功能为从SQL数据库读取数据并写入Excel，再将文件保存到指定路径。目前遇到以下问题：

• 调用Excel保存函数后出现系统错误0x800AC472
• 尝试在按钮点击方法中添加GC.Collect(); GC.WaitForPendingFinalizers();，但问题未解决，任务管理器中仍有MicrosoftOffice.exe进程残留
• 用try-catch包裹代码后，错误会输出到控制台，文件可正常保存，但进程依旧残留

按钮点击事件代码 #

else if (((DataGridView)sender).Columns[e.ColumnIndex].DataPropertyName == "Run")
{
    // return SQL into datatable
    var returnedDT = SQLAcess.SQLtoDataTable(dataGridView1[0, e.RowIndex].Value.ToString()!);

    //find item to open
    string loadstring = DataGridClass.CellColumn(dataGridView1, "Load_Location", e.RowIndex);

    //finds workbook to paste into.
    var SettingsDataset = XMLData.ReturnXMLDataset(2);       
    var workbookstring = XMLData.returnXMLcellwithcolumnname(SettingsDataset, "Data_Dump_Worksheet_name", e.RowIndex);

    //find location to save it
    string savestring = DataGridClass.CellColumn(dataGridView1, "Save_location", e.RowIndex);

    //execute export to excel, with the locations saved from above.
    GXOMIClassLibrary.My_DataTable_Extensions.ExportToExcelDetailed(returnedDT, loadstring, workbookstring, savestring);
    GC.Collect();
    GC.WaitForPendingFinalizers();
}

类库中ExportToExcelDetailed方法代码 #

public static void ExportToExcelDetailed(this System.Data.DataTable DataTable, string ExcelLoadPath, string WorksheetName, string ExcelSavePath)
{
    try
    {
      
        int ColumnsCount;

        //if datatable is empty throw an exception.
        if (DataTable == null || (ColumnsCount = DataTable.Columns.Count) == 0)
            throw new Exception("ExportToExcel: Null or empty input table!\n");

        // load excel, and create a new workbook
        //Microsoft.Office.Interop.Excel.Application Excel = new Microsoft.Office.Interop.Excel.Application();
        //Excel.Workbooks.Add();

        var excelApp = new Excel.Application();
        Excel.Workbook excelWorkbook = excelApp.Workbooks.Open(ExcelLoadPath);

        //TELL THE PROGRAM WHAT WORKBOOK TO OPEN
        // select the right worksheet.
        var Worksheet = excelWorkbook.Sheets[WorksheetName];
      
        // DataCells
        int RowsCount = DataTable.Rows.Count;
        object[,] Cells = new object[RowsCount, ColumnsCount];

        for (int j = 0; j < RowsCount; j++)
            for (int i = 0; i < ColumnsCount; i++)
                Cells[j, i] = DataTable.Rows[j][i];

        //find last row
        var xlRange = (Excel.Range)Worksheet.Cells[Worksheet.Rows.Count, 1];
        long lastRow = (long)xlRange.get_End(Excel.XlDirection.xlUp).Row;
        long newRow = lastRow + 1;

        ///cells[2,1] needs to become cell below last paste
        Worksheet.Range((Microsoft.Office.Interop.Excel.Range)(Worksheet.Cells[newRow, 1]), (Microsoft.Office.Interop.Excel.Range)(Worksheet.Cells[newRow + RowsCount -1, ColumnsCount])).Value = Cells;


        // check fielpath
        if (ExcelSavePath != null && ExcelSavePath != "")
        {
            try
            {
                Worksheet.SaveAs(ExcelSavePath);
                excelApp.Quit();
               // Worksheet.Close(0);
                //richTextBox1("Excel file saved!");
            }
            catch (Exception ex)
            {
                throw new Exception("ExportToExcel: Excel file could not be saved! Check filepath.\n"
                    + ex.Message);
                excelApp.Quit();
            }
        }
        else    // no filepath is given
        {
            excelApp.Visible = true;
        }
        excelApp.Quit();
    }
    catch (Exception ex)
    {
        throw new Exception("ExportToExcel: \n" + ex.Message);
        
    }
}

核心原因 #

1. 异常分支资源未清理：保存文件的catch块中，throw语句会直接中断代码，后续的excelApp.Quit()永远无法执行，导致Excel进程残留。
2. COM对象未显式释放：Interop.Excel的Application、Workbook、Worksheet、Range等都是COM对象，.NET GC无法直接回收，必须显式释放。
3. 保存方法调用错误：调用Worksheet.SaveAs会创建新工作簿，原工作簿资源无法正常释放，应该使用Workbook.SaveAs。
4. 未关闭工作簿：退出Excel前未关闭打开的Workbook，导致资源占用。

修复后的ExportToExcelDetailed方法 #

using System.Runtime.InteropServices; // 需添加此命名空间

public static void ExportToExcelDetailed(this System.Data.DataTable DataTable, string ExcelLoadPath, string WorksheetName, string ExcelSavePath)
{
    Excel.Application excelApp = null;
    Excel.Workbook excelWorkbook = null;
    Excel.Worksheet worksheet = null;
    Excel.Range xlRange = null;
    Excel.Range targetRange = null;

    try
    {
        int ColumnsCount;
        if (DataTable == null || (ColumnsCount = DataTable.Columns.Count) == 0)
            throw new Exception("ExportToExcel: Null or empty input table!");

        excelApp = new Excel.Application();
        excelWorkbook = excelApp.Workbooks.Open(ExcelLoadPath);
        worksheet = excelWorkbook.Sheets[WorksheetName] as Excel.Worksheet;

        if (worksheet == null)
            throw new Exception($"ExportToExcel: Worksheet {WorksheetName} not found!");

        // 填充数据到对象数组
        int RowsCount = DataTable.Rows.Count;
        object[,] Cells = new object[RowsCount, ColumnsCount];
        for (int j = 0; j < RowsCount; j++)
            for (int i = 0; i < ColumnsCount; i++)
                Cells[j, i] = DataTable.Rows[j][i];

        // 找到最后一行
        xlRange = worksheet.Cells[worksheet.Rows.Count, 1] as Excel.Range;
        long lastRow = (long)xlRange.get_End(Excel.XlDirection.xlUp).Row;
        long newRow = lastRow + 1;

        // 获取目标范围并赋值
        targetRange = worksheet.Range[worksheet.Cells[newRow, 1], worksheet.Cells[newRow + RowsCount - 1, ColumnsCount]] as Excel.Range;
        targetRange.Value = Cells;

        // 保存并处理显示逻辑
        if (!string.IsNullOrEmpty(ExcelSavePath))
        {
            excelWorkbook.SaveAs(ExcelSavePath); // 改为Workbook保存
        }
        else
        {
            excelApp.Visible = true;
        }
    }
    catch (Exception ex)
    {
        throw new Exception($"ExportToExcel: {ex.Message}");
    }
    finally
    {
        // 按从底层到顶层的顺序释放所有COM对象
        if (targetRange != null)
        {
            Marshal.ReleaseComObject(targetRange);
            targetRange = null;
        }
        if (xlRange != null)
        {
            Marshal.ReleaseComObject(xlRange);
            xlRange = null;
        }
        if (worksheet != null)
        {
            Marshal.ReleaseComObject(worksheet);
            worksheet = null;
        }
        if (excelWorkbook != null)
        {
            excelWorkbook.Close(); // 关闭工作簿
            Marshal.ReleaseComObject(excelWorkbook);
            excelWorkbook = null;
        }
        if (excelApp != null)
        {
            excelApp.Quit();
            Marshal.ReleaseComObject(excelApp);
            excelApp = null;
        }
    }
}

额外说明 #

• 错误0x800AC472由COM对象资源泄漏导致，修复对象释放逻辑后即可解决。
• finally块确保无论是否发生异常，所有COM对象都会被释放，Excel进程能正常退出。
• 按钮点击事件中的GC代码可保留，作为资源回收的补充。

内容的提问来源于stack exchange，提问作者Zuries