c#到处excel加边框；
 例如：
     导出的excel中A4到G22要加边框，其他无需加边框   怎么能做到
 求大侠们給解。  
                          谢谢！

   自己先顶一下  大侠们  帮帮忙   
                  在此谢过

Range range = wsh.get_Range(wsh.Cells[4, 1], wsh.Cells[22, 7]);    //获取A4到G22的单元格Range对象
range.Select();    //选中该Range对象中的单元格
range.Borders.LineStyle = 1;    //设置该Range对象中单元格的边框线，数字1为细实线
注:wsh的类型为_Worksheet

你可以考虑使用动态调用Excel，他的好处是
1.只要有安装excel就一定可以使用，不用分辨版本。
2.excel的功能一定有支援，而且相关的资料网路上可以找到。
3.理论上也应该是系统问题最少的。

当然也会有缺点
1.程式看起来比较复杂
2.执行速度会比较慢

private void button1_Click(object sender, EventArgs e)
    {
     object objApp;
     object objBook;
     object objBooks;
     object objSheets;
     object objSheet;
     object objRange;
     object objCells;
     object[] Parameters;
     try {
         // 获取Excel类型并建立其实例
         Type objExcelType = Type.GetTypeFromProgID("Excel.Application");
         if (objExcelType == null)
         {
             return;
         }
         objApp = Activator.CreateInstance(objExcelType);
         if (objApp == null)
         {
          return;
         }
         //获取Workbook集
         objBooks = objApp.GetType().InvokeMember("Workbooks", BindingFlags.GetProperty, null, objApp, null);
         //添加一个新的Workbook
         objBook = objBooks.GetType().InvokeMember("Add", BindingFlags.InvokeMethod, null, objBooks, null);
         //获取Sheet集
         objSheets = objBook.GetType().InvokeMember("Worksheets", BindingFlags.GetProperty, null, objBook, null);
         //获取第一个Sheet对象
         Parameters = new Object[1]
         {
          1
         };
         objSheet = objSheets.GetType().InvokeMember("Item", BindingFlags.GetProperty, null, objSheets, Parameters);
         try
         {
          //获取操作范围
          for (int i = 1; i < 100; i++)
          {
           Parameters = new Object[2] { 1, i };
           objCells = objSheet.GetType().InvokeMember("Cells", BindingFlags.GetProperty, null, objSheet, Parameters);
           //向指定单元格填写内容值
           Parameters = new Object[1] { "Hello, World!" };
           objCells.GetType().InvokeMember("Value", BindingFlags.SetProperty, null, objCells, Parameters);
          }
         }
         catch (Exception operException)
         {
          MessageBox.Show(operException.Message);
         }
         finally
         {
          //不提示保存
          Parameters = new Object[1] { false };
          objApp.GetType().InvokeMember("DisplayAlerts", BindingFlags.SetProperty, null, objApp, Parameters);
          //保存文件并退出
          Parameters = new Object[1] { @"D:\a.xls" };
          objBook.GetType().InvokeMember("SaveAs", BindingFlags.InvokeMethod, null, objBook, Parameters);
          objApp.GetType().InvokeMember("Quit", BindingFlags.InvokeMethod, null, objApp, null);
          GC.Collect();
         }
     }
     catch (Exception theException)
     {
      String errorMessage;
      errorMessage = "Error: ";
      errorMessage = String.Concat(errorMessage, theException.Message);
      errorMessage = String.Concat(errorMessage, " Line: ");
      errorMessage = String.Concat(errorMessage, theException.Source);
      MessageBox.Show(errorMessage, "Error");
     }
    }

另外这里有我依样画葫芦從BCB6弄出来的C#版[检查 excel 的版本]
https://bbs.bccn.net/thread-357133-1-1.html