shutting down Excel application when Closing wpf window

Question

I have got an excel application running which on parsing the excel sheet displays a wpf window (from other project however in same workspace).

[STAThread]
        public void Run()
        {
            TableStructure = null;

            parser = new ExcelParser.WorksheetParser(TableStructure);

            GeneralTree<string> rawRBS = parser.GetRawTree();

            MainWindow main = new MainWindow(rawRBS, parser.WorkSheet);
            main.ShowDialog();
        }

The problem here is when i close the mainwindow.. closing mainwindow shuts the whole application down along with excel workbook too. I want excel workbook opened even when main window is closed.

Can someone help me here?

Eli Arbel Eli Arbel · Accepted Answer · 2013-11-04T09:20:16

Replace main.ShowDialog() with:

var app = new Application();
app.ShutdownMode = ShutdownMode.OnExplicitShutdown;
app.Run(main);

You should note that unless you've setup a tray icon or some other kind of UI, you'll have no way of shutting down the app (short of killing the process).

shutting down Excel application when Closing wpf window

1 Answers