Workbook book1 = app1.Workbooks.Open("D:\test.xlsx", Type.Missing,
    Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
    Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,
    Type.Missing, Type.Missing, Type.Missing);
  Worksheet sheet1 = (Worksheet)book1.Sheets["Sheet1"];
  Range rng1 = sheet1.get_Range("A1:C3,E2:G6", Type.Missing);     //设置操作区域为2个不连续区域
  rng1.NumberFormatLocal = "@";
  rng1.Value2 = "2006147214E00045"; //对操作区域赋值
  Range rng2 = sheet1.get_Range("F1:F6", Type.Missing);
  rng2.Value2 = "2006147214E00045";
  app1.DisplayAlerts = false;     //不显示保存对话框
  book1.Save();     //保存
    }
    catch
    {
  app1.Quit();      //结束进程
    }

  }

  private void button3_Click(object sender, EventArgs e)
  {
    Microsoft.Office.Interop.Excel.Application app1 =
  new Microsoft.Office.Interop.Excel.Application();
    app1.Visible = false;    //运行时不显示Excel主窗口
    try
    {
  Workbook book1 = app1.Workbooks.Add(Type.Missing); 
  Worksheet sheet1 = (Worksheet)book1.Sheets[1];
  app1.DisplayAlerts = true;
  //将打开的Excel文件另存:D est.xlsx 格式 xlXMLSpreadsheet(xlsm)、xlOpenXMLWorkbook(xlsx)、 xlExcel12(xlsb)
  book1.SaveAs("D:\test.xlsx", Microsoft.Office.Interop.Excel.XlFileFormat.xlOpenXM