在excel c#上的多个单元格周围添加边框

Question

我目前正在使用Microsoft.Office.Core；并使用Excel = Microsoft.Office.Interop.Excel；将数据从windows表单导出到excel将数据从windows表单c#导出到excel

是否可以在选定的单元格上添加边框，如How i need it to be

Answer 1

当然，这是我为同样的事情做的一个函数

/// <summary>
/// Puts a border around range
/// </summary>
/// <param name="ws">Excel worksheet</param>
/// <param name="r1">First Row</param>
/// <param name="c1">First Column</param>
/// <param name="r2">Last Row</param>
/// <param name="c2">Last Column</param>
/// <param name="weight">Border Brush Weight</param>
public void BorderRange(Worksheet ws, int r1, int c1, int r2, int c2, XlBorderWeight weight = XlBorderWeight.xlThin)
{
    Range r = ws.Range[ws.Cells[r1, c1], ws.Cells[r2, c2]];
    r.BorderAround2(Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous, weight);
}

你需要调用它几次才能在你需要的范围内设置边框。