Spire.XLS for .NET is a professional Excel .NET library that can be used to any type of .NET( C#, VB.NET, ASP.NET, .NET Core) application, both ASP.NET web sites and Windows Forms application.

Mon Jun 23, 2008 9:19 pm

Hi,
I'm trying to add a double lined border to my worksheet, that is only on the top, and left line of the cell, none of your examples have a border in them, please explain how to do this.

Thank You

chadmilden
 
Posts: 1
Joined: Mon Jun 23, 2008 9:13 pm

Tue Jun 24, 2008 8:28 am

Maybe this could help:

Code: Select all
Workbook workbook = new Workbook();
CellStyle borderStyle = workbook.Styles.Add("borderStyle");
borderStyle.Borders[BordersLineType.EdgeLeft].LineStyle = LineStyleType.Double;
borderStyle.Borders[BordersLineType.EdgeRight].LineStyle = LineStyleType.Thin;
borderStyle.Borders[BordersLineType.EdgeTop].LineStyle = LineStyleType.Double;
borderStyle.Borders[BordersLineType.EdgeBottom].LineStyle = LineStyleType.Thin;

pb
 
Posts: 14
Joined: Fri Jun 20, 2008 11:05 am

Return to Spire.XLS