How to Use C# Draw Excel Borders
Microsoft Excel Spreadsheet is usually used on dealing with data information. It has been around for years to help us keep the family budget and stock brokers to track up to the minute changes in the New York Stock Exchange. Microsoft Excel Spreadsheet can help organize and facilitate processes throughout your day. To make data information easier to read and understand, most spreadsheets have some sort of formatting applied. Drawing borders around cells is a common formatting task. By drawing borders we can distinguish which information is most vital to a person who is using our spreadsheet. This article shows you how to draw borders in Excel spreadsheet via C#. Read on to learn more details.
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, 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:
More about Spire.XLS
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…
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…