/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void lblResult_Click(object sender, EventArgs e) { //打开改文件 MyExcel myExcel = new MyExcel(xlsFilePath); AppManagement.add(myExcel.open(true)); }
/// <summary> /// /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void showTemplateToolStripMenuItem_Click(object sender, EventArgs e) { if (null == myExcel) { myExcel = new MyExcel(DownloadExcelTemplate.path); } AppManagement.add(myExcel.open(true)); }
/// <summary> /// /// </summary> public int openWithoutAlerts(bool isVisible = false) { if (!File.Exists(_path)) { MessageBox.Show("此Excel不存在!", "提示:", MessageBoxButtons.OK, MessageBoxIcon.Information); return(0); } _app = new Microsoft.Office.Interop.Excel.ApplicationClass(); _app.Visible = isVisible; _app.DisplayAlerts = false; try { WBook = _app.Workbooks.Open(this._path, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing); } catch (Exception ex) { MessageBox.Show(ex.ToString()); if (WBook != null) { WBook.Close(true, _path, Type.Missing); } //退出excel _app.Quit(); //释放资源 if (WBook != null) { System.Runtime.InteropServices.Marshal.ReleaseComObject(WBook); } System.Runtime.InteropServices.Marshal.ReleaseComObject(_app); //调用GC的垃圾回收方法 GC.Collect(); GC.WaitForPendingFinalizers(); return(0); } _HwndOfApp = _app.Hwnd; AppManagement.add(_HwndOfApp); return(_app.Hwnd); }