- Demo
- C# source
- VB.Net source
The sample demonstrates how to design borders in Excel workbook via Spire.XLS.
using Spire.Xls; using System.Drawing; namespace Borders { class Program { static void Main(string[] args) { //create a workbook Workbook workbook = new Workbook(); Worksheet sheet = workbook.Worksheets[0]; sheet.Range["B2"].Text = "Home Page"; //set the border of Range["B2"] sheet.Range["B2"].Borders.LineStyle = LineStyleType.Thick; sheet.Range["B2"].Borders[BordersLineType.DiagonalDown].LineStyle = LineStyleType.None; sheet.Range["B2"].Borders[BordersLineType.DiagonalUp].LineStyle = LineStyleType.None; sheet.Range["B2"].Borders.Color = Color.Red; sheet.AutoFitColumn(2); //set the border of Range["C4"] sheet.Range["C4"].Borders.LineStyle = LineStyleType.Double; sheet.Range["C4"].Borders[BordersLineType.DiagonalUp].LineStyle = LineStyleType.None; sheet.Range["C4"].Borders[BordersLineType.DiagonalDown].LineStyle = LineStyleType.None; sheet.Range["C4"].Borders.Color = Color.Green; //set the border of Range["D6"] sheet.Range["D6"].Borders.LineStyle = LineStyleType.Medium; sheet.Range["D6"].Borders[BordersLineType.DiagonalDown].LineStyle = LineStyleType.None; sheet.Range["D6"].Borders[BordersLineType.DiagonalUp].LineStyle = LineStyleType.None; sheet.Range["D6"].Borders.Color = Color.HotPink; //set the border of Range["E8"] sheet.Range["E8"].Borders.LineStyle = LineStyleType.Dashed; sheet.Range["E8"].Borders[BordersLineType.DiagonalDown].LineStyle = LineStyleType.None; sheet.Range["E8"].Borders[BordersLineType.DiagonalUp].LineStyle = LineStyleType.None; sheet.Range["E8"].Borders.Color = Color.Yellow; //set the border of Range["F10"] sheet.Range["F10"].Borders.LineStyle = LineStyleType.Hair; sheet.Range["F10"].Borders[BordersLineType.DiagonalDown].LineStyle = LineStyleType.None; sheet.Range["F10"].Borders[BordersLineType.DiagonalUp].LineStyle = LineStyleType.None; sheet.Range["F10"].Borders.Color = Color.SeaGreen; //set the border of Range["D6"] sheet.Range["G12"].Borders.LineStyle = LineStyleType.SlantedDashDot; sheet.Range["G12"].Borders[BordersLineType.DiagonalDown].LineStyle = LineStyleType.None; sheet.Range["G12"].Borders[BordersLineType.DiagonalUp].LineStyle = LineStyleType.None; sheet.Range["G12"].Borders.Color = Color.Blue; workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003); System.Diagnostics.Process.Start(workbook.FileName); } } }
Imports Spire.Xls Imports System.Drawing Namespace Borders Friend Class Program Shared Sub Main(ByVal args() As String) 'create a workbook Dim workbook As New Workbook() Dim sheet As Worksheet = workbook.Worksheets(0) sheet.Range("B2").Text = "Home Page" 'set the border of Range["B2"] sheet.Range("B2").Borders.LineStyle = LineStyleType.Thick sheet.Range("B2").Borders(BordersLineType.DiagonalDown).LineStyle = LineStyleType.None sheet.Range("B2").Borders(BordersLineType.DiagonalUp).LineStyle = LineStyleType.None sheet.Range("B2").Borders.Color = Color.Red sheet.AutoFitColumn(2) 'set the border of Range["C4"] sheet.Range("C4").Borders.LineStyle = LineStyleType.Double sheet.Range("C4").Borders(BordersLineType.DiagonalUp).LineStyle = LineStyleType.None sheet.Range("C4").Borders(BordersLineType.DiagonalDown).LineStyle = LineStyleType.None sheet.Range("C4").Borders.Color = Color.Green 'set the border of Range["D6"] sheet.Range("D6").Borders.LineStyle = LineStyleType.Medium sheet.Range("D6").Borders(BordersLineType.DiagonalDown).LineStyle = LineStyleType.None sheet.Range("D6").Borders(BordersLineType.DiagonalUp).LineStyle = LineStyleType.None sheet.Range("D6").Borders.Color = Color.HotPink 'set the border of Range["E8"] sheet.Range("E8").Borders.LineStyle = LineStyleType.Dashed sheet.Range("E8").Borders(BordersLineType.DiagonalDown).LineStyle = LineStyleType.None sheet.Range("E8").Borders(BordersLineType.DiagonalUp).LineStyle = LineStyleType.None sheet.Range("E8").Borders.Color = Color.Yellow 'set the border of Range["F10"] sheet.Range("F10").Borders.LineStyle = LineStyleType.Hair sheet.Range("F10").Borders(BordersLineType.DiagonalDown).LineStyle = LineStyleType.None sheet.Range("F10").Borders(BordersLineType.DiagonalUp).LineStyle = LineStyleType.None sheet.Range("F10").Borders.Color = Color.SeaGreen 'set the border of Range["D6"] sheet.Range("G12").Borders.LineStyle = LineStyleType.SlantedDashDot sheet.Range("G12").Borders(BordersLineType.DiagonalDown).LineStyle = LineStyleType.None sheet.Range("G12").Borders(BordersLineType.DiagonalUp).LineStyle = LineStyleType.None sheet.Range("G12").Borders.Color = Color.Blue workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003) System.Diagnostics.Process.Start(workbook.FileName) End Sub End Class