会创建当然少不了删除了,接下来我们接着删除指定的工作表吧。
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Microsoft.Office.Interop.Excel;
using System.Diagnostics;
using System.Reflection;
namespace ConsoleApplication3
{
class EditExcel
{
#region 删除指定的工作表
/// <summary>
/// 删除指定的工作表
/// </summary>
/// <param name="ExcelName"></param>
public void DeleteSheet(string ExcelName)
{
//创建 Excel对象
Application App = new Application();
//获取缺少的object类型值
object missing = Missing.Value;
//打开指定的Excel文件
Workbook openwb = App.Workbooks.Open(ExcelName, missing, missing, missing, missing,
missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);
//删除指定的工作表
Console.WriteLine("请输入你要删除的工作表:");
string sheetName = Console.ReadLine();
((Worksheet)openwb.Worksheets[sheetName]).Delete();
Console.WriteLine("删除成功!");
App.DisplayAlerts = false;//不现实提示对话框
openwb.Save();//保存工作表
App.Visible = true;//显示Excel
openwb.Close(false, missing, missing);//关闭工作表
//创建进程对象
Process[] ExcelProcess = Process.GetProcessesByName("Excel");
//关闭进程
foreach (Process p in ExcelProcess)
{
p.Kill();
}
}
#endregion
}
}
我们可以发现,其实发现很多都是相同的,只有这几行发生了点变化而已!
Console.WriteLine("请输入你要删除的工作表:");
string sheetName = Console.ReadLine();
((Worksheet)openwb.Worksheets[sheetName]).Delete();
Console.WriteLine("删除成功!");
欢迎关注本人的公众号:编程手札,文章也会在公众号更新