I have an application that needs to access data in an Excel spreadsheet. I've added a reference to Excel and am able to open Excel with the correct spreadsheet, get the data I need and seemingly, close Excel. The problem is that if I run the program five times when I go to Task Manager I see five instances of Excel running. If I set the Visible property to true, I see Excel open and close. I'm using the following code to close Excel:
excelApp = null;
Does anyone know why I'm getting all these instances of Excel staying open?
Thanks in advance,