/// <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; }