我正在使用iceblue Spire.XLS
dll
使用C#创建和生成Excel文档
我想知道如何设置特定单元格或单元格范围的边框样式(仅左或右样式!)。
在上面的代码中,我设法设置了字体,对齐方式和其他内容
但我不知道如何设置左右边框样式:
Workbook workbook = new Workbook();
workbook.LoadFromStream(templateDocument);
Worksheet sheet = workbook.Worksheets["sheet_name"];
sheet.Range[row, 1, row, 4].Merge();
sheet.Range[row, 1, row, 4].Style.HorizontalAlignment = HorizontalAlignType.Center;
sheet.Range[row, 1, row, 4].Style.VerticalAlignment = VerticalAlignType.Center;
sheet.Range[row, 1, row, 4].Style.Font.Size = 14;
sheet.Range[row, 1, row, 4].Style.Font.Color =Color.White;
sheet.Range[row, 1, row, 4].Style.Interior.Color = Color.Gray;
// syntax to achive styling border ??
//sheet.Range[row, 1, row, 4].Borders. = ?
问候 。
最佳答案
是的,您可以做到:
对于所有边界:
一个单元格:
sheet.Range[row,col].Style.Borders.LineStyle = LineStyleType.Thin;
sheet.Range[row,col].Style.Borders.Color = Color.Black;
单元格范围:
sheet.Range[beginRow, beginCol, endRow, endCol].Style.Borders.LineStyle =LineStyleType.Thin;
sheet.Range[beginRow, beginCol, endRow, endCol].Style.Borders.Color = Color.Black;
对于特定的边界Edge :(左上右下)
一个单元格:
//right border
sheet.Range[row,col].Style.Borders[BordersLineType.EdgeRight].LineStyle = LineStyleType.Thin;
sheet.Range[row,col].Style.Borders[BordersLineType.EdgeRight].Color = Color.Black;
//left border
sheet.Range[row,col].Style.Borders[BordersLineType.EdgeLeft].LineStyle = LineStyleType.Thin;
sheet.Range[row,col].Style.Borders[BordersLineType.EdgeLeft].Color = Color.Black;
单元格范围:
//right border
sheet.Range[beginRow, beginCol, endRow, endCol].Style.Borders[BordersLineType.EdgeRight].LineStyle = LineStyleType.Thin;
sheet.Range[beginRow, beginCol, endRow, endCol].Style.Borders.Color = Color.Black;
//left border
sheet.Range[beginRow, beginCol, endRow, endCol].Style.Borders[BordersLineType.EdgeLeft].LineStyle = LineStyleType.Thin;
sheet.Range[beginRow, beginCol, endRow, endCol].Style.Borders.Color = Color.Black;
关于c# - 如何将左右边框样式设置为Excel单元格(Spire.xls库),我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/38480656/