Problem saving excel sheet if any cell is still in editing in interop C#

See more:

Windows

WinForms

C#3.5

Dear All,

I have a WinForm application (C#) Where we evaluate the excel worksheet done by the user.

If the user forgot to save the excel sheet then we save all running excel sheets and if the user leaves the cursor in the cell and hit submit then it's not saving the file.

Can anyone please help me?


Thanks

What I have tried:

public static bool SaveExcelFile(IQuestion question, string filename, string sheetName)
        {
            ExcelInterop.Application excelApplication = null;
            try
            {
                /* Ref: https://stackoverflow.com/questions/7916711/get-the-current-workbook-object-in-c-sharp */
                excelApplication = (ExcelInterop.Application)Marshal.GetActiveObject("Excel.Application");
                excelApplication.Visible = true;
                excelApplication.DisplayAlerts = false;
                excelApplication.ScreenUpdating = false;

                ExcelInterop.Workbook excelWorkbook = excelApplication.ActiveWorkbook;
                ExcelInterop.Worksheet excelWorksheet = excelWorkbook.Sheets[sheetName];

                if (excelWorksheet != null)
                {
                    excelWorkbook.Close(true, filename);
                }

                return true;
            }
            catch (Exception)
            {
                return false;
            }
            finally
            {
                QuitApplication(excelApplication);
            }
        }