工作表中划分不同行列的横线和竖线被称为网格线,某个单元格或某个区域的网格线通常被称为边框。本文将介绍如何为单元格或区域设置边框样式,以及如何隐藏工作表的网格线。
设置边框样式
C#
//创建Workbook对象,获取第一个工作表
Workbook wb = new Workbook();
Worksheet sheet = wb.Worksheets[0];
//选择区域(在区域B2:D4设置边框样式一)
CellRange range = sheet.Range["B2:D4"];
//应用双线样式
range.Borders.LineStyle = LineStyleType.Double;
//隐藏斜线
range.Borders[BordersLineType.DiagonalDown].LineStyle = LineStyleType.None;
range.Borders[BordersLineType.DiagonalUp].LineStyle = LineStyleType.None;
//设置颜色
range.Borders.Color = Color.Blue;
//选择区域(在区域D7:F9设置边框样式二)
range = sheet.Range["D7:F9"];
//区域内部置应用细线
range.BorderInside(LineStyleType.Thin);
//区域外部置应用中粗线
range.BorderAround(LineStyleType.Medium);
//隐藏斜线
range.Borders[BordersLineType.DiagonalDown].LineStyle = LineStyleType.None;
range.Borders[BordersLineType.DiagonalUp].LineStyle = LineStyleType.None;
//选择区域(在区域F12:H14设置边框样式三)
range = sheet.Range["F12:H14"];
//合并单元格
range.Merge();
//在合并的区域外部置应用细线
range.BorderAround(LineStyleType.Thin);
//在合并的区域底部置应用粗线
range.Borders[BordersLineType.EdgeBottom].LineStyle = LineStyleType.Thick;
//设置颜色
range.Borders.Color = Color.Red;
//保存文档
wb.SaveToFile("result.xlsx", ExcelVersion.Version2013);
VB.NET
'创建Workbook对象,获取第一个工作表
Dim wb As New Workbook()
Dim sheet As Worksheet = wb.Worksheets(0)
'选择区域(在区域B2:D4设置边框样式一)
Dim range As CellRange = sheet.Range("B2:D4")
'应用双线样式
range.Borders.LineStyle = LineStyleType.[Double]
'隐藏斜线
range.Borders(BordersLineType.DiagonalDown).LineStyle = LineStyleType.None
range.Borders(BordersLineType.DiagonalUp).LineStyle = LineStyleType.None
'设置颜色
range.Borders.Color = Color.Blue
'选择区域(在区域D7:F9设置边框样式二)
range = sheet.Range("D7:F9")
'区域内部置应用细线
range.BorderInside(LineStyleType.Thin)
'区域外部置应用中粗线
range.BorderAround(LineStyleType.Medium)
'隐藏斜线
range.Borders(BordersLineType.DiagonalDown).LineStyle = LineStyleType.None
range.Borders(BordersLineType.DiagonalUp).LineStyle = LineStyleType.None
'选择区域(在区域F12:H14设置边框样式三)
range = sheet.Range("F12:H14")
'合并单元格
range.Merge()
'在合并的区域外部置应用细线
range.BorderAround(LineStyleType.Thin)
'在合并的区域底部置应用粗线
range.Borders(BordersLineType.EdgeBottom).LineStyle = LineStyleType.Thick
'设置颜色
range.Borders.Color = Color.Red
'保存文档
wb.SaveToFile("result.xlsx", ExcelVersion.Version2013)
隐藏/取消隐藏网格线
C#
//创建Workbook对象
Workbook wb = new Workbook();
//加载一个现成的Excel文档
wb.LoadFromFile("成绩统计表.xlsx");
//获取第一个工作表
Worksheet sheet = wb.Worksheets[0];
//隐藏网格线
sheet.GridLinesVisible = false;
////显示网格线
//sheet.GridLinesVisible = true;
//保存文档
wb.SaveToFile("result.xlsx", ExcelVersion.Version2013);
VB.NET
'创建Workbook对象
Dim wb As New Workbook()
'加载一个现成的Excel文档
wb.LoadFromFile("成绩统计表.xlsx")
'获取第一个工作表
Dim sheet As Worksheet = wb.Worksheets(0)
'隐藏网格线
sheet.GridLinesVisible = False
'显示网格线
'sheet.GridLinesVisible = true;
'保存文档
wb.SaveToFile("result.xlsx", ExcelVersion.Version2013)