Excel操控方法之Com组件

最新推荐文章于 2023-07-23 20:25:31 发布

CarlosWood

最新推荐文章于 2023-07-23 20:25:31 发布

阅读量5.3k

点赞数 2

分类专栏： C# 文章标签： Com组件 Microsoft.Office.Int Excel读写超链接Hyperlink 背景颜色

本文链接：https://blog.csdn.net/AdairXY/article/details/51849323

版权

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