如何处理excel工作表中的另存为对话框在C＃中

Question

我想在excel表格中写几行然后使用简单的c＃程序保存。但每次显示对话框时都会显示“您想保存该文件吗？”是，不，取消选项。我想选择“是”，以便可以使用更新的数据保存文件。

下面是代码：

string ID = "123456"; 

Microsoft.Office.Interop.Excel.Application xlApp; 
Microsoft.Office.Interop.Excel.Workbook xlWorkBook; 
Microsoft.Office.Interop.Excel.Worksheet xlWorkSheet; 
xlApp = new Microsoft.Office.Interop.Excel.Application(); 
      xlWorkBook = xlApp.Workbooks.Open(@"D:\Projects\Data\DataSheet.xlsx", 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0); 
      xlWorkSheet = 
(Microsoft.Office.Interop.Excel.Worksheet) xlWorkBook.Worksheets["source"]; 
//putting the value in excel. 
xlWorkSheet.Cells[2, 2] = ID; 

xlApp.Visible = true; 
//xlApp.ActiveWorkbook.save(); 

xlWorkBook.SaveAs(@"D:\Projects\Data\DataSheet.xlsx", Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookDefault, Type.Missing, Type.Missing, 
     false, false, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, 
     Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); 

xlWorkBook.Close(false, Type.Missing, Type.Missing); 
xlApp.Workbooks.Close(); 
System.Runtime.InteropServices.Marshal.ReleaseComObject(xlWorkBook); 

xlApp.Quit(); 
GC.Collect(); 
System.Runtime.InteropServices.Marshal.ReleaseComObject(xlApp); 

它在Excel工作表中输入数值，但它不保存它。有人可以帮助缩短这个问题吗？或者建议更好的方法？

Answer 1

尝试Saved属性手动设置为true：

xlWorkBook.SaveAs(...); 
xlWorkBook.Saved = true; 
xlApp.Workbooks.Close() //not sure if required before: xlWorkBook.Close() 

---

编辑

你可以提供参数the Close() method。在C＃中，我相信这应该是这样的：

xlWorkBook.SaveAs(...); 
xlWorkBook.Saved = true; 
xlWorkBook.Close(false); //new line 
xlApp.Workbooks.Close(); OR xlApp.Workbooks.Close(false);