強制停止 Excel Save 時, Overwrite 既 Alert Message
From1.cs |
private void LoadSave_Excel() { Excel.Application xlApp; Excel.Workbook xlWorkBook; Excel.Worksheet xlWorkSheet; String thisFileName = "C:\\result.xls"; xlApp = new Excel.ApplicationClass(); xlWorkBook = xlApp.Workbooks.Open(thisFileName, 0, false, 5, "", "", false, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, 2, false, Type.Missing, 0, false, 1, 0); xlWorkSheet = (Excel.Worksheet)(xlWorkBook.Worksheets.get_Item(1)); xlWorkSheet.Activate(); Object misValue = System.Reflection.Missing.Value; xlApp.DisplayAlerts = false; xlWorkBook.SaveAs(thisFileName, Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue); xlApp.DisplayAlerts = true; xlApp.Visible = true; releaseObject(xlWorkSheet); releaseObject(xlWorkBook); releaseObject(xlApp); } |