2021-03-11 C#操作Excel对象

C#操作Excel对象

添加引用

1.通过com添加引用EXCEL，这样就加载号对应的引用

然后在代码块中添加引用

using Excel = Microsoft.Office.Interop.Excel;

获取当前Excell

using System;
using System.Windows.Forms;
using Excel = Microsoft.Office.Interop.Excel;

namespace WindowsFormsApp1
{
    public partial class Form1 : Form
    {
        Excel.Application app;  //创建一个excel应用类型名为app
        public Form1()
        {
            InitializeComponent();
        }

        private void button1_Click(object sender, EventArgs e)
        {
            app = System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.application") as Excel.Application;     //用app接收正在运行中的excel应用
        	MessageBox.Show(app.Workbooks.Item[1].Name);	//获取当前允许中wookbook的名字
        }
    }
}

常用的语句

Excel.Range rg;					//定义一个单元格变量
rg = app.Range["A1:C5"];		//将"A1:C5"区域赋值给变量
rg.Select();					//选定区域
rg.Interior.Color = Color.Yellow;	//设定前景色
rg.Font.Color = Color.Red;		//设置字体颜色

foreach (Excel.Workbook workbook in app.Workbooks)  	//遍历工作簿
{
    MessageBox.Show(workbook.Name);
}
Excel.Worksheet sht = app.Worksheets[1];		//获取表方法一
sht = app.Worksheets["mysheet"];				//获取表方法二

添加事件

sht.SelectionChange += MyEvent;			//绑定一个函数
private void MyEvent(Range Target)
{
    Target.Interior.Color = Color.Yellow;
}
sht.SelectionChange -= MyEvent;			//取消绑定一个函数
Color.Yellow;
}
sht.SelectionChange -= MyEvent;			//取消绑定一个函数