/// <summary>
/// 设置边框，包括外部和内部
/// </summary>
/// <param name="startRow"></param>
/// <param name="startColumn"></param>
/// <param name="endRow"></param>
/// <param name="endColumn"></param>
/// <param name="styleLine"></param>
/// <param name="borderWeight"></param>
/// <param name="constants"></param>
public void SetCellBorder(int startRow, int startColumn, int endRow, int endColumn,
ExcelStyleLine styleLine = ExcelStyleLine.Continious, ExcelBorderWeight borderWeight = ExcelBorderWeight.Thin, Constants constants = Constants.xlAutomatic)
{
Range range = GetRange(startRow, startColumn, endRow, endColumn);
range.Select();
// 上边框
range.Borders[(XlBordersIndex)ExcelBordersIndex.EdgeTop].LineStyle = styleLine;
range.Borders[(XlBordersIndex)ExcelBordersIndex.EdgeTop].Weight = borderWeight;
range.Borders[(XlBordersIndex)ExcelBordersIndex.EdgeTop].ColorIndex = constants;
// 下边框
range.Borders[(XlBordersIndex)ExcelBordersIndex.EdgeBottom].LineStyle = styleLine;
range.Borders[(XlBordersIndex)ExcelBordersIndex.EdgeBottom].Weight = borderWeight;
range.Borders[(XlBordersIndex)ExcelBordersIndex.EdgeBottom].ColorIndex = constants;
// 左边框
range.Borders[(XlBordersIndex)ExcelBordersIndex.EdgeLeft].LineStyle = styleLine;
range.Borders[(XlBordersIndex)ExcelBordersIndex.EdgeLeft].Weight = borderWeight;
range.Borders[(XlBordersIndex)ExcelBordersIndex.EdgeLeft].ColorIndex = constants;
// 右边框
range.Borders[(XlBordersIndex)ExcelBordersIndex.EdgeRight].LineStyle = styleLine;
range.Borders[(XlBordersIndex)ExcelBordersIndex.EdgeRight].Weight = borderWeight;
range.Borders[(XlBordersIndex)ExcelBordersIndex.EdgeRight].ColorIndex = constants;
// 内部水平
range.Borders[(XlBordersIndex)ExcelBordersIndex.InsideHorizontal].LineStyle = styleLine;
range.Borders[(XlBordersIndex)ExcelBordersIndex.InsideHorizontal].Weight = borderWeight;
range.Borders[(XlBordersIndex)ExcelBordersIndex.InsideHorizontal].ColorIndex = constants;
// 内部垂直
range.Borders[(XlBordersIndex)ExcelBordersIndex.InsideVertical].LineStyle = styleLine;
range.Borders[(XlBordersIndex)ExcelBordersIndex.InsideVertical].Weight = borderWeight;
range.Borders[(XlBordersIndex)ExcelBordersIndex.InsideVertical].ColorIndex = constants;
}
/// <summary>
/// 设置单个单元格边框
/// </summary>
/// <param name="row">单元格行坐标</param>
/// <param name="column">单元格列坐标</param>
/// <param name="styleLine">线条形态</param>
/// <param name="borderWeight">线条粗细</param>
/// <param name="constants"></param>
public void SetCellBorder(int row, int column,
ExcelStyleLine styleLine = ExcelStyleLine.Continious, ExcelBorderWeight borderWeight = ExcelBorderWeight.Thin, Constants constants = Constants.xlAutomatic)
{
Range range = GetRange(row, column);
range.Select();
// 上边框
range.Borders[(XlBordersIndex)ExcelBordersIndex.EdgeTop].LineStyle = styleLine;
range.Borders[(XlBordersIndex)ExcelBordersIndex.EdgeTop].Weight = borderWeight;
range.Borders[(XlBordersIndex)ExcelBordersIndex.EdgeTop].ColorIndex = constants;
// 下边框
range.Borders[(XlBordersIndex)ExcelBordersIndex.EdgeBottom].LineStyle = styleLine;
range.Borders[(XlBordersIndex)ExcelBordersIndex.EdgeBottom].Weight = borderWeight;
range.Borders[(XlBordersIndex)ExcelBordersIndex.EdgeBottom].ColorIndex = constants;
// 左边框
range.Borders[(XlBordersIndex)ExcelBordersIndex.EdgeLeft].LineStyle = styleLine;
range.Borders[(XlBordersIndex)ExcelBordersIndex.EdgeLeft].Weight = borderWeight;
range.Borders[(XlBordersIndex)ExcelBordersIndex.EdgeLeft].ColorIndex = constants;
// 右边框
range.Borders[(XlBordersIndex)ExcelBordersIndex.EdgeRight].LineStyle = styleLine;
range.Borders[(XlBordersIndex)ExcelBordersIndex.EdgeRight].Weight = borderWeight;
range.Borders[(XlBordersIndex)ExcelBordersIndex.EdgeRight].ColorIndex = constants;
}
