删除Excel内指定sheet代码,CSharp代码库,德仔网

代码语言

代码分类

【CSharp】删除Excel内指定sheet

作者:明昊 / 发布于2015/3/24/ 530


	#region 删除Excel文件中指定的Sheet
	 public bool DeleteExcelSheet(string pExcelPath, string pSheetName, out string pDeleteSheet)
	 {
	 try
	 {
	 object objOpt = Missing.Value;
	 //打开一个Excel应用
	 Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
	 if (app == null)
	 {
	 throw new Exception("打开Excel应用时发生错误！");
	 }
	 app.Visible = false;
	 Microsoft.Office.Interop.Excel.Workbooks wbs = app.Workbooks;
	 Microsoft.Office.Interop.Excel._Workbook wb = wbs.Open(pExcelPath, 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);
	 wb.EnableAutoRecover = false;
	 Microsoft.Office.Interop.Excel.Sheets shs = wb.Sheets;
	 Microsoft.Office.Interop.Excel._Worksheet sh = (Microsoft.Office.Interop.Excel._Worksheet)shs.get_Item(pSheetName);
	 app.DisplayAlerts = false;
	 sh.Delete();
	 wb.Save();
	 pDeleteSheet = string.Empty;
	 return true;
	 }
	 catch (Exception vErr)
	 {
	 pDeleteSheet = vErr.Message;
	 return false;
	 }
	 finally
	 {
	 KillProcess();
	 }
	 }
	 //强制清除Excel系统进程
	 public void KillProcess()
	 {
	 try
	 {
	 foreach (System.Diagnostics.Process p in System.Diagnostics.Process.GetProcessesByName("Excel"))
	 {
	 if (!p.CloseMainWindow())
	 {
	 p.Kill();
	 }
	 }
	 GC.Collect();
	 }
	 catch (Exception vErr)
	 {
	 throw new Exception("",vErr);
	 }
	 }
	 #endregion

评论列表

本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。

试试其它关键字

　删除Excel　　sheet　

同语言下

可能有用的

明昊贡献的其它代码(13)