Spire.XLS, a professional and powerful .NET/Silverlight Excel component can help us easily drawing Excel borders. Make sure Spire.XLS and Visual Studio are correctly installed on system. Follow the simple steps below to draw Excel borders.
Step 1 Create Project
Create a C# project in Visual Studio and Add Spire.Pdf.dll as reference. The default setting of Spire.Pdf.dll is placed under "C:\Program Files\e-iceblue\Spire.Pdf\Bin”. Select assembly Spire.Pdf.dll and click OK to add it to the project.
using Spire.Xls;
namespace FilesMerge
{
class Program
{
static void Main(string[] args)
{
}
}
}
Step 2 Create an Excel Spreadsheet
Spire.XS allows Excel developers create Excel file. Here we can create an Excel spreadsheet for later using on drawing Excel borders.
Workbook workbook = new Workbook();
Worksheet sheet = workbook.Worksheets[0];
Step 3 Drawing Excel Borders
Spire.XLS provides many border styles and almost all color choices. Now, drawing Excel borders at will.
Thick Borders with Read Color
//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);
Double Borders with Green Color
//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;
Medium Borders with Hot-Pink Color
//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;
Dashed Borders with Yellow Color
//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;
Hair-like Borders with Sea Green Color
//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;
Slanted Dash Dot Borders with Blue Color
//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;
Step 4 Save and Preview
After finish drawing borders design, use the code below to save and preview.
workbook.SaveToFile("sample.xls", ExcelVersion.Version97to2003);
System.Diagnostics.Process.Start(workbook.FileName);
Press F5 to start the project, an Excel file with borders designed will be automatically generated.
Effective Screenshot:
Spire.XLS is a professional Excel component which enables developers/programmers to fast generate, read, write and modify Excel document for .NET and Silverlight. It supports C#, VB.NET, ASP.NET, ASP.NET MVC and Silverlight. Click to learn more…