关于防止Excel文档被编辑的方法。
第一种方法是设置Workbook的Final属性为True。这样整个文档就只读了。但是这样的话文档会提示你是否取消只读(实际上与没设一个样。)
第二种方法是编辑Workbook的BeforSave事件。在BeforSave事件中将Cancel设为True。这样的话在你关闭Excel时只要你有任何操作,不管事前你点了保存按钮与否它都会跳出提示框要你保存文档(你当然要点保存了——虽然什么改动都不会被保存,不然就没法退出Excel了)。想取消这个设置是个技术活。用它对付小白估计是够用了。
相关代码:
using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Text; using System.Windows.Forms; using System.Xml.Linq; using Microsoft.Office.Tools.Excel; using Microsoft.VisualStudio.Tools.Applications.Runtime; using Excel = Microsoft.Office.Interop.Excel; using Office = Microsoft.Office.Core; namespace ExcelWorkbook8 { public partial class ThisWorkbook { private void ThisWorkbook_Startup(object sender, System.EventArgs e) { Excel.Workbook objWorkbook = Application.ActiveWorkbook; objWorkbook.Final = true; } private void ThisWorkbook_Shutdown(object sender, System.EventArgs e) { } #region VSTO Designer generated code /// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InternalStartup() { this.Startup += new System.EventHandler(ThisWorkbook_Startup); this.Shutdown += new System.EventHandler(ThisWorkbook_Shutdown); } #endregion } }
using System; using System.Collections.Generic; using System.Data; using System.Linq; using System.Text; using System.Windows.Forms; using System.Xml.Linq; using Microsoft.Office.Tools.Excel; using Microsoft.VisualStudio.Tools.Applications.Runtime; using Excel = Microsoft.Office.Interop.Excel; using Office = Microsoft.Office.Core; namespace ExcelWorkbook8 { public partial class ThisWorkbook { private void ThisWorkbook_Startup(object sender, System.EventArgs e) { Excel.Workbook objWorkbook = Application.ActiveWorkbook; objWorkbook.BeforeSave += new Excel.WorkbookEvents_BeforeSaveEventHandler( objWorkbook_BeforeSave); } void objWorkbook_BeforeSave(bool SaveAsUI, ref bool Cancel) { Cancel = true; } private void ThisWorkbook_Shutdown(object sender, System.EventArgs e) { } #region VSTO Designer generated code /// <summary> /// Required method for Designer support - do not modify /// the contents of this method with the code editor. /// </summary> private void InternalStartup() { this.Startup += new System.EventHandler(ThisWorkbook_Startup); this.Shutdown += new System.EventHandler(ThisWorkbook_Shutdown); } #endregion } }
征诛志异,三让两家王朝;功同开辟,一桮万古江南。