using Microsoft.Office.Interop.Excel;
using System;
using System.Diagnostics;
using System.Drawing;
using System.Linq;
using System.Runtime.InteropServices;
using System.Text;
using System.Windows.Forms;
namespace ComTest
{
public class MSExcel
{
//Excel重要元素节点
private Microsoft.Office.Interop.Excel.Application app;
private Workbooks workbooks;
private Workbook workbook;
private string excelPath;
public MSExcel(string excelPath)
{
init();
this.excelPath = excelPath;
}
//Excel
private void init()
{
app = new Microsoft.Office.Interop.Excel.Application();
app.Visible = false;
workbooks = app.Workbooks;
}
//载入Excel
public bool LoadExcel()
{
workbook = workbooks.Open(excelPath);
return !workbook.ReadOnly;
}
//创建Excel
public void CreateExcel(string worksheetName)
{
workbook = workbooks.Add(true);
((Worksheet)workbook.Worksheets[1]).Name = worksheetName;
workbook.SaveAs(excelPath);
}
//强制杀掉Excel的所有进程
public void KillExcel()
{
Close();
Dispose();
Process[] procs = Process.GetProcessesByName("excel");
foreach (Process pro in procs)
{
pro.Kill();
}
init();
LoadExcel();
Save();
Clo