1 using Excel = Microsoft.Office.Interop.Excel;
 2 using Range = Microsoft.Office.Interop.Excel.Range;
 3 using Shape = Microsoft.Office.Interop.Excel.Shape;
 4 var excelApp = new Excel.Application();
 5       var excelApp = new Excel.Application();
 6     Excel.Workbook wb = null;
 7     excelApp.Visible = true;//代码运行时是否显示excel界面
 8     excelApp.DisplayAlerts = false;//代码运行时是否显示警告
 9     excelApp.AlertBeforeOverwriting = false;//覆盖保存的时候是否提示
10     fi = new FileInfo(filepath);
11     var counter = 0;
12     string name = "";
13     try
14     {
15     wb = excelApp.Workbooks.Open(fi.FullName);//打开excel文件。
16     Excel.Worksheet ws = wb.Worksheets[3] as Excel.Worksheet;//选择对应 sheet
17     //var control = ws.Shapes._Default(0);
18     var count = ws.Shapes.Count;//获取总过有多少相关控件，一个控件需要一个shape
19     var chk = ws.CheckBoxes(1);//通过CheckBoxes的下标去获取CheckBox 最大值看excel表格的sheet里面有多少个
20     var chk1 = ws.CheckBoxes(13);//厂标
21     var chk2 = ws.CheckBoxes(14);//特殊要求
22     string PumpColor = "";
23     if (chk1.Value == 1)
24     {
25     PumpColor = chk1.Text + ":" + PumpColorDes;
26     }
27     if (chk2.Value == 1)
28     {
29     PumpColor = chk2.Text + ":" + PumpColorDes;
30     }
31     if (chk1.Value != 1 && chk2.Value != 1)
32     PumpColor = PumpColorDes;
33     this.txtFopResult.Text = PumpColor.Replace("n","rn");
34 }
35     catch (Exception ex)
36     {
37     MessageBox.Show(ex.Message);
38     }
39     finally
40     {
41     excelApp.Quit(); //退出excel应用，否则进程会一直存在
42     excelApp = null;
43     }