我正在使用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/

10-12 00:30
查看更多