When you use C # To Call Excel to read Excel files, you will often encounter the failure to release resources. After the program ends, many processes in the task manager cannot exit or release in time.
Later, after searching for information, I found a method to release Com Object resources:
System. Runtime. InteropServices. Marshal. ReleaseComObject (Object O)
The latest code has reference like this:
System. Runtime. InteropServices. Marshal. ReleaseComObject (excApp); System. Runtime. InteropServices. Marshal. ReleaseComObject (excWork); System. Runtime. InteropServices. Marshal. ReleaseComObject (excsheet );
Such code cannot completely release an Excel object, because you must release the worksheet object first, then release the workbook, and finally release the entire table object. Modify the preceding statement as follows:
System. Runtime. InteropServices. Marshal. ReleaseComObject (excsheet); System. Runtime. InteropServices. Marshal. ReleaseComObject (excWork); System. Runtime. InteropServices. Marshal. ReleaseComObject (excApp );