015集——c# 实现CAD excel交互（CAD—C#二次开发入门）

 第一步：添加引用 程序集—>扩展

 

namespace WindowsFormsApp2
{public partial class Form1 : Form{public Form1(){InitializeComponent();}private void Form1_Load(object sender, EventArgs e){}private void 获取当前excel_Click(object sender, EventArgs e){try{//后期绑定获取当前exceldynamic Excelapp = System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application");//object换成动态dynamicExcelapp.visible = true;dynamic wbk = Excelapp.Workbooks.Add();dynamic wst = wbk.Worksheets[1];//com中数组第一个item是1wst.Name = "dz";string[] title = new string[] { "姓名", "年龄", "住所" };wst.Range["A1:C1"].Value = title;}catch (Exception){MessageBox.Show(" 错了");}}private void 关闭当前excel_Click(object sender, EventArgs e){dynamic Excelapp = System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application");//object换成动态dynamic//Excelapp.DisplayAlerts = false;Excelapp.Quit();Excelapp.Quit();}private void 打开excel_Click(object sender, EventArgs e){System.Type ET = System.Type.GetTypeFromProgID("Excel.Application");dynamic Excelapp = System.Activator.CreateInstance(ET);Excelapp.visible = true;dynamic wbk = Excelapp.Workbooks.Add();dynamic wst = wbk.Worksheets[1];//com中数组第一个item是1wst.Name = "dz";string[] title = new string[] { "姓名", "年龄", "住所" };wst.Range["A1:C1"].Value = title;}private void 关闭窗口_Click(object sender, EventArgs e){this.Close();}}
}